1.彻底删除已安装mysql
1) yum remove mysql mysql-server mysql-libs mysql-server;
删除云服务
2) find / -name mysql
查找服务器上有什么跟mysql相关的,删除它
rm -rf /var/lib/mysql
3) rpm -qa|grep mysql
(查询出来的东东yum remove掉)
4) rm /etc/my.cnf
参考链接:https://www.cnblogs.com/cyl048/p/6879085.html
2.重新安装mysql
1) wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
# 下载mysql源安装包
2)yum localinstall mysql57-community-release-el7-8.noarch.rpm
# 安装mysql源
3)yum repolist enabled | grep "mysql.*-community.*"
#检查mysql源是否安装成功
4)yum install mysql-community-server
安装MySQL
5)systemctl start mysqld
配置文件:/etc/my.cnf
日志文件:/var/log/mysqld.log
服务启动脚本:/usr/lib/systemd/system/mysqld.service
socket文件:/var/run/mysqld/mysqld.pid
参考链接:https://www.cnblogs.com/duguxiaobiao/p/9465702.html
3.重置mysql链接密码
1)#vim /etc/my.cnf
在[mysqld]后面任意一行添加“skip-grant-tables”
2) service mysqld start(可能要先关闭,再重启)
重启mysql。此时说明无需要密码
3)sql来修改root
mysql> use mysql;
mysql> update user set authentication_string=password("你的新密码") where user="root";
mysql> flush privileges;
mysql> quit
4)删除1)
4. 查看是否支持链接
如IP为172.0.0.1,密码为a123456
mysql -h 172.0.0.1 -P 3306 -u root -pa123456
(特别注意:-p + 密码,而且不能有空格)
https://blog.csdn.net/dabao87/article/details/80571877
如有需要:update user set Host='%' where User='root';