准备

centos7系统

检查是否已经安装

rpm -qa | grep mysql

已安装截图如下：

然后进行卸载：

#卸载前先关闭mysql
service mysqld stop
#开始卸载
rpm -e --nodeps mysql-community-release-el7-5.noarch
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-server-5.6.51-2.el7.x86_64

没安装截图如下：

下载MySQL

cd /usr/local/src/
wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
# 如果找不到wget命令，需要进行安装
yum install wget

安装MySQL

rpm -Uvh mysql-community-release-el7-5.noarch.rpm
yum -y install mysql-community-server

出现Complete说明安装成功。

启动MySQL

# 启动
service mysqld start
# 停止
service mysqld stop
# 重启
service mysqld restart

# 状态
service mysqld status

设置用户名密码

mysql -uroot
use mysql;
update user set password=password('root') where user='root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
flush privileges;

客户端连接

关闭防火墙

# 查看防火墙状态
systemctl status firewalld
# 关闭防火墙
systemctl stop firewalld
# 启动防火墙
systemctl start firewalld
# 禁用防火墙
systemctl disable firewalld
# 开启防火墙
systemctl enable firewalld

【温馨提示】

点赞+收藏文章，关注我并私信回复【面试题解析】，即可100%免费领取楼主的所有面试题资料！