- yum -y install wget----------------------------(未安装wget请先安装)
- wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
- ps:如果服务器无法与mysql建立链接请在windows浏览器中输入网址下载,通过scp上传到指定目录
- scp 文件名 user@ip:/目标路径
- scp mysql57-community-release-el7-11.noarch.rpm root@139.196.208.224:/home/mysql5.7
- 安装yum源
- yum -y localinstall mysql57-community-release-el7-11.noarch.rpm
- 安装mysql服务
- yum -y install mysql-community-server
- 启动mysql服务
- systemctl start mysqld
- 设置开机自启
- systemctl enable mysqld---------------------(设置自启)
- systemctl daemon-reload--------------------(重启systemctl)
- 查看mysql的初始密码
- vim /var/log/mysqld.log
- 通过初始密码登陆mysql
- mysql -u root -p
- 修改密码, mysql5.7默认密码策略要求密码必须是大小写字母数字特殊字母的组合,至少8位
- ALTER USER 'root'@'localhost' IDENTIFIED BY 'Mysql2019@';
- 设置远程登陆
- GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Mysql2019@' WITH GRANT OPTION;
- 这时候如果你是第一次安装,没有开放防火墙端口,则通过IP是无法进行连接的,阿里云配置安全组即可!!
- firewall-cmd --permanent --add-port=3306/tcp --------------------(开放3306端口)
- firewall-cmd --reload ----------------------------------------------------- (重启防火墙)
- 测试连接