CentOS7上搭建单机Mysql服务

1、下载mysql

https://dev.mysql.com/downloads/mysql/

2、安装步骤

# 卸载centos中预安装的 mysql
rpm -qa|grep  -i mariadb
rpm -e mariadb-libs-5.5.68-1.el7.x86_64 --nodeps
rpm -qa | grep -i mysql
rpm -e mysql-libs-5.1.71-1.el6.x86_64 --nodeps
# 上传mysql的安装包
scp e:mysql-8.0.23-1.el7.x86_64.rpm-bundle.tar root@192.168.1.3:/usr/local/
# 解压到/usr/local/mysql目录下
mkdir /usr/local/mysql
tar -zxvf mysql-8.0.23-1.el7.x86_64.rpm-bundle.tar -C /usr/local/mysql/
# 安装
rpm -ivh mysql-community-common-8.0.23-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.23-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.23-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.23-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.23-1.el7.x86_64.rpm
# mysql服务命令
systemctl start mysqld.service
systemctl status mysqld.service
systemctl stop mysqld.service
systemctl enable mysqld.service
systemctl restart mysqld.service
# 查看root用户初始化密码
cat /var/log/mysqld.log | grep password
# 启动客户端连接
mysql -u root -p password
# 修改root用户密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '复杂密码';
# 修改mysql密码安全等级为低，长度最小为4位
set global validate_password.policy=0;
set global validate_password.length=4;