yum 安装 mysql

 

1. 查看有没有安装包:
    yum list mysql*
    #移除已经安装的mysql
    yum remove mysql mysql-server mysql-libs compat-mysql51
    rm -rf /var/lib/mysql
    rm /etc/my.cnf
2. 查看是否还有mysql软件:
    rpm -qa|grep mysql
    #如果有的话,继续删除
3.  安装mysql客户端
 yum -y install mysql mysql-server mysql-devel

chkconfig --add mysqld
chkconfig mysqld on

查看 chkconfig --list

 

4.远程登录

mysql -u root -p

UPDATE user SET password=PASSWORD('123456') WHERE user='root';

grant all privileges on *.* to 'test'@'%' identified by '123456';

flush privileges;

或者

use mysql; 

UPDATE user SET Password=PASSWORD('123456') where USER='root';

flush privileges;  

 

 

use mysql；

select Host,User from user\G;

远程登录测试