centos6.5 MySQL Installation

1. Check if the system comes with MySQL installed

 yum list installed | grep mysql

2. Delete the system's own MySQL and its dependencies

yum -y remove mysql-libs.x86_64

3. Add the RPM source to CentOS and select a newer source

wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpmyum localinstall mysql-community-release-el6-5.noarch.rpmyum repolist all | grep mysqlyum-config-manager --disable mysql55-communityyum-config-manager --disable mysql56-communityyum-config-manager --enable mysql57-community-dmryum repolist enabled | grep mysql

4. Install the MySQL server

yum install mysql-community-server

5. Start MySQL

service mysqld start

6. Check to see if MySQL is self-booting, and set the self-boot

chkconfig --list | grep mysqldchkconfig mysqld on

7.mysql Security Settings

mysql_secure_installation

8. Temporary password

9. Set up an extranet to access

GRANT ALL PRIVILEGES ON *.* TO [email protected] IDENTIFIED BY ‘1234567‘ WITH GRANT OPTION;GRANT ALL PRIVILEGES ON *.* TO [email protected]"%" IDENTIFIED BY ‘1234567‘ WITH GRANT OPTION;flush privileges;

centos6.5 MySQL Installation