1、查看系统中是否已安装 MySQL 服务:
rpm -qa | grep mysql
2、如果已安装则删除 MySQL 及其依赖的包:
yum -y remove mysql-libs.x86_64
3、下载 mysql57-community-release-el7-8.noarch.rpm 的 YUM 源:
wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
4、安装 mysql57-community-release-el7-8.noarch.rpm:
rpm -ivh mysql57-community-release-el7-8.noarch.rpm
安装完后,得到如下两个包:
mysql-community.repo
mysql-community-source.repo
5、安装 MySQL:
yum install mysql-server
6、初始化密码
vim /etc/my.cnf
添加 skip-grant-tables
重启 systemctl restart mysql
update mysql.user set authentication_string=password('123qwe') where user='root' and Host = 'localhost';
*特别提醒注意的一点是,新版的mysql数据库下的user表中已经没有Password字段了
而是将加密后的用户密码存储于authentication_string字段
mysql> flush privileges;
mysql> quit;
systemctl restart mysqldmysql -u root -p
需要重新设置密码 SET PASSWORD = PASSWORD('_Ghj1234');
7、允许用户root使用_Ghj1234从任何主机连接到mysql服务器。
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '_Ghj1234' WITH GRANT OPTION;
mysql> flush privileges;
mysql> quit;
8、设置防火墙,使其他主机可以访问mysqlfirewall-cmd --add-port=3306/tcp --permanent
vim /etc/sysconfig/iptables
查看端口占用 netstat -ntlp | grep mysql
systemctl restart firewalld.service
systemctl restart iptables.service
测试访问端口 telnet ip port