卸载mysql&&Mysql8安装

最新推荐文章于 2024-08-07 10:50:52 发布

weixin_37928121

最新推荐文章于 2024-08-07 10:50:52 发布

阅读量158

点赞数

分类专栏： mysql 文章标签： mysql卸载 mysql8

本文链接：https://blog.csdn.net/weixin_37928121/article/details/85329876

版权

mysql 专栏收录该内容

0 篇文章 0 订阅

订阅专栏

卸载mysql&&Mysql8安装

1、使用以下命令查看当前安装mysql情况

rpm -qa|grep -i mysql

如果看到如下：
在这里插入图片描述

2、删除

rpm -e –nodeps 包名

rpm -ev MySQL-client-5.5.25a-1.rhel5  
rpm -ev MySQL-server-5.5.25a-1.rhel5

如果提示依赖包错误，则使用以下命令尝试

rpm -ev MySQL-client-5.5.25a-1.rhel5 --nodeps

如果提示错误：error: %preun(xxxxxx) scriptlet failed, exit status 1

rpm -e --noscripts MySQL-client-5.5.25a-1.rhel5

3、查找之前老版本mysql的目录、并且删除老版本mysql的文件和库

find / -name mysql
find / | grep mysql

结果：
/var/lib/mysql
/var/lib/mysql/mysql
/usr/lib64/mysql

删除对应的mysql目录

rm -rf /var/lib/mysql
rm -rf /var/lib/mysql
rm -rf /usr/lib64/mysql

注意：卸载后/etc/my.cnf不会删除，需要进行手工删除

rm -rf /etc/my.cnf

4、再次查找机器是否安装mysql

rpm -qa|grep -i mysql

Mysql 8.0安装

yum localinstall https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
yum install mysql-community-server
service mysqld start
service mysqld status
查看临时密码
grep 'temporary password' /var/log/mysqld.log

mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'JL23$%)ab';
退出重登
exit

mysql -u root -p
JL23$%)ab
show databases;
create database hfront;
show databases;
create user 'zhangsan'@'%' identified by 'JL23$%)ab';
grant all privileges on hfront.* to 'zhangsan'@'%';
SHOW GRANTS FOR zhangsan;
flush privileges;

select host,user,plugin,authentication_string from mysql.user;
ALTER USER 'zhangsan'@'%' IDENTIFIED WITH mysql_native_password BY 'JL23$%)ab';

记得关闭防火墙