Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to build a multi-database server with phpMyAdmin". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to build a multi-database server with phpMyAdmin.

Build and manage multiple database servers with phpMyAdmin

Environment description:

System version CentOS 6.9 x86x64 Software version nginx-1.12.2 php-5.5.38 phpMyAdmin 4.8.0.1

1. PhpMyAdmin introduction

PhpMyAdmin is a database management tool based on PHP and constructed on the host of the website in the way of Web-Base, which allows managers to use Web interface to manage MySQL database. Through this Web interface, it can become a better way to input complicated SQL syntax in a simple way, especially to deal with the import and export of a large amount of data. One of the bigger advantages is that phpMyAdmin runs on the web server like other PHP programs, but you can use the HTML pages generated by these programs anywhere, that is, to manage the MySQL database remotely, and to easily create, modify, and delete databases and tables. You can also use phpMyAdmin to establish a commonly used php syntax to facilitate the correctness of sql syntax needed when writing web pages.

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

2. Environmental requirements for installing phpMyAdmin

3. Steps

3.1.Compiler and install nginx and php can refer to the previous blog post, which will not be discussed here, but based on the requirements of the phpMyAdmin environment, 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.Configuring phpMyAdmin

Place the downloaded phpmyadmin source package in the root directory of the nginx site, namely the html directory, extract and modify the nginx configuration file, and rename the default phpMyAdmin configuration file cp config.sample.inc.php config.inc.php

3.3. Set up the database and authorize the creation of the database (see 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 your 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 copy and paste and modify $ipassport; / * 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.

At this point, I believe you have a deeper understanding of "how to build a multi-database server in phpMyAdmin". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue 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.