虚拟机部署mysql单机5.7.17版本

安装包准备

# 5.7.17版本安装包下载地址：
https://pan.quark.cn/s/7b94f1f5dfd1

安装步骤

• 解压安装包

tar -xvf mysql-5.7.17.tar

• 创建安装目录

mkdir -p mysql_install_package
mv mysql-community-* ./mysql_install_package/

• 卸载mariadb

yum list installed | grep mariadb
systemctl stop mariadb
rm -rf /etc/my.cnf
rm -rf /var/lib/mysql
rpm -e --nodeps mariadb-server mariadb

• 安装mysql

yum -y install mysql-community-*.rpm
rpm -ivh --force --nodeps *.rpm
# 查看安装结果
rpm -qa | grep mysql
systemctl start mysqld
# 单独查看某一个进程有没有
ps -C mysqld 

• 开机自启

systemctl enable mysqld

• 修改密码

# 初始密码
grep password /var/log/mysqld.log

# 登陆
mysql -hlocalhost -uroot -p
# 默认密码什么都不能做，因此需要修改密码
alter user root@"localhost" identified by "Huawei@123";

# 修改密码策略
show variables like "%validate_password_policy%";

• 允许远程登录

# 添加root用户，可以从任意地方登录
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Huawei@123' WITH GRANT OPTION;
FLUSH PRIVILEGES;

相关胶片

alter user root@"localhost" identified by "Huawei@123";

# 此种方式重启失效
set global validate_password_policy=0;

# 永久生效
[mysqld]
validate_password_length=8
validate_password_policy=2