(1)下载
yum -y install mysql57-community-release-el7-10.noarch.rpm
(2)安装
yum -y install mysql-community-server
(3) 启动MySQL
systemctl start mysqld.service(查看状态:systemctl status mysqld.service)
(4)查看初始登录密码
grep "password" /var/log/mysqld.log #结果:root@localhost: muO-y1G;JMl#
(5)进入MySQL
mysql -uroot -p # 回车后会提示输入密码
(6)修改密码长度校验
set global validate_password_policy=0;
(7)修改登录密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'stand@123';
(8)授权远程登录
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;
(9)刷新权限
FLUSH PRIVILEGES;
(10)开启启动
systemctl enable mysqld;systemctl daemon-reload;
(11)重启MySQL生效
service mysql restart;
(12)开放端口(服务器后台和Linux)
firewall-cmd --zone=public --add-port=3306/tcp --permanent
(13)卸载Yum Repository
yum -y remove mysql57-community-release-el7-10.noarch
参照:https://blog.csdn.net/qq_37598011/article/details/93489404
启动MySQL:service mysql start
停止MySQL:service mysql stop
重启:service mysql restart
刷新权限:flush privileges;