1、下载YUM Repo:
wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
2、安装YUM Repo:
rpm -ivh mysql57-community-release-el7-9.noarch.rpm
3、安装MYSQL:
yum install mysql-server --nogpgcheck
4、启动MYSQL:
systemctl start mysqld
5、获取临时密码:
grep 'temporary password' /var/log/mysqld.log
6、登陆MYSQL:
mysql -u账号 -p密码
7、修改密码:
ALTER USER 'root'@'localhost' IDENTIFIED BY '需要修改的密码';
8、设置开机自启:
systemctl enable mysqld
8、设置开机自启:
systemctl enable mysqld
9、设置远程连接:
GRANT ALL PRIVILEGES on *.* to '账户(可以新建)'@'%' IDENTIFIED BY "密码(可以新建)" WITH GRANT OPTION;
10、设置远程连接端口:
在/etc/my.cnf里面添加一个参数:port=端口号
11、重启数据库:
systemctl restart mysqld