One, offline installation
1, download phpMyAdmin
Download URL: http://www.phpmyadmin.net/home_page/downloads.php
phpMyAdmin 3.x version requires more than php5.2, mysql5.0 above, the seat. If you choose the wrong, the problem will be difficult to solve.
2, install phpMyAdmin
Unzip the tar Xvfz phpmyadmin-3.5.2.2-all-languages.tar.gz,
and copy the folder to the Web site home directory/var/www/html/
3, Configuration phpMyAdmin
I. config.sample.inc.php renamed to Config.inc.php;
II. Open the config.inc.php file and make the following modifications;
$cfg [' Servers '] [$i] [' controluser '] = ‘pma ';
$cfg [' Servers '] [$i] [' controlpass '] = ' pmapass ';
$cfg [' Servers '] [$i] [' pmadb '] = ' phpmyadmin ';
$cfg [' Servers '] [$i] [' bookmarktable '] = ' pma_bookmark ';
$cfg [' Servers '] [$i] [' relation '] = ' pma_relation ';
$cfg [' Servers '] [$i] [' table_info '] = ' pma_table_info ';
$cfg [' Servers '] [$i] [' table_coords '] = ' pma_table_coords ';
$cfg [' Servers '] [$i] [' pdf_pages '] = ' pma_pdf_pages ';
$cfg [' Servers '] [$i] [' column_info '] = ' pma_column_info ';
$cfg [' Servers '] [$i] [' history '] = ' pma_history ';
$cfg [' Servers '] [$i] [' designer_coords '] = ' pma_designer_coords ';
Remove the front//of each line;
Iii. $cfg [' blowfish_secret '] = "; | Modify to | $cfg [' blowfish_secret '] = ' http ';
Iv. $cfg [' Servers '] [$i] [' controluser '] = ' PMA '; | change ' PMA ' to your account | $cfg [' Servers '] [$i] [' controlpass '] = ' pmapass '; | Set the ' Pmapass to your MySQL login password |
V. $cfg [' blowfish_secret '] = "; | Add phrase password for example: $cfg [' blowfish_secret '] = ' onohot ';
You can manage the database according to the access phpMyAdmin http://ip/phpmyadmin/:
Second, install through Yum
Install phpMyAdmin and configuration process via Yum
1. Install MySQL + PHP environment.
2. Installing phpMyAdmin
Yum-y Install PhpMyAdmin
After the installation is complete, configure the following:
Configuration is slightly different because it is installed with Yum
phpMyAdmin is installed by default, Usr/share/phpmyadmin copy phpMyAdmin to the Web directory:
[Email protected] ~]# chown-r root:apache/var/www/phpmyadmin/
[[email protected] ~]# vi/etc/httpd/conf.d/phpmyadmin.conf establish phpmyadmin configuration file for Apache calls
Alias/phpmyadmin/var/www/phpmyadmin
Order Deny,allow
Deny from all
Allow from 127.0.0.1
Allow from 192.168.0
Only host access to native and 192.168.0.0 network segments is allowed, if an extranet user is allowed, the configuration is:
Alias/phpmyadmin/var/www/phpmyadmin
Order Deny,allow
Allow from all
[[email protected] ~]#/etc/rc.d/init.d/httpd Restart Restart HTTP service for the above settings to take effect
stopping httpd: [OK]
Starting httpd: [OK]
CentOS Installation phpMyAdmin