当前位置：Gxlcms > 数据库问题 > vm12下Centos6安装mysql5.7

vm12下Centos6安装mysql5.7

时间：2021-07-01 10:21:17 帮助过：14人阅读

文件名称：mysql-5.7.18-1.el6.x86_64.rpm-bundle.tar
官方地址：https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.18-1.el6.x86_64.rpm-bundle.tar

二、安装mysql

1、解压

  1. # 将mysql-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span>.el6.x86_64.rpm-bundle.tar压缩包解压到/usr/wangzf/mysqlrpm/<span style="color: #000000">下
  2. [root@localhost downloads]# </span><span style="color: #0000ff">tar</span> -xvf mysql-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span>.el6.x86_64.rpm-bundle.<span style="color: #0000ff">tar</span> -C ../mysqlrpm/<span style="color: #000000">
  3. mysql</span>-community-libs-compat-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm
  4. mysql</span>-community-test-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm
  5. mysql</span>-community-libs-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm
  6. mysql</span>-community-common-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm
  7. mysql</span>-community-embedded-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm
  8. mysql</span>-community-embedded-devel-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm
  9. mysql</span>-community-client-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm
  10. mysql</span>-community-devel-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm
  11. mysql</span>-community-server-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm
  12. # 查看解压后的rpm软件包
  13. [root@localhost downloads]# cd ..</span>/mysqlrpm/<span style="color: #000000">
  14. [root@localhost mysqlrpm]# ll
  15. total </span><span style="color: #800080">459488</span>
  16. -rw-r--r--. <span style="color: #800080">1</span> <span style="color: #800080">7155</span> <span style="color: #800080">31415</span>  <span style="color: #800080">23618836</span> Mar <span style="color: #800080">20</span> <span style="color: #800080">05</span>:<span style="color: #800080">40</span> mysql-community-client-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm
  17. </span>-rw-r--r--. <span style="color: #800080">1</span> <span style="color: #800080">7155</span> <span style="color: #800080">31415</span>    <span style="color: #800080">335496</span> Mar <span style="color: #800080">20</span> <span style="color: #800080">05</span>:<span style="color: #800080">40</span> mysql-community-common-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm
  18. </span>-rw-r--r--. <span style="color: #800080">1</span> <span style="color: #800080">7155</span> <span style="color: #800080">31415</span>   <span style="color: #800080">3747352</span> Mar <span style="color: #800080">20</span> <span style="color: #800080">05</span>:<span style="color: #800080">40</span> mysql-community-devel-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm
  19. </span>-rw-r--r--. <span style="color: #800080">1</span> <span style="color: #800080">7155</span> <span style="color: #800080">31415</span>  <span style="color: #800080">39086508</span> Mar <span style="color: #800080">20</span> <span style="color: #800080">05</span>:<span style="color: #800080">40</span> mysql-community-embedded-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm
  20. </span>-rw-r--r--. <span style="color: #800080">1</span> <span style="color: #800080">7155</span> <span style="color: #800080">31415</span> <span style="color: #800080">135869292</span> Mar <span style="color: #800080">20</span> <span style="color: #800080">05</span>:<span style="color: #800080">40</span> mysql-community-embedded-devel-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm
  21. </span>-rw-r--r--. <span style="color: #800080">1</span> <span style="color: #800080">7155</span> <span style="color: #800080">31415</span>   <span style="color: #800080">2177064</span> Mar <span style="color: #800080">20</span> <span style="color: #800080">05</span>:<span style="color: #800080">40</span> mysql-community-libs-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm
  22. </span>-rw-r--r--. <span style="color: #800080">1</span> <span style="color: #800080">7155</span> <span style="color: #800080">31415</span>   <span style="color: #800080">1723180</span> Mar <span style="color: #800080">20</span> <span style="color: #800080">05</span>:<span style="color: #800080">40</span> mysql-community-libs-compat-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm
  23. </span>-rw-r--r--. <span style="color: #800080">1</span> <span style="color: #800080">7155</span> <span style="color: #800080">31415</span> <span style="color: #800080">159060212</span> Mar <span style="color: #800080">20</span> <span style="color: #800080">05</span>:<span style="color: #800080">41</span> mysql-community-server-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm
  24. </span>-rw-r--r--. <span style="color: #800080">1</span> <span style="color: #800080">7155</span> <span style="color: #800080">31415</span> <span style="color: #800080">104881084</span> Mar <span style="color: #800080">20</span> <span style="color: #800080">05</span>:<span style="color: #800080">41</span> mysql-community-test-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span>.el6.x86_64.rpm


2、安装mysql

  1. <span style="color: #000000"># 想要安装mysqlclient和mysqlserver，需要先安装common和libs
  2. [root@localhost mysqlrpm]# rpm </span>-ivh mysql-community-common-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm 
  3. Preparing...                ########################################### [</span><span style="color: #800080">100</span>%<span style="color: #000000">]
  4.    </span><span style="color: #800080">1</span>:mysql-community-common ########################################### [<span style="color: #800080">100</span>%<span style="color: #000000">]
  5. [root@localhost mysqlrpm]# rpm </span>-ivh mysql-community-libs-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm 
  6. Preparing...                ########################################### [</span><span style="color: #800080">100</span>%<span style="color: #000000">]
  7.    </span><span style="color: #800080">1</span>:mysql-community-libs   ########################################### [<span style="color: #800080">100</span>%<span style="color: #000000">]
  8. [root@localhost mysqlrpm]# rpm </span>-ivh mysql-community-client-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm 
  9. Preparing...                ########################################### [</span><span style="color: #800080">100</span>%<span style="color: #000000">]
  10.    </span><span style="color: #800080">1</span>:mysql-community-client ########################################### [<span style="color: #800080">100</span>%<span style="color: #000000">]
  11. [root@localhost mysqlrpm]# rpm </span>-ivh mysql-community-server-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64.rpm 
  12. Preparing...                ########################################### [</span><span style="color: #800080">100</span>%<span style="color: #000000">]
  13.    </span><span style="color: #800080">1</span>:mysql-community-server ########################################### [<span style="color: #800080">100</span>%<span style="color: #000000">]
  14. # 查看已安装的与mysql相关的软件
  15. [root@localhost mysqlrpm]# rpm </span>-qa|<span style="color: #0000ff">grep</span> -<span style="color: #000000">i  mysql
  16. mysql</span>-community-common-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64
  17. mysql</span>-community-client-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64
  18. mysql</span>-community-libs-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span><span style="color: #000000">.el6.x86_64
  19. mysql</span>-community-server-<span style="color: #800080">5.7</span>.<span style="color: #800080">18</span>-<span style="color: #800080">1</span>.el6.x86_64


3、启动mysql

  1. <span style="color: #000000"># 查看mysql服务的状态
  2. [root@localhost mysqlrpm]# service mysqld status
  3. mysqld is stopped
  4. # mysql尚未启动，使用service mysqld start启动（这里是第一次启动，会初始化一些参数）
  5. [root@localhost mysqlrpm]# service mysqld start
  6. Initializing MySQL database:                               [  OK  ]
  7. Installing validate password plugin:                       [  OK  ]
  8. Starting mysqld:                                           [  OK  ]
  9. # 停止mysql服务
  10. [root@localhost mysqlrpm]# service mysqld stop
  11. Stopping mysqld:                                           [  OK  ]
  12. # 启动mysql服务
  13. [root@localhost mysqlrpm]# service mysqld start
  14. Starting mysqld:                                           [  OK  ]
  15. # 重启mysql服务
  16. [root@localhost mysqlrpm]# service mysqld restart
  17. Stopping mysqld:                                           [  OK  ]
  18. Starting mysqld:                                           [  OK  ]</span>

 

三、修改root密码

  1. <span style="color: #000000"># 关闭mysql服务
  2. [root@localhost </span>~<span style="color: #000000">]# service mysqld stop
  3. Stopping mysqld:                                           [  OK  ]
  4. # 安全模式下启动mysql，并且跳过权限表的验证
  5. [root@</span><span style="color: #800080">192</span> ~]# mysqld_safe --skip-grant-tables &<span style="color: #000000">
  6. [</span><span style="color: #800080">1</span>] <span style="color: #800080">1678</span><span style="color: #000000">
  7. [root@</span><span style="color: #800080">192</span> ~]# <span style="color: #800080">2017</span>-<span style="color: #800080">05</span>-06T23:<span style="color: #800080">30</span>:<span style="color: #800080">01</span>.604144Z mysqld_safe Logging to <span style="color: #800000">‘</span><span style="color: #800000">/var/log/mysqld.log</span><span style="color: #800000">‘</span><span style="color: #000000">.
  8. </span><span style="color: #800080">2017</span>-<span style="color: #800080">05</span>-06T23:<span style="color: #800080">30</span>:<span style="color: #800080">01</span>.674987Z mysqld_safe Starting mysqld daemon with databases from /var/lib/<span style="color: #000000">mysql
  9. # 准备登陆
  10. mysql </span>-u root -<span style="color: #000000">p
  11. # 这里随便输入密码，都可以进入mysql 
  12. Enter password: 
  13. Welcome to the MySQL monitor.  Commands end with ; or \g.
  14. Your MySQL connection </span><span style="color: #0000ff">id</span> is <span style="color: #800080">4</span><span style="color: #000000">
  15. Server version: </span><span style="color: #800080">5.7</span>.<span style="color: #800080">18</span><span style="color: #000000"> MySQL Community Server (GPL)
  16. Copyright (c) </span><span style="color: #800080">2000</span>, <span style="color: #800080">2017</span>, Oracle and/<span style="color: #000000">or its affiliates. All rights reserved.
  17. Oracle is a registered trademark of Oracle Corporation and</span>/<span style="color: #000000">or its
  18. affiliates. Other names may be trademarks of their respective
  19. owners.
  20. Type </span><span style="color: #800000">‘</span><span style="color: #800000">help;</span><span style="color: #800000">‘</span> or <span style="color: #800000">‘</span><span style="color: #800000">\h</span><span style="color: #800000">‘</span> <span style="color: #0000ff">for</span> help. Type <span style="color: #800000">‘</span><span style="color: #800000">\c</span><span style="color: #800000">‘</span> to <span style="color: #0000ff">clear</span><span style="color: #000000"> the current input statement.
  21. # 更改密码(这里设置的密码是1234)
  22. mysql</span>> update mysql.user set authentication_string=password(<span style="color: #800000">‘</span><span style="color: #800000">1234</span><span style="color: #800000">‘</span>) where user=<span style="color: #800000">‘</span><span style="color: #800000">root</span><span style="color: #800000">‘</span> and Host = <span style="color: #800000">‘</span><span style="color: #800000">localhost</span><span style="color: #800000">‘</span><span style="color: #000000">;
  23. Query OK, </span><span style="color: #800080">1</span> row affected, <span style="color: #800080">1</span> warning (<span style="color: #800080">0.04</span><span style="color: #000000"> sec)
  24. Rows matched: </span><span style="color: #800080">1</span>  Changed: <span style="color: #800080">1</span>  Warnings: <span style="color: #800080">1</span><span style="color: #000000">
  25. # 刷新权限
  26. mysql</span>><span style="color: #000000"> flush privileges;
  27. Query OK, </span><span style="color: #800080">0</span> rows affected (<span style="color: #800080">0.00</span><span style="color: #000000"> sec)
  28. # 退出mysql
  29. mysql</span>><span style="color: #000000"> quit
  30. Bye
  31. # 重启mysql
  32. [root@localhost </span>~<span style="color: #000000">]# service mysqld restart
  33. </span><span style="color: #800080">2017</span>-<span style="color: #800080">05</span>-06T23:<span style="color: #800080">17</span>:<span style="color: #800080">47</span>.067045Z mysqld_safe mysqld from pid <span style="color: #0000ff">file</span> /var/run/mysqld/<span style="color: #000000">mysqld.pid ended
  34. Stopping mysqld:                                           [  OK  ]
  35. Starting mysqld:                                           [  OK  ]
  36. [</span><span style="color: #800080">2</span>]-  Done                    mysqld_safe --skip-grant-<span style="color: #000000">tables
  37. # 以root身份登陆
  38. [root@localhost </span>~]# mysql -uroot -<span style="color: #000000">p
  39. # 输入刚才设置的密码1234，正常使用mysql
  40. Enter password: 
  41. Welcome to the MySQL monitor.  Commands end with ; or \g.
  42. Your MySQL connection </span><span style="color: #0000ff">id</span> is <span style="color: #800080">4</span><span style="color: #000000">
  43. Server version: </span><span style="color: #800080">5.7</span>.<span style="color: #800080">18</span><span style="color: #000000">
  44. Copyright (c) </span><span style="color: #800080">2000</span>, <span style="color: #800080">2017</span>, Oracle and/<span style="color: #000000">or its affiliates. All rights reserved.
  45. Oracle is a registered trademark of Oracle Corporation and</span>/<span style="color: #000000">or its
  46. affiliates. Other names may be trademarks of their respective
  47. owners.
  48. Type </span><span style="color: #800000">‘</span><span style="color: #800000">help;</span><span style="color: #800000">‘</span> or <span style="color: #800000">‘</span><span style="color: #800000">\h</span><span style="color: #800000">‘</span> <span style="color: #0000ff">for</span> help. Type <span style="color: #800000">‘</span><span style="color: #800000">\c</span><span style="color: #800000">‘</span> to <span style="color: #0000ff">clear</span><span style="color: #000000"> the current input statement.
  49. mysql</span>>

 

四、远程访问mysql

1、centos开启防火墙端口3306

  1. <span style="color: #000000"># 开放3306端口
  2. [root@</span><span style="color: #800080">192</span> ~]# /sbin/iptables -I INPUT -p tcp --dport <span style="color: #800080">3306</span> -<span style="color: #000000">j ACCEPT
  3. # 保存
  4. [root@</span><span style="color: #800080">192</span> ~]# /etc/rc.d/init.d/<span style="color: #000000">iptables save
  5. iptables: Saving firewall rules to </span>/etc/sysconfig/<span style="color: #000000">iptables:[  OK  ]
  6. # 查看防火墙的状态
  7. [root@</span><span style="color: #800080">192</span> ~]# /etc/init.d/<span style="color: #000000">iptables status
  8. Table: filter
  9. Chain INPUT (policy ACCEPT)
  10. num  target     prot opt source               destination         
  11. </span><span style="color: #800080">1</span>    ACCEPT     tcp  --  <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>            <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>           tcp dpt:<span style="color: #800080">3306</span> 
  12. <span style="color: #800080">2</span>    ACCEPT     tcp  --  <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>            <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>           tcp dpt:<span style="color: #800080">3306</span> 
  13. <span style="color: #800080">3</span>    ACCEPT     tcp  --  <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>            <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>           tcp dpt:<span style="color: #800080">8080</span> 
  14. <span style="color: #800080">4</span>    ACCEPT     all  --  <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>            <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span><span style="color: #000000">           state RELATED,ESTABLISHED 
  15. </span><span style="color: #800080">5</span>    ACCEPT     icmp --  <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>            <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>           
  16. <span style="color: #800080">6</span>    ACCEPT     all  --  <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>            <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>           
  17. <span style="color: #800080">7</span>    ACCEPT     tcp  --  <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>            <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>           state NEW tcp dpt:<span style="color: #800080">22</span> 
  18. <span style="color: #800080">8</span>    REJECT     all  --  <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>            <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>           reject-with icmp-host-<span style="color: #000000">prohibited 
  19. Chain FORWARD (policy ACCEPT)
  20. num  target     prot opt source               destination         
  21. </span><span style="color: #800080">1</span>    REJECT     all  --  <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>            <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>           reject-with icmp-host-<span style="color: #000000">prohibited 
  22. Chain OUTPUT (policy ACCEPT)
  23. num  target     prot opt source               destination         
  24. # 删除刚刚添加的端口
  25. # 这里我原先已经开放了3306端口，再次添加又增加了一个3306，所以显示2个3306，这里我将num为2的那个3306删除
  26. [root@</span><span style="color: #800080">192</span> ~]# iptables -D INPUT <span style="color: #800080">2</span><span style="color: #000000">
  27. # 查看防火墙的状态（奇怪的是我原本也开放的有80端口，莫名其妙没了...）
  28. [root@</span><span style="color: #800080">192</span> ~]# iptables -L -n --line-<span style="color: #000000">number 
  29. Chain INPUT (policy ACCEPT)
  30. num  target     prot opt source               destination         
  31. </span><span style="color: #800080">1</span>    ACCEPT     tcp  --  <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>            <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>           tcp dpt:<span style="color: #800080">3306</span> 
  32. <span style="color: #800080">2</span>    ACCEPT     tcp  --  <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>            <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>           tcp dpt:<span style="color: #800080">8080</span> 
  33. <span style="color: #800080">3</span>    ACCEPT     all  --  <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>            <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span><span style="color: #000000">           state RELATED,ESTABLISHED 
  34. </span><span style="color: #800080">4</span>    ACCEPT     icmp --  <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>            <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>           
  35. <span style="color: #800080">5</span>    ACCEPT     all  --  <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>            <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>           
  36. <span style="color: #800080">6</span>    ACCEPT     tcp  --  <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>            <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>           state NEW tcp dpt:<span style="color: #800080">22</span> 
  37. <span style="color: #800080">7</span>    REJECT     all  --  <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>            <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>           reject-with icmp-host-<span style="color: #000000">prohibited 
  38. Chain FORWARD (policy ACCEPT)
  39. num  target     prot opt source               destination         
  40. </span><span style="color: #800080">1</span>    REJECT     all  --  <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>            <span style="color: #800080">0.0</span>.<span style="color: #800080">0.0</span>/<span style="color: #800080">0</span>           reject-with icmp-host-<span style="color: #000000">prohibited 
  41. Chain OUTPUT (policy ACCEPT)
  42. num  target     prot opt source               destination         </span>

 

2、修改mysql表，允许远程访问

  1. <span style="color: #000000"># 登陆
  2. [root@</span><span style="color: #800080">192</span> ~]# mysql -uroot -<span style="color: #000000">p
  3. Enter password: 
  4. Welcome to the MySQL monitor.  Commands end with ; or \g.
  5. Your MySQL connection </span><span style="color: #0000ff">id</span> is <span style="color: #800080">8</span><span style="color: #000000">
  6. Server version: </span><span style="color: #800080">5.7</span>.<span style="color: #800080">18</span><span style="color: #000000">
  7. Copyright (c) </span><span style="color: #800080">2000</span>, <span style="color: #800080">2017</span>, Oracle and/<span style="color: #000000">or its affiliates. All rights reserved.
  8. Oracle is a registered trademark of Oracle Corporation and</span>/<span style="color: #000000">or its
  9. affiliates. Other names may be trademarks of their respective
  10. owners.
  11. Type </span><span style="color: #800000">‘</span><span style="color: #800000">help;</span><span style="color: #800000">‘</span> or <span style="color: #800000">‘</span><span style="color: #800000">\h</span><span style="color: #800000">‘</span> <span style="color: #0000ff">for</span> help. Type <span style="color: #800000">‘</span><span style="color: #800000">\c</span><span style="color: #800000">‘</span> to <span style="color: #0000ff">clear</span><span style="color: #000000"> the current input statement.
  12. mysql</span>> GRANT ALL PRIVILEGES ON *.* TO <span style="color: #800000">‘</span><span style="color: #800000">root</span><span style="color: #800000">‘</span>@<span style="color: #800000">‘</span><span style="color: #800000">%</span><span style="color: #800000">‘</span> IDENTIFIED BY <span style="color: #800000">‘</span><span style="color: #800000">1234</span><span style="color: #800000">‘</span><span style="color: #000000"> WITH GRANT OPTION;
  13. ERROR </span><span style="color: #800080">1820</span><span style="color: #000000"> (HY000): You must reset your password using ALTER USER statement before executing this statement.
  14. # 在设置远程登录原先是提示错误。百度一番，需要设置root密码，好吧，我原先是1234，现在还设置为1234
  15. mysql</span>> SET PASSWORD = PASSWORD(<span style="color: #800000">‘</span><span style="color: #800000">1234</span><span style="color: #800000">‘</span><span style="color: #000000">);
  16. ERROR </span><span style="color: #800080">1819</span><span style="color: #000000"> (HY000): Your password does not satisfy the current policy requirements
  17. # 发现是密码太脆弱，究其根本是由于mysql有密码验证的策略，那么这里设置一下
  18. # 设置密码强度检查等级为0，</span><span style="color: #800080">0</span>/LOW、<span style="color: #800080">1</span>/MEDIUM、<span style="color: #800080">2</span>/<span style="color: #000000">STRONG。
  19. mysql</span>> set global validate_password_policy=<span style="color: #800080">0</span><span style="color: #000000">;
  20. Query OK, </span><span style="color: #800080">0</span> rows affected (<span style="color: #800080">0.00</span><span style="color: #000000"> sec)
  21. # 设置密码长度:</span><span style="color: #800080">8</span>--><span style="color: #800080">4</span><span style="color: #000000">
  22. mysql</span>> <span style="color: #0000ff">select</span><span style="color: #000000"> @@validate_password_length;
  23. </span>+----------------------------+
  24. | @@validate_password_length |
  25. +----------------------------+
  26. |                          <span style="color: #800080">8</span> |
  27. +----------------------------+
  28. <span style="color: #800080">1</span> row <span style="color: #0000ff">in</span> set (<span style="color: #800080">0.00</span><span style="color: #000000"> sec)
  29. mysql</span>> set global validate_password_length=<span style="color: #800080">4</span><span style="color: #000000">;
  30. Query OK, </span><span style="color: #800080">0</span> rows affected (<span style="color: #800080">0.00</span><span style="color: #000000"> sec)
  31. mysql</span>> <span style="color: #0000ff">select</span><span style="color: #000000"> @@validate_password_length;
  32. </span>+----------------------------+
  33. | @@validate_password_length |
  34. +----------------------------+
  35. |                          <span style="color: #800080">4</span> |
  36. +----------------------------+
  37. <span style="color: #800080">1</span> row <span style="color: #0000ff">in</span> set (<span style="color: #800080">0.00</span><span style="color: #000000"> sec)
  38. # 设置密码为1234
  39. mysql</span>> SET PASSWORD = PASSWORD(<span style="color: #800000">‘</span><span style="color: #800000">1234</span><span style="color: #800000">‘</span><span style="color: #000000">);
  40. Query OK, </span><span style="color: #800080">0</span> rows affected, <span style="color: #800080">1</span> warning (<span style="color: #800080">0.00</span><span style="color: #000000"> sec)
  41. # 设置允许远程访问
  42. mysql</span>> GRANT ALL PRIVILEGES ON *.* TO <span style="color: #800000">‘</span><span style="color: #800000">root</span><span style="color: #800000">‘</span>@<span style="color: #800000">‘</span><span style="color: #800000">%</span><span style="color: #800000">‘</span> IDENTIFIED BY <span style="color: #800000">‘</span><span style="color: #800000">1234</span><span style="color: #800000">‘</span><span style="color: #000000"> WITH GRANT OPTION;
  43. Query OK, </span><span style="color: #800080">0</span> rows affected, <span style="color: #800080">1</span> warning (<span style="color: #800080">0.00</span><span style="color: #000000"> sec)
  44. # 刷新权限
  45. mysql</span>><span style="color: #000000"> flush privileges; 
  46. Query OK, </span><span style="color: #800080">0</span> rows affected (<span style="color: #800080">0.00</span><span style="color: #000000"> sec)<br>
  47. # 退出
  48. mysql</span>><span style="color: #000000"> exit;
  49. Bye</span>

 

3、windows下远程连接vm12下centos6.9的mysql

  1. Microsoft Windows [版本 <span style="color: #800080">6.1</span>.<span style="color: #800080">7601</span><span style="color: #000000">]
  2. 版权所有 (c) </span><span style="color: #800080">2009</span><span style="color: #000000"> Microsoft Corporation。保留所有权利。
  3. C:\Users\Administrator</span>>mysql -h <span style="color: #800080">192.168</span>.<span style="color: #800080">22.130</span> -u root -<span style="color: #000000">p
  4. Enter password: </span>****<span style="color: #000000">
  5. Welcome to the MySQL monitor.  Commands end with ; or \g.
  6. Your MySQL connection </span><span style="color: #0000ff">id</span> is <span style="color: #800080">15</span><span style="color: #000000">
  7. Server version: </span><span style="color: #800080">5.7</span>.<span style="color: #800080">18</span><span style="color: #000000"> MySQL Community Server (GPL)
  8. Copyright (c) </span><span style="color: #800080">2000</span>, <span style="color: #800080">2016</span>, Oracle and/<span style="color: #000000">or its affiliates. All rights reserved.
  9. Oracle is a registered trademark of Oracle Corporation and</span>/<span style="color: #000000">or its
  10. affiliates. Other names may be trademarks of their respective
  11. owners.
  12. Type </span><span style="color: #800000">‘</span><span style="color: #800000">help;</span><span style="color: #800000">‘</span> or <span style="color: #800000">‘</span><span style="color: #800000">\h</span><span style="color: #800000">‘</span> <span style="color: #0000ff">for</span> help. Type <span style="color: #800000">‘</span><span style="color: #800000">\c</span><span style="color: #800000">‘</span> to <span style="color: #0000ff">clear</span><span style="color: #000000"> the current input statement.
  13. mysql</span>>

 

最后就问下：惊不惊喜？意不意外？

vm12下Centos6安装mysql5.7

标签：exit   daemon   acl   res   stop   服务   other   down   ges   

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！