Linux yum安装MySQL5.7，及远程连接mysql(亲测有效！)

淡淡的烟草味﹌ 2022-01-12 02:35 642阅读 0赞

**一、安装配置MySQL的yum源**

<table> 
 <tbody> 
  <tr> 
   <td> <p>1</p> <p>2</p> <p>3</p> <p>4</p> <p>5</p> <p>6</p> <p>7</p> <p>8</p> <p>9</p> <p>10</p> </td> 
   <td> <p><code># 安装MySQL的yum源，下面是RHEL6系列的下载地址</code></p> <p><code>rpm -Uvh http:</code><code>//dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm</code></p> <p><code># 安装yum-config-manager</code></p> <p><code>yum install yum-utils -y</code></p> <p><code># 禁用MySQL5.6的源</code></p> <p><code>yum-config-manager --disable mysql56-community</code></p> <p><code># 启用MySQL5.7的源</code></p> <p><code>yum-config-manager --enable mysql57-community-dmr</code></p> <p><code># 用下面的命令查看是否配置正确</code></p> <p><code>yum repolist enabled | grep mysql</code></p> </td> 
  </tr> 
 </tbody> 
</table>

![format_png][]

检查是否有mysql57-community-dmr这个源，如上图所示。

**二、yum安装MySQL5.7**

`# 安装MySQL5.7`

`yum ``install` `mysql-community-serve`

报错； 您可以尝试添加 --skip-broken 选项来解决该问题  您可以尝试执行：rpm -Va --nofiles --nodigest

修改/etc/yum.repos.d/mysql-community.repo 源文件

vim /etc/yum.repos.d/mysql-community.repo

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyMDc0NTI3_size_16_color_FFFFFF_t_70][]

然后再次执行`yum ``install` `mysql-community-server`

![format_png 1][]

**![format_png 2][]**

![format_png 3][]

**三、启动MySQL**

`# 禁用selinux`

`setenforce 0`

`sed` `-i ``'/^SELINUX=/c\SELINUX=disabled'` `/etc/selinux/config`

`# 启动mysqld，启动之前先修改/etc/my.cnf配置文件，本文用默认的配置。`

`service mysqld start`

![format_png 4][]

![format_png 5][]

**四****、连接MySQL并修改密码**

\[root@iZ2zeintcn2jtegaarzs4yZ ~\]\#  grep "password" /var/log/mysqld.log

**![format_png 6][]**

\[root@iZ2zeintcn2jtegaarzs4yZ ~\]\# mysql -uroot -p

![format_png 7][]

mysql> set global validate\_password\_policy=0;

mysql> set global validate\_password\_length=1;

mysql> set password=password('123456');

![format_png 8][]

**五****、使用Navicat远程连接MySQL报错1103**

<table> 
 <tbody> 
  <tr> 
   <td> <p>1</p> </td> 
   <td> <p><code>&lt;span style=</code><code>"font-size: 14px;"</code><code>&gt;#给用户授权&lt;/span&gt;&lt;br&gt;&lt;span style=</code><code>"font-size: 14px;"</code><code>&gt;我用的用户:root ，密码：@Wtt102501@&lt;/span&gt;&lt;br&gt;&lt;span style=</code><code>"font-size: 14px;"</code><code>&gt;grant all privileges&nbsp;</code><code>on</code>&nbsp;<code>*.* to&nbsp;</code><code>'root'</code><code>@</code><code>'%'</code>&nbsp;<code>identified&nbsp;</code><code>by</code>&nbsp;<code>'@Wtt102501@'</code>&nbsp;<code>with grant option;&lt;/span&gt;&lt;br&gt;&lt;span style=</code><code>"font-size: 14px;"</code><code>&gt;#执行完后刷新权限&lt;/span&gt;&lt;br&gt;&lt;span style=</code><code>"font-size: 14px;"</code><code>&gt;flush privileges;&lt;/span&gt;</code></p> </td> 
  </tr> 
 </tbody> 
</table>

mysql> grant all privileges on \*.\* to 'root'@'%' identified by 'Password123@mysql' with grant option;

mysql> flush privileges; ![format_png 9][]

开放3306端口；

\[root@iZrj98hvt5pgeax2pgdjw3Z ~\]\# vi  /etc/sysconfig/iptables

**防火墙开放3306端口**

1、打开防火墙配置文件

vi  /etc/sysconfig/iptables

如果没有这个文件，需要安装iptables

#先检查是否安装了iptables
    service iptables status
    #安装iptables
    yum install -y iptables
    #升级iptables
    yum update iptables 
    #安装iptables-services
    yum install iptables-services

禁用/停止自带的firewalld服务

#停止firewalld服务
    systemctl stop firewalld
    #禁用firewalld服务
    systemctl mask firewalld

开启iptables服务

![复制代码][aHR0cHM6Ly9jb21tb24uY25ibG9ncy5jb20vaW1hZ2VzL2NvcHljb2RlLmdpZg]

#注册iptables服务
    #相当于以前的chkconfig iptables on
    systemctl enable iptables.service
    #开启服务
    systemctl start iptables.service
    #查看状态
    systemctl status iptables.service

vi /etc/sysconfig/iptables

2、增加下面一行

注意：增加的开放3306端口的语句一定要在icmp-host-prohibited之前

-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT

3、重启防火墙

service  iptables restart

附：个人配置

![复制代码][aHR0cHM6Ly9jb21tb24uY25ibG9ncy5jb20vaW1hZ2VzL2NvcHljb2RlLmdpZg]

# Firewall configuration written by system-config-firewall
    # Manual customization of this file is not recommended.
    *filter
    :INPUT ACCEPT [0:0]
    :FORWARD ACCEPT [0:0]
    :OUTPUT ACCEPT [0:0]
    -A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
    -A INPUT -p icmp -j ACCEPT
    -A INPUT -i lo -j ACCEPT
    -A INPUT -i eth0 -j ACCEPT
    -A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
    -A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT
    -A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
    -A FORWARD -m state --state ESTABLISHED,RELATED -j ACCEPT
    -A FORWARD -p icmp -j ACCEPT
    -A FORWARD -i lo -j ACCEPT
    -A FORWARD -i eth0 -j ACCEPT
    -A INPUT -j REJECT --reject-with icmp-host-prohibited
    -A FORWARD -j REJECT --reject-with icmp-host-prohibited
    COMMIT

1 无法联网；

wget [https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.22-linux-glibc2.12-x86\_64.tar.gz][https_dev.mysql.com_get_Downloads_MySQL-5.7_mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz]

2 创建mysql目录

<table> 
 <tbody> 
  <tr> 
   <td> <p>cd /usr/local</p> </td> 
  </tr> 
  <tr> 
   <td> <p>mkdir mysql</p> </td> 
  </tr> 
 </tbody> 
</table>

**3****）**进入mysql

<table> 
 <tbody> 
  <tr> 
   <td> <p>&nbsp;&nbsp; cd /usr/local/mysql/</p> </td> 
  </tr> 
 </tbody> 
</table>

**5****）**解压

<table> 
 <tbody> 
  <tr> 
   <td> <p>&nbsp; &nbsp;&nbsp;tar -xvf&nbsp;mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz</p> </td> 
  </tr> 
 </tbody> 
</table>

**6****）**新建data目录

<table> 
 <tbody> 
  <tr> 
   <td> <p>mkdir /usr/local/mysql/data</p> </td> 
  </tr> 
 </tbody> 
</table>

**7****）**新建mysql用户、mysql用户组

<table> 
 <tbody> 
  <tr> 
   <td> <p># mysql用户组</p> <p>groupadd mysql</p> </td> 
  </tr> 
  <tr> 
   <td> <p># mysql用户</p> <p>useradd mysql -g mysql</p> </td> 
  </tr> 
 </tbody> 
</table>

**8****）**将/usr/local/mysql的所有者及所属组改为mysql

<table> 
 <tbody> 
  <tr> 
   <td> <p>chown -R mysql.mysql /usr/local/mysql</p> </td> 
  </tr> 
 </tbody> 
</table>

**9****）**数据库初始化

<table> 
 <tbody> 
  <tr> 
   <td> <p>/usr/local/mysql/mysql-5.7.22-linux-glibc2.12-x86_64/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data</p> </td> 
  </tr> 
  <tr> 
   <td> <p>如出现如下错误</p> <p><img alt="" height="160" src="https://imgconvert.csdnimg.cn/aHR0cHM6Ly9vc2NpbWcub3NjaGluYS5uZXQvb3NjbmV0LzZlYzIzYzc0NzdjNjBhMmE3NWUxMDQxZWVkNGM4Y2NkNmMyLmpwZw?x-oss-process=image/format,png" width="1099"></p> </td> 
  </tr> 
  <tr> 
   <td> <p>则使用以下命令：</p> <p>/usr/local/mysql/mysql-5.7.22-linux-glibc2.12-x86_64/bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --initialize</p> <p><img alt="" height="150" src="https://imgconvert.csdnimg.cn/aHR0cHM6Ly9vc2NpbWcub3NjaGluYS5uZXQvb3NjbmV0L2MzMDU2M2Y1NDhiODQxMWFmMzQzODllNWVmNzI3ZGY2MWZjLmpwZw?x-oss-process=image/format,png" width="974"></p> </td> 
  </tr> 
  <tr> 
   <td> <p># 如果出现以下错误：</p> <p>/usr/local/mysql/ mysql-5.7.22-linux-glibc2.12-x86_64/bin/mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory</p> <p># 则执行以下命令：</p> <p>yum -y install numactl</p> <p># 完成后继续安装：</p> <p>/usr/local/mysql/mysql-5.7.22-linux-glibc2.12-x86_64/bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --initialize</p> </td> 
  </tr> 
 </tbody> 
</table>

\# 编辑/etc/my.cnf

<table> 
 <tbody> 
  <tr> 
   <td> <p>[mysqld]</p> <p>datadir=/usr/local/mysql/data</p> <p>basedir=/usr/local/mysql/mysql-5.7.22-linux-glibc2.12-x86_64</p> <p>socket=/tmp/mysql.sock</p> <p>user=mysql</p> <p>port=3306</p> <p>character-set-server=utf8<br> # 取消密码验证<br> skip-grant-tables</p> <p># Disabling symbolic-links is recommended to prevent assorted security risks</p> <p>symbolic-links=0</p> <p># skip-grant-tables</p> <p>[mysqld_safe]</p> <p>log-error=/var/log/mysqld.log</p> <p>pid-file=/var/run/mysqld/mysqld.pid</p> </td> 
  </tr> 
 </tbody> 
</table>

**10****）**开启服务

<table> 
 <tbody> 
  <tr> 
   <td> <p># 将mysql加入服务</p> <p>cp /usr/local/mysql/mysql-5.7.22-linux-glibc2.12-x86_64/support-files/mysql.server /etc/init.d/mysql</p> </td> 
  </tr> 
  <tr> 
   <td> <p># 开机自启</p> <p>chkconfig mysql on</p> </td> 
  </tr> 
  <tr> 
   <td> <p># 启动服务</p> <p>service mysql start</p> </td> 
  </tr> 
  <tr> 
   <td> <p>#查看端口</p> <p>netstat -tulpn</p> </td> 
  </tr> 
 </tbody> 
</table>

**11****）**设置密码

<table> 
 <tbody> 
  <tr> 
   <td> <p># 登录（由于/etc/my.cnf中设置了取消密码验证，所以此处密码任意）</p> <p>/usr/local/mysql/mysql-5.7.22-linux-glibc2.12-x86_64/bin/mysql -u root -p</p> </td> 
  </tr> 
  <tr> 
   <td> <p># 操作mysql数据库</p> <p>&gt;&gt;use mysql;</p> </td> 
  </tr> 
  <tr> 
   <td> <p># 修改密码</p> <p>&gt;&gt;update user set&nbsp;authentication_string=password('123456') where user='root';</p> <p>&gt;&gt;flush privileges;</p> <p>&gt;&gt;exit;</p> </td> 
  </tr> 
 </tbody> 
</table>

**12****）**将/etc/my.cnf中的skip-grant-tables删除

**13****）**登录再次设置密码（必要步骤，密码可与上面一致）

<table> 
 <tbody> 
  <tr> 
   <td> <p>/usr/local/mysql/mysql-5.7.22-linux-glibc2.12-x86_64/bin/mysql -u root -p</p> <p>&nbsp;&gt;&gt;ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';</p> <p>&gt;&gt;exit;</p> </td> 
  </tr> 
 </tbody> 
</table>

**14****）**允许远程连接

<table> 
 <tbody> 
  <tr> 
   <td> <p>/usr/local/mysql/mysql-5.7.22-linux-glibc2.12-x86_64/bin/mysql -u root -p</p> <p>&gt;&gt;use mysql;</p> <p>&gt;&gt;update user set host='%' where user = 'root';</p> <p>&gt;&gt;flush privileges;</p> <p>&nbsp;&nbsp;&nbsp; &gt;&gt;exit;</p> </td> 
  </tr> 
 </tbody> 
</table>

**15****）**添加快捷方式

<table> 
 <tbody> 
  <tr> 
   <td> <p>ln -s /usr/local/mysql/bin/mysql /usr/bin</p> </td> 
  </tr> 
 </tbody> 
</table>

**16****） **7.5及以上功能依赖检测功能

<table> 
 <tbody> 
  <tr> 
   <td> <p>/usr/local/mysql/mysql-5.7.22-linux-glibc2.12-x86_64/bin/mysql -u root -p</p> <p>&gt;&gt;use mysql;</p> <p>&gt;&gt;select @@global.sql_mode;</p> </td> 
  </tr> 
  <tr> 
   <td> <p>去掉ONLY_FULL_GROUP_BY修改配置文件my.cnf</p> </td> 
  </tr> 
  <tr> 
   <td> <p>sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,</p> <p>NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,</p> <p>NO_ENGINE_SUBSTITUTION（去除换行符）</p> </td> 
  </tr> 
  <tr> 
   <td> <p>重启数据库service mysql restart</p> </td> 
  </tr> 
 </tbody> 
</table>

2.1.1 创建数据库

1）创建数据库

<table> 
 <tbody> 
  <tr> 
   <td> <p>使用root账号登录</p> <p>/usr/local/mysql/mysql-5.7.22-linux-glibc2.12-x86_64/bin/mysql -u root -p</p> <p>在mysql命令行中输入以下命令创建法人认证数据库</p> <p>&nbsp;&nbsp;&nbsp; mysql&gt;create database authentification;</p> </td> 
  </tr> 
 </tbody> 
</table>

2）导入数据库脚本

<table> 
 <tbody> 
  <tr> 
   <td> <p>&nbsp;&nbsp;&nbsp; mysql&gt;use authentification;</p> <p>&nbsp; &nbsp;&nbsp;mysql&gt;set names utf8;</p> <p>&nbsp; &nbsp;&nbsp;mysql&gt;source /usr/local/mysql/authentification.sql;( source 脚本路径)</p> </td> 
  </tr> 
 </tbody> 
</table>

[format_png]: /images/20220109/b52b0e5013774718bc65c1ec9a8cc429.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyMDc0NTI3_size_16_color_FFFFFF_t_70]: /images/20220109/d2017c46f4b34584836a164cc1ab0985.png
[format_png 1]: /images/20220109/020d707fd7764cf586a3e8220a5e2921.png
[format_png 2]: /images/20220109/2fe0ccec736c4319949526a1ddc20217.png
[format_png 3]: /images/20220109/ad2cd42c83f8462bae7f95eb7ea65d87.png
[format_png 4]: /images/20220109/bb8127e1f70e4fa3947abf08c23bfd57.png
[format_png 5]: /images/20220109/617eefcfb32a49f6a678db06eda42ef4.png
[format_png 6]: /images/20220109/40e9b1b81a36464791d0207dddf85f54.png
[format_png 7]: /images/20220109/8df9a94965894ac39c4fbeb29256a248.png
[format_png 8]: /images/20220109/d31cd411fe9b4908a60d2d0acab1e036.png
[format_png 9]: /images/20220109/bbbe31aa1e0746f28a44c23bac471f8a.png
[aHR0cHM6Ly9jb21tb24uY25ibG9ncy5jb20vaW1hZ2VzL2NvcHljb2RlLmdpZg]: /images/20220109/43b5fef28c504e229d72170b5ed3090e.png
[https_dev.mysql.com_get_Downloads_MySQL-5.7_mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz]: https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz