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;
远程登录测试