CentOS Installation phpMyAdmin

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.