centos 卸载,安装mysql

#因为不小心把 mysql库下的user表给 delete 

rpm -qa|grep -i mysql #查看 mysql的安装情况

mysql-libs-5.1.69-1.el6_4.x86_64
perl-DBD-MySQL-4.013-3.el6.x86_64
mysql-5.1.69-1.el6_4.x86_64
mysql-server-5.1.69-1.el6_4.x86_64
mysql-devel-5.1.69-1.el6_4.x86_64
 sudo yum -y remove mysql-libs-5.1.69-1.el6_4.x86_64 #卸载掉

rpm -qa|grep -i mysql #再次查看 mysql的安装情况

#如果有相关的mysql 包、

rm -rf  xxx #删除所有的mysql包

#卸载干净后，开始重新安装

 yum install mysql
 yum install mysql-server
 yum install mysql-devel

mysql -u root #进入数据库

mysql> use mysql;

mysql>select Host,user,password from user;

mysql>update user set password=PASSWORD('123456') ;#修改密码

mysql>update user set Host='%' ;#设置远程访问

mysql>delete from user where user='xxx' //移除多余的信息,只保留一条

mysql>GRANT ALL PRIVILEGES ON *.* to 'root'@'%'  identified  by mysql;# 权限

mysql>flush privileges;

mysql>quit;

service mysqld start #启动mysql