installing MySQL under CentOS

You need to install: Devel,client,server

1, first of all to see if there is already installed MySQL, in order to avoid conflict
# Rpm-qa | grep MySQL
2. Uninstall conflicting versions
# RPM-E Mysql-version//To unload the passenger service and server side

3. Install MySQL customer service and server side

RPM installation, depending on the version of MySQL to be installed, specify the name differently.

RPM-IVH mysql-server-5.5.16-1.rhel4.i386.rpm mysql-client-5.5.16-1.rhel4.i386.rpm mysql-devel-5.5.16-1.rhel4.i386.rpm

If you do not have a local installation package, consider using the yum command to download

# yum-y Install Mysql-server

# yum-y Install Php-mysql

4, after installation, MySQL automatically start, default no user name and password, set a new password
#/usr/bin/mysqladmin-u root password ' 123456′
5. Log in to MySQL
>mysql-uroot-p
Enter Password: ' 123456′
6. Assign permissions to the host you are connected to
>mysql GRANT select,insert,update,delete On * * to [e-mail protected] identified by ' 123456′; XXX.XXX.X.XX is your IP.
7. Change the MySQL default character set
# CP MY-MEDIUM.CNF/ETC/MY.CNF
Add Default-character-set=utf8 under [client]
Add Default-character-set=utf8 under [mysqld]
8. Set MySQL boot from start
# vi/etc/rc.local
Add the following line
/usr/share/mysql/mysql.server start
9. Restart MySQL
#/etc/init.d/mysql Restart