phpMyAdmin installation, Web Access MySQL

1. Download the phpMyAdmin package: ( Note: phpmyadmin-2.11.10-all-languages.tar.gz )

2, install httpd, PHP, Php-mysql, MySQL, Mysql-sever, php-mbstring package:

#yum install-y httpd php php-mysql mysql mysql-server php-mbstring mysql-devel

3. Copy the phpmyadmin-2.11.10-all-languages.tar.gz compressed package that we downloaded to the HTTPD default page directory/var/www/http, and unzip:

CP Phpmyadmin-2.11.10-all-languages.tar.gz/var/www/http/cd/var/www/http/tar XVF Phpmyadmin-2.11.10-all-langu  ages.tar.gz rm-rf xvf phpmyadmin-2.11.10-all-languages.tar.gz mv phpmyadmin-2.11.10-all-languages/*./RM -RF phpmyadmin-2.11.10-all-languages

4. Create and modify the phpMyAdmin configuration file:

for a configuration file that creates phpMyAdmin, we just need to have the existing config.sample.inc.php file that name :    

#cp config.sample.inc.php config.inc.php #这样我们就得到了phpMyAdmin的配置文件      

Configuring the phpMyAdmin configuration file

#vim config.inc.php #在配置文件中找到如下行: $cfg [' blowfish_secret '] = ' #在连个单引号之间添加任意的字母 (note: It is best to add only letters and numbers, do not add symbols, so as not to cause differences $cfg [' blowfish_secret '] = ' Luzhi ' #保存退出, you can

5. Start the MySQL service and set the MySQL login password for the local root user:

Service mysqld start chkconfig--level 2345 mysqld on Add MySQL service to open auto start list

Execute the following command:

       #mysql  -uroot -p        #给本地的root用户设置密码, password is redhat          Mysql> set password for [email protected]=password (' RedHat ');        Query OK, 0 rows affected  (0.00 sec)           mysql> flush privileges;          Query OK, 0 rows affected  (0.00 sec)        mysql> \q         bye 

6. Start httpd Service:

Service httpd start Chconfig--level 2345 httpd on Add httpd service to boot auto start list

OK, now we can use the Web to login to our MySQL server.

Enter the IP address of your host in the browser: http://192.168.137.10

This article is from the "Tiandaochouqin" blog, make sure to keep this source http://8855546.blog.51cto.com/8845546/1642321

phpMyAdmin installation, Web Access MySQL