Detailed explanation of how to build a multi-database server with phpMyAdmin

This article will use the phpmyadmin tutorial column to introduce you to phpMyAdmin's method of building and managing multiple database servers. I hope it will be helpful to friends in need!

phpMyAdmin builds and manages multiple database servers

Environment description:

系统版本    CentOS 6.9 x86_64        
软件版本    nginx-1.12.2        php-5.5.38        phpMyAdmin 4.8.0.1

1. Introduction to phpMyAdmin

phpMyAdmin is a PHP-based, Web-based -Base mode is a MySQL database management tool built on the website host, allowing administrators to use the Web interface to manage the MySQL database. This web interface can be a better way to input complex SQL syntax in a simple way, especially when it comes to importing and exporting large amounts of data. One of the greater advantages is that phpMyAdmin is executed on the web server like other PHP programs, but you can use the HTML pages generated by these programs anywhere, that is, to remotely manage the MySQL database, and easily create, modify, and delete Databases and data tables. You can also use phpMyAdmin to create commonly used PHP syntax to facilitate the correctness of SQL syntax required when writing web pages.

Official website: https://www.phpmyadmin.net

2. Environmental requirements for installing phpMyAdmin

3. Steps

3.1. Compile and install nginx and php. You can refer to the previous blog post. I will not go into details here. However, based on the environmental requirements of phpMyAdmin, the compilation parameters used when compiling php are:

./configure --prefix=/application/php5.5.38 --with-jpeg-dir=/usr/lib64 --with-freetype-dir=/usr/lib64/  --with-curl  --enable-fpm --enable-mbstring  --with-gd    --with-fpm-user=nginx --with-fpm-group=nginx --with-mysqli=mysqlnd --with-mysql-sock=/tmp/mysql.sock --with-openssl --enable-zip

3.2. Configure phpMyAdmin

Put the downloaded phpmyadmin source code package into the nginx site root directory, that is, the html directory, unzip and modify the nginx configuration file, and rename the default phpMyAdmin configuration file cp config.sample.inc.php config.inc. php

3.3. Build the database and perform database creation authorization (refer to the previous blog post)

3.4. Browser access login

4 , Configure phpMyAdmin to manage multiple database servers

Take 10.0.0.51 and 10.0.0.52 as examples

4.1 Install mysql on 10.0.0.52

Set password and log in to mysql

[root@db02 mysql]# mysql -uroot -p123456

Authorize the database to 10.0.0.51

mysql> grant all on *.* to root@'10.0.0.51' identified by '123456';

4.2 Configure db01 with phpMyAdmin installed

vim /application/nginx/html/phpMyAdmin-4.8.0.1-all-languages/config.inc.php  
复制粘贴并修改  
$i++;  
/* Authentication type */  
$cfg['Servers'][$i]['auth_type'] = 'cookie';  
/* Server parameters */  
$cfg['Servers'][$i]['host'] = '10.0.0.52';  
$cfg['Servers'][$i]['compress'] = false;  
$cfg['Servers'][$i]['AllowNoPassword'] = false;

Refresh the page to log in to the 10.0.0.52 database.

The above is the detailed content of Detailed explanation of how to build a multi-database server with phpMyAdmin. For more information, please follow other related articles on the PHP Chinese website!