本文共 1549 字,大约阅读时间需要 5 分钟。
rpm -qa | grep -i mysql
删除这些包
rpm -e mysql-community-libs-8.0.17-1.el7.x86_64 --nodeps rpm -e mysql-community-server-8.0.17-1.el7.x86_64 --nodeps rpm -e mysql-community-devel-8.0.17-1.el7.x86_64 --nodeps rpm -e mysql-community-embedded-compat-8.0.17-1.el7.x86_64 --nodeps rpm -e mysql-community-common-8.0.17-1.el7.x86_64 --nodeps rpm -e mysql-community-client-8.0.17-1.el7.x86_64 --nodeps rpm -e mysql-community-test-8.0.17-1.el7.x86_64 --nodeps rpm -e mysql-community-libs-compat-8.0.17-1.el7.x86_64 --nodeps
whereis mysql
rm -rf /var/lib/mysql rm -rf /var/lib/mysql/mysql rm -rf /data/mysql
find / -name mysql
rm -rf /usr/lib64/mysqlrm -rf /usr/share/mysqlrm -rf /usr/bin/mysqlrm -rf /etc/logrotate.d/mysqlrm -rf /var/lib/mysqlrm -rf /var/lib/mysql/mysql
几个查询方式,不在找不出任何mysql文件就可安装
一定一定要进入到mysql rpm包所在的目录;
安装一下以mysql-community开头,以rpm结尾的几个包;(8个)yum -y install mysql-community*.rpm
要把my.cnf配置文件复制家里面(/root,/home用户名)
cp /etc/my.cnf ~
重启服务
service mysqld restart 服务运行的状态 service mysqld status找到mysql的初始密码
vim /var/log/mysqld.log登陆
修改密码
让密码永不过期 让root用户允许远程访问: – 重置密码,所有的操作得先重置密码,要求ALTER USER 'root'@'localhost' IDENTIFIED BY 'mynewpassword';
– 修改为%,才能远程访问
RENAME USER `root`@`localhost` TO `root`@`%`;
– 修改密码,'Jh123456!
– 并且密码的类型是mysql本地(密码的加密方式);WITH mysql_native_password – 密码的过期策略;PASSWORD EXPIRE NEVER;ALTER USER `root`@`%` IDENTIFIED WITH mysql_native_password BY 'aa123456!' PASSWORD EXPIRE NEVER;
密码不要设置太简单,否则会执行报错
转载地址:http://pgrzi.baihongyu.com/