Centos7安装MySQL5.7

1.安装MySQL源

sudo rpm -Uvh http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm

安装MySQL公钥

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

2.安装MySQL

安装MySQL

sudo yum install -y mysql-community-server

3.启动MySQL

service mysqld start

4.查看MySQL启动状态

service mysqld status

5.获取MySQL默认密码

grep -i "temporary password" /var/log/mysqld.log

找到这行：[Note] A temporary password is generated for root@localhost: dChpeZztt0,P
dChpeZztt0,P为初始密码

6.登录MySQL

mysql -uroot -p

7.修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Admin@123456';

将Admin@123456换成你想要的密码，密码要有一定的复杂度。

8.想要使用Navicat远程访问MySQL则需要以下操作：

登录MySQL后执行以下命令：

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Admin@123456' WITH GRANT OPTION;

将Admin@123456换成你设置的密码

使修改生效

FLUSH PRIVILEGES;

开启3306端口

sudo firewall-cmd --zone=public --add-port=3306/tcp --permanent

重新加载配置文件

sudo firewall-cmd --reload