云服务器MySQL卸载与安装

MySQL卸载

1. 获取安装的相关组件

rpm -qa |grep -i mysql

2.执行组件删除操作

rpm -e –nodeps mysql-community-libs-5.6.51-2.el7.x86_64
rpm -e –nodeps mysql-community-common-5.6.51-2.el7.x86_64
rpm -e –nodeps mysql-community-client-5.6.51-2.el7.x86_64
rpm -e –nodeps mysql-community-devel-5.6.51-2.el7.x86_64
rpm -e –nodeps mysql-community-release-el7-5.noarch
rpm -e –nodeps mysql-community-server-5.6.51-2.el7.x86_64

3.查找MySQL相关信息并删除

find / -name mysql

使用rm -rf 命令删除以上结果和/etc/my.cnf

安装MySQL（8以下版本）

1. root目录下安装mysql和mysql-devel

yum install mysql

yum install mysql-devel

2. 安装mysql-server

wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

rpm -ivh mysql-community-release-el7-5.noarch.rpm

yum install mysql-community-server

如果已经安装了wget，但是使用时仍报错-bash: wget: command not found,需要卸载重新安装即可解决。
卸载命令：yum remove wget
安装命令：yum -y install wget

3. 安装成功后重新启动MySQL服务

service mysqld restart

4. 设置密码

# 首次登录不需要输入密码
mysql -u root

# 为root用户设置密码
set password for 'root'@'localhost'=password('your password');

5. 配置远程连接信息

grant all privileges on *.* to root@'%' identified by 'root账户密码';

参考：
[1]: https://blog.csdn.net/weixin_42678675/article/details/124090783
[2]: https://blog.csdn.net/m0_48134027/article/details/121617150