Shulou(Shulou.com)06/01 Report--

This article mainly introduces the Ubuntu17.04 through PhpMyAdmin management of remote MySQL database 17.10 method, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian with you to understand.

PhpMyAdmin allows you to manage MySQL or MariaDB databases through a simple Web browser. In most environments, the phpMyAdmin package is installed on the same server as the database server. So you don't need too much configuration there. It should work properly.

However, if you want to manage a MySQL or MariaDB database on a remote server through the phpMyAdmin Web interface, you need to make some changes to its configuration file.

In order to access and manage a remote MySQL or MariaDB server, the server must be configured to allow remote access over the network. The following steps will show you how to do this.

This short tutorial installs and configures phpMyAdmin on Ubuntu 17.04. Access and manage remote MySQL or MariaDB database servers. When you are ready, continue with the following steps:

Step 1: phpMyAdmin and database on the same host

Traditionally, phpMyAdmin and MySQL / MariaDB servers are installed on the same host. This is a standard installation and the most popular.

To install phpMyAdmin on the same host as the database server, run the following command

Sudo apt update

Sudo apt install php libapache2-mod-phpmyadmin

During installation, you should be prompted to select the Web server that you want to configure for phpMyAdmin. For this article, we will use Apache2 as the Web server.

After the installation is complete, open a browser and go to http:// servername / phpmyadmin

Replace the server name with the actual host name of the server. When logging in, the page enters root as the user name and logs in with a password.

This will log you in and allow you to manage the database on the server.

Step 2: phpMyAdmin and databases on different hosts

Step 1 shows the standard phpMyAdmin installation. However, if the database server you are managing is remote, phpMyAdmin must be configured differently.

The configuration file for phpMyAdmin is located in / etc / phpmyadmin. The main configuration file is / etc/phpmyadmin/config.inc.php. This file contains configuration options that apply globally to phpMyAdmin.

To use phpMyAdmin to manage the MySQL database hosted on another server, make the following adjustments in / etc/phpmyadmin/config.inc.php:

Sudo nano / etc/phpmyadmin/config.inc.php

Then change what looks like the following line

I] ['host'] ='

To

Cfg ['Servers'] [

Set

Replace dbserver with the actual remote database server name or IP address. Also, make sure that the phpMyAdmin host has access to the remote database.

Another important configuration file is / etc/phpmyadmin/apache.conf, which is symbolically linked to / etc/apache2/conf-available/phpmyadmin.conf and, once enabled, will be used to configure Apache2 to serve the phpMyAdmin site. This file contains instructions for loading PHP, directory permissions, and so on. From terminal type:

Sudo ln-s / etc/phpmyadmin/apache.conf / etc/apache2/conf-available/phpmyadmin.conf sudo a2enconf phpmyadmin.conf sudo systemctl reload apache2.service

Step 3: configure MySQL Server to allow remote access

PhpMyAdmin is now installed on the client computer and connects to the remote server where the MySQL / MariaDB database is installed. Then run the following command to open its default profile.

Sudo nano / etc/mysql/mysql.conf.d/mysqld.cnf

Then change the following line to:

Bind-address=0.0.0.0

Next run the following command to allow root users to access the server from the client computer.

Sudo mysql-u root-p will

All privileges are turned on to 'root'@'192.168.71.20' identified as' root_password_here'WITHGRANT OPTION

Replace the IP address with the address you want to connect to. Quit and you are done.

After editing the above file, save your changes and log in to http:// clientPC / phpmyadmin

Replace http:// clientPC / phpmyadmin with the client computer IP or hostname.

This should allow you to log in remotely to the server from the client phpMyAdmin Web portal.

This is how to manage remote MySQL / MariaDB servers.

Congratulations! You have successfully configured phpMyAdmin

Thank you for reading this article carefully. I hope the article "how to manage remote MySQL Database 17.10 on Ubuntu17.04 through PhpMyAdmin" shared by the editor will be helpful to you. At the same time, I hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.