一、檢查系統(tǒng)是否安裝其他版本的MYSQL數(shù)據(jù)

yum list installed | grep mysql

yum -y remove mysql-libs.x86_64

二、安裝及配置

wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm

rpm -ivh mysql-community-release-el6-5.noarch.rpm

查看可以安裝的版本

yum repolist all | grep mysql

1、安裝MYSQL數(shù)據(jù)庫(kù)

yum install mysql-community-server

2、設(shè)置為開(kāi)機(jī)啟動(dòng)

chkconfig —list | grep mysqld
chkconfig mysqld on

service mysqld start

3、設(shè)置密碼

/usr/bin/mysqladmin -u root password 123456

4、修改root密碼

mysql -u root -p 123456

select user,host,password from mysql.user;
set password for root@localhost=password (xxx);
set password for root@127.0.0.1=password (xxx);

刪除匿名用戶

delete from mysql.user where user=””;