PhpMyAdmin configuration modification tutorial

Review our architecture description: after HTTPD, MySQL, and PHP servers are deployed, the basic architecture has been set up. Next, deploy phpMyAdmin (a database management tool on the web interface) to verify this architecture, and compare the impact of the PHP accelerator on the efficiency of PHP parsing. HTTPD configuration modification 1

Review our architecture

Note: After the HTTPD, MySQL, and PHP servers are deployed, the basic architecture has been set up. Next, you can deploy phpMyAdmin (a web interface database management tool) to verify this architecture, at the same time, compare the impact of the PHP accelerator on the efficiency of PHP parsing.

 

HTTPD configuration modification

123456789101112131415161718

# To distinguish it from the Drupal system installed later, port 8080 must be used, and port 8080 of the listener must be opened in the main configuration file.Listen 8080 # Edit the VM configuration file. the file directory is/www/phpMyAdmin.com. Note the configuration format of ProxyPassMatch:# "Fcgi address + DocumentRoot + document name"vi /etc/httpd/extra/httpd-vhosts.conf     DocumentRoot "/www/phpMyAdmin.com"    ServerName phpMyAdmin.com     ErrorLog "logs/phpMyAdmin.com-error_log"    CustomLog "logs/phpMyAdmin.com-access_log" common     ProxyRequests Off     ProxyPassMatch ^/(.*\.php)$ fcgi://192.168.1.111:9000/www/phpMyAdmin.com/$1      "/www/phpMyAdmin.com" >          Options Indexes FollowSymLinks          AllowOverride None          Require all granted      < /Directory > < /VirtualHost >

PHP-fpm configuration modification

12345

# Configure it to listen to Port 9000 of all IP addresses of the local machine to receive external requestsvi /usr/local/php/etc/php-fpm.conf listen = 9000 # Restart php-fpmservice php-fpm restart

PhpMyAdmin installation configuration

123456789101112

# Because The phpMyAdmin package contains both static pages (such as css) and dynamic programs (such as php), you must deploy one copy on both the HTTPD server and the PHP server, make sure that the configurations are consistent. in the future, NFS file sharing and other mechanisms will be used to achieve centralized storage of webpage files.# Decompress the file to use it. Note that the decompressed directory is changed to the DocumentRoot directory configured in the HTTPD virtual host.unzip -d /www phpMyAdmin-4.0.5-all-languages.zip cd /wwwmv phpMyAdmin-4.0.5-all-languages phpMyAdmin.com # Modify configurationcd phpMyAdmin.com cp config.sample.inc.php config.inc.php openssl rand -hex 8 # Use an 8-bit password for configuration.vi config.inc.php # You only need to modify the following two items:$cfg['blowfish_secret'] = 'deeb57c563a5b0fc' # Fill in the eight-bit password generated above as the encryption key for cookie communication$cfg['Servers'][$i]['host'] = '192.168.1.112'; # Fill in the address of the managed MySQL

Verification test

Browser access http: // 192.168.1.110: 8080/