Centos7.3 安装mysql5.7（YUM方式）

1 .下载源安装包

[root@loacalhost~]#wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

2. 安装源

[root@loacalhost~]#yum install mysql57-community-release-el7-8.noarch.rpm 

3. 安装 MySQL 

[root@loacalhost~]#yum install mysql-community-server

4.修改配置文件

[root@loacalhost~]# vi /etc/my.cnf

[mysqld]增加下面两个配置

max_connections = 1000
character-set-server=utf8mb4

5.启动MySQL服务

[root@loacalhost~]#systemctl start mysqld

如果启动不了 出现Public key for xxx rpm is not installed

原因是Mysql的GPG升级了，需要重新获取，执行下面的语句

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

重新执行yum install mysql-community-server

6.设置开机启动

[root@localhost ~]#systemctl enable mysqld

[root@localhost ~]#systemctl daemon-reload

7.查看Mysql

(1)查看root密码

[root@localhost ~]# grep 'temporary password' /var/log/mysqld.log

如果无效 修改 /etc/my.cnf 添加 skip-grant-tables 直接进入mysql 修改密码

UPDATE user SET authentication_string = password ('root') WHERE User = 'root' ;

(2)查看mysql状态

[root@localhost ~]#systemctl status mysqld

8.登录mysql,并修改root密码

[root@localhost ~]# ALTER USER 'root'@'localhost' IDENTIFIED BY 'hXh#HkwM30h';

9.添加远程用户

GRANT ALL PRIVILEGES ON *.* TO 'xxx'@'%' IDENTIFIED BY 'xxx' WITH GRANT OPTION;

为MySQL配置环境变量，以后使用起来方便

[root@localhost ~]#export PATH=/usr/local/mysql/bin:$PATH

[root@localhost ~]#source /etc/profile