环境准备
- 查看当前安装mysql情况
rpm -qa|grep -i mysql
- 删除之前安装的mysql
rpm -e –nodeps ${包名}
如:
rpm -ev MySQL-client-5.5.25a-1.rhel5
- 查找之前老版本mysql的目录
find / -name mysql
如:
[root@localhost ~]# find / -name mysql
/var/lib/mysql
/var/lib/mysql/mysql
/usr/bin/mysql
- 删除老版本mysql的文件和库
rm -rf /var/lib/mysql /var/lib/mysql/mysql /usr/bin/mysql
yum源安装mysql
yum clean all
yum repolist
sudo yum install -y mysql-server
初始化mysql
- 启动mysql服务
sudo service mysql start
- 初始化mysql
mysql -u root -p
第一次进入mysql不需要密码,两次回车进入
use mysql;
delete from user where user='';
update user set host='%' where host='localhost';
- 刷新权限
flush privileges;
- 退出mysql并重启服务
exit;
service mysqld restart