Install web Page Management for mysql services

Install web Page Management for mysql services
Generally, we use commands to manage the mysql database on the mysql server. have you ever wondered whether to manage the mysql database on the web page, on the web page, we can manage mysql with just a few clicks, which is not only convenient but also more intuitive, Is it awesome? Next we will install phpMyadmin.
(Note: phpMyadmi can go to its official http://www.phpmyadmin.net for more understanding)
Installation steps:
1, download phpMyadmin compressed package :( Note: it is best not to use a higher version of The phpMyAdmin-2.11.10-all-languages.tar.gz, the higher version of the php version is also very demanding, so we will use this version of the convenient demonstration)
2. Install the httpd, php, php-mysql, mysql, mysql-sever, and php-mbstring software packages:
Yum install httpd php-mysql-sever php-mbstring-y
3rd, copy the downloaded phpmyadmin-2.11.10-all-languages.tar.gz package to the default httpd webpage directory/var/www/http, and decompress the package:
Cp phpMyAdmin-2.11.10-all-languages.tar.gz/var/www/http/
Cd/var/www/http/
Tar xvf phpMyAdmin-2.11.10-all-languages.tar.gz
Rm-rf xvf phpMyAdmin-2.11.10-all-languages.tar.gz
Music phpMyAdmin-2.11.10-all-languages /*./
Rm-rf phpMyAdmin-2.11.10-all-languages
4. Create and modify the phpMyAdmin configuration file:
To create a phpMyAdmin configuration file, you only need to name the existing config. sample. inc. php file.
Cp config. sample. inc. php config. inc. php so that we can get the phpMyAdmin configuration file.
Configure the phpMyAdmin configuration file
Vim config. inc. php
Find the following lines in the configuration file:
$ Cfg ['blowfish _ secret'] =''
Add any letter between single quotes (Note: it is best to add only letters and numbers, do not add symbols, to avoid ambiguity), such:
$ Cfg ['blowfish _ secret'] = 'kshdkjsf'
Save and exit.
5. Start the mysql service and set the mysql logon password for the Local root User:
Service mysqld start
Chkconfig mysqld on add mysql service to enable Auto Start List
Run the following command:
[Root @ server54 ~] # Mysql
Mysql> set password for root @ localhost = password ('redhat'); set the password to redhat for the local root user.
Query OK, 0 rows affected (0.00 sec) indicates that our operation is correct.
Mysql> flush privileges; load our settings
Query OK, 0 rows affected (0.00 sec)
Mysql> \ q exit mysql
Bye indicates that we have successfully exited
6. Start the httpd service:
Service httpd start
Chconfig httpd on adds the httpd service to the Automatic startup list

Now, we can use the web to log on to our mysql server. The exciting time is coming. You have to HOLD it!
Enter the IP address of your host in the browser:
Http: // 192.168.0.82 this is the IP address of my host
If no error occurs, we will see the following interface:

Note: you do not have to worry about the prompt (the mcrypt extension cannot be loaded, <br/> check the PHP configuration ).
Enter our local user root and the password redhat, and click "run"
We will go to the settings page for msyql:

At this point, we can easily create and configure databases on the mysql server. The subsequent operations will not be explained.
Author "redhat"