Linux安装Mysql5.7

在线安装过mysql的老铁们都知道，从国外镜像安装mysql特别特别慢，有时候还不到1kb/s，以国内镜像站yum安装mysql。

1、下载安装mysql的yum配置文件

[root@mysql Tools]# wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
[root@mysql Tools]# rpm -ivh mysql57-community-release-el7-9.noarch.rpm

2、修改Mysqlyum源配置文件，修改为国内镜像

• 配置文件内容获取地址 https://mirrors.cnnic.cn/help/mysql/

[root@mysql Tools]# cd /etc/yum.repos.d/
[root@mysql yum.repos.d]# mv mysql-community.repo mysql-community.repo,bak
[root@mysql yum.repos.d]# vim mysql-community.repo
[root@mysql yum.repos.d]# cat mysql-community.repo

• 只保留mysql5.7的配置文件
  

[mysql-connectors-community]
name=MySQL Connectors Community
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-connectors-community-el7-$basearch/
enabled=1
gpgcheck=1
gpgkey=https://repo.mysql.com/RPM-GPG-KEY-mysql

[mysql-tools-community]
name=MySQL Tools Community
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-tools-community-el7-$basearch/
enabled=1
gpgcheck=1
gpgkey=https://repo.mysql.com/RPM-GPG-KEY-mysql

[mysql-5.6-community]
name=MySQL 5.6 Community Server
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-5.6-community-el7-$basearch/
enabled=0
gpgcheck=1
gpgkey=https://repo.mysql.com/RPM-GPG-KEY-mysql

[mysql-5.7-community]
name=MySQL 5.7 Community Server
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-5.7-community-el7-$basearch/
enabled=1
gpgcheck=1
gpgkey=https://repo.mysql.com/RPM-GPG-KEY-mysql

[mysql-8.0-community]
name=MySQL 8.0 Community Server
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-8.0-community-el7-$basearch/
enabled=1
gpgcheck=1
gpgkey=https://repo.mysql.com/RPM-GPG-KEY-mysql

3、配置mysql安装包的key

[root@zabbix yum.repos.d]# rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

4、yum安装

• 需在/etc/yum.repos.d路径下
  [root@zabbix yum.repos.d]# yum -y install mysql-server
  

5、mysql服务管理

[root@zabbix yum.repos.d]# systemctl start mysqld   # 启动服务
[root@zabbix yum.repos.d]# systemctl restart mysqld # 重启服务
[root@zabbix yum.repos.d]# systemctl stop mysqld    # 停止服务 
[root@zabbix yum.repos.d]# systemctl status mysqld  # 查看状态 

6、查看临时密码

[root@mysql yum.repos.d]# grep 'temporary password' /var/log/mysqld.log

7、登录mysql

[root@zabbix yum.repos.d]# mysql -uroot -p'hseUW9/ds-bl'

8、修改密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Yangxiao214.';

9、开启远程控制

• user表中host的值为 % 代表任意的客户端,可替换成具体IP地址。

mysql> show databases;
mysql> use mysql
mysql> show tables
mysql> desc user;
mysql> select host,user from user;
mysql> update user set host='%' where user='root';
mysql> flush privileges;

10、验证

• 开放端口(centos firewall）

[root@mysql yum.repos.d]# firewall-cmd --zone=public --add-port=3306/tcp --permanent # 添加开放的端口
[root@mysql yum.repos.d]# firewall-cmd --reload                                      # 立即生效，重启
[root@mysql yum.repos.d]# firewall-cmd --zone=public --list-ports                    # 查看开放的端口

• 使用SQLyog验证