Install MySQL and phpMyAdmin

To install phpMyAdmin, record the following points:

Install phpMyAdmin
Decompress the package to/var/www.
Configure Apache
Listen 8030.
<VirtualHost *: 8030>
DocumentRoot/var/www/phpMyAdmin
</VirtualHost>

Cp config. sample. inc. php config. inc. php
Vi config. inc. php
Modify the following section
/*
* First server
*/
$ I ++;
/* Authentication type */
$ Cfg ['servers'] [$ I] ['auth _ type'] = 'cooker ';
/* Server parameters */
$ Cfg ['servers'] [$ I] ['host'] = 'localhost ';
$ Cfg ['servers'] [$ I] ['connect _ type'] = 'tcp ';
$ Cfg ['servers'] [$ I] ['compus'] = false;
/* Select mysqli if your server has it */
$ Cfg ['servers'] [$ I] ['extension'] = 'mysql ';
$ Cfg ['servers'] [$ I] ['allownopassword'] = false;

Connect multiple hosts, copy the previous section, and change $ cfg ['servers'] [$ I] ['host,
There will be more than host selection boxes during login.

Upgrade RedHat php to 5.2
Find a simple method
Wget-q-O-http://www.atomicorp.com/installers/atomic.sh | sh
Yum update php

Restart apache
Service httpd restart

Install MySQL
./Configure & make install
Install basic library
Scripts/mysql_install_db
[Follow the prompts to set the root password]

Select Configuration File
Cp support-files/my-huge.cnf/etc/my. cnf
Vi/etc/my. cnf Add the following content
[Client]
Default-character-set = utf8
Default-character-set = utf8
[Mysqld]
Datadir =/opt/mysql_data
Default-character-set = utf8

Add mysql users
Adduser mysql

Grant permissions to mysql users
Chown-R mysql. mysql/opt/mysql_data

Set auto-start
Cp support-files/mysql. server/etc/init. d/mysql
Grant execution permission
Chomd + x/etc/init. d/mysql

Start mysql
Service mysql restart