暂无图片
暂无图片
暂无图片
暂无图片
暂无图片
首页 / CentOS7安装MySQL8.0安装小计

CentOS7安装MySQL8.0安装小计

逸鹏说道 2019-05-15
226

文章汇总：https://www.cnblogs.com/dotnetcrazy/p/9160514.html

目录：

  • 1.环境安装

  • 2.初始化配置

  • 3.权限设置

  • 4.配置相关

  • 测试

  • Shell附录

  • 1.安装附录

  • 2.初始化配置附录

  • 3.权限附录

  • 4.配置附录

之前讲配置文件和权限的时候有很多MySQL8的知识，有同志说安装不太一样，希望发个文，我这边简单演示一下

1.环境安装

下载MySQL提供的CentOS7的yum源

官方文档：<https://dev.mysql.com/doc/refman/8.0/en/>

过程中有不太懂的可以看我之前写的这篇文章：<http://www.cnblogs.com/dotnetcrazy/p/9887708.html>

 

CentOS命令：curl https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm > centos7.mysql.rpm  下载yum源（curl是系统自带的）

安装yum源：yum install centos7.mysql.rpm -y

安装MySQL8.0 yum install mysql-community-server -y

启动mysql systemctl start mysqld

设置开机启动mysql systemctl enable mysqld

2.初始化配置

查看初始密码 cat var/log/mysqld.log | grep "password"

安全初始化 mysql_secure_installation

3.权限设置

权限相关详细可以查看上次写的文章：聊聊数据库：SQL运维~存储引擎与权限

用root账号登录 mysql -uroot -p

创建用户dnt create user dnt@'%' identified by '含大小写字母+数字的密码';

查看当前有哪些用户 select user,authentication_string,host from mysql.user

给用户dnt分配数据库dotnetcrazy的所有权限 grant all on dotnetcrazy.* to dnt;

刷新权限 flush privileges;

显示新用户有哪些权限 show grants for dnt;

 

4.配置相关

这块我就说下开远程的配置，其他的可以查看之前写的文章：<https://www.cnblogs.com/dotnetcrazy/p/10810798.html>

root权限去修改 /etc/my.cnf

在[mysqld]选项下新增：bind-address=0.0.0.0

开放3306端口的远程访问权限：firewall-cmd --zone=public --add-port=3306/tcp --permanent

刷新防火墙规则 firewall-cmd --reload

重启MySQL：systemctl restart mysqld

 

测试

Shell附录

1.安装附录

  1. # 下载yum源（curl是系统自带的）
  2. # curl https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm > centos7.mysql.rpm
  3. [root@localhost dnt] curl https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm > centos7.mysql.rpm
  4.   % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
  5.                                  Dload  Upload   Total   Spent    Left  Speed
  6. 100 26024  100 26024    0     0  38150      0 --:--:-- --:--:-- --:--:-- 38158
  7. [root@localhost dnt]# ls
  8. centos7.mysql.rpm
  10. # 安装MySQL的yum源
  11. # yum install centos7.mysql.rpm -y
  12. [root@localhost dnt] yum install centos7.mysql.rpm -y
  13. 已加载插件：fastestmirror
  14. 正在检查 centos7.mysql.rpm: mysql80-community-release-el7-3.noarch
  15. centos7.mysql.rpm 将被安装
  16. 正在解决依赖关系
  17. --> 正在检查事务
  18. ---> 软件包 mysql80-community-release.noarch.0.el7-3 将被 安装
  19. --> 解决依赖关系完成
  21. 依赖关系解决
  23. ==========================================================================================================
  24.  Package                                架构                版本                 源                           大小
  25. ==========================================================================================================
  26. 正在安装:
  27.  mysql80-community-release              noarch              el7-3                /centos7.mysql               31 k
  29. 事务概要
  30. ==========================================================================================================
  31. 安装  1 软件包
  33. 总计：31 k
  34. 安装大小：31 k
  35. Downloading packages:
  36. Running transaction check
  37. Running transaction test
  38. Transaction test succeeded
  39. Running transaction
  40.   正在安装    : mysql80-community-release-el7-3.noarch                                                         1/1
  41.   验证中      : mysql80-community-release-el7-3.noarch                                                         1/1
  43. 已安装:
  44.   mysql80-community-release.noarch 0:el7-3
  46. 完毕！
  48. # 安装MySQL8.0
  49. # yum install mysql-community-server -y
  50. [root@localhost dnt] yum install mysql-community-server -y
  51. 已加载插件：fastestmirror
  52. Loading mirror speeds from cached hostfile
  53.  * base: mirrors.aliyun.com
  54.  * extras: mirrors.cn99.com
  55.  * updates: mirrors.aliyun.com
  56. base                                                                                        | 3.6 kB  00:00:00
  57. extras                                                                                      | 3.4 kB  00:00:00
  58. mysql-connectors-community                                                                  | 2.5 kB  00:00:00
  59. mysql-tools-community                                                                       | 2.5 kB  00:00:00
  60. mysql80-community                                                                           | 2.5 kB  00:00:00
  61. updates                                                                                     | 3.4 kB  00:00:00
  62. (1/3): mysql-connectors-community/x86_64/primary_db                                         |  41 kB  00:00:00
  63. (2/3): mysql80-community/x86_64/primary_db                                                  |  70 kB  00:00:00
  64. (3/3): mysql-tools-community/x86_64/primary_db                                              |  58 kB  00:00:00
  65. 正在解决依赖关系
  66. --> 正在检查事务
  67. ---> 软件包 mysql-community-server.x86_64.0.8.0.16-2.el7 将被 安装
  68. --> 正在处理依赖关系 mysql-community-common(x86-64) = 8.0.16-2.el7，它被软件包 mysql-community-server-8.0.16-2.el7.x86_64 需要
  69. --> 正在处理依赖关系 mysql-community-client(x86-64) >= 8.0.11，它被软件包 mysql-community-server-8.0.16-2.el7.x86_64 需要
  70. --> 正在处理依赖关系 net-tools，它被软件包 mysql-community-server-8.0.16-2.el7.x86_64 需要
  71. --> 正在检查事务
  72. ---> 软件包 mysql-community-client.x86_64.0.8.0.16-2.el7 将被 安装
  73. --> 正在处理依赖关系 mysql-community-libs(x86-64) >= 8.0.11，它被软件包 mysql-community-client-8.0.16-2.el7.x86_64 需要
  74. ---> 软件包 mysql-community-common.x86_64.0.8.0.16-2.el7 将被 安装
  75. ---> 软件包 net-tools.x86_64.0.2.0-0.24.20131004git.el7 将被 安装
  76. --> 正在检查事务
  77. ---> 软件包 mariadb-libs.x86_64.1.5.5.60-1.el7_5 将被 取代
  78. --> 正在处理依赖关系 libmysqlclient.so.18()(64bit)，它被软件包 2:postfix-2.10.1-7.el7.x86_64 需要
  79. --> 正在处理依赖关系 libmysqlclient.so.18(libmysqlclient_18)(64bit)，它被软件包 2:postfix-2.10.1-7.el7.x86_64 需要
  80. ---> 软件包 mysql-community-libs.x86_64.0.8.0.16-2.el7 将被 舍弃
  81. --> 正在检查事务
  82. ---> 软件包 mysql-community-libs-compat.x86_64.0.8.0.16-2.el7 将被 舍弃
  83. --> 解决依赖关系完成
  85. 依赖关系解决
  87. ==========================================================================================================
  88.  Package                            架构          版本                              源                        大小
  89. ==========================================================================================================
  90. 正在安装:
  91.  mysql-community-libs               x86_64        8.0.16-2.el7                      mysql80-community        3.0 M
  92.       替换  mariadb-libs.x86_64 1:5.5.60-1.el7_5
  93.  mysql-community-libs-compat        x86_64        8.0.16-2.el7                      mysql80-community        2.1 M
  94.       替换  mariadb-libs.x86_64 1:5.5.60-1.el7_5
  95.  mysql-community-server             x86_64        8.0.16-2.el7                      mysql80-community        403 M
  96. 为依赖而安装:
  97.  mysql-community-client             x86_64        8.0.16-2.el7                      mysql80-community         32 M
  98.  mysql-community-common             x86_64        8.0.16-2.el7                      mysql80-community        575 k
  99.  net-tools                          x86_64        2.0-0.24.20131004git.el7          base                     306 k
  101. 事务概要
  102. ==========================================================================================================
  103. 安装  3 软件包 (+3 依赖软件包)
  105. 总下载量：441 M
  106. Downloading packages:
  107. 警告：/var/cache/yum/x86_64/7/mysql80-community/packages/mysql-community-common-8.0.16-2.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
  108. mysql-community-common-8.0.16-2.el7.x86_64.rpm 的公钥尚未安装
  109. (1/6): mysql-community-common-8.0.16-2.el7.x86_64.rpm                                       | 575 kB  00:00:00
  110. (2/6): mysql-community-libs-8.0.16-2.el7.x86_64.rpm                                         | 3.0 MB  00:00:00
  111. (3/6): mysql-community-libs-compat-8.0.16-2.el7.x86_64.rpm                                  | 2.1 MB  00:00:00
  112. (4/6): net-tools-2.0-0.24.20131004git.el7.x86_64.rpm                                        | 306 kB  00:00:00
  113. (5/6): mysql-community-client-8.0.16-2.el7.x86_64.rpm                                       |  32 MB  00:00:14
  114. (6/6): mysql-community-server-8.0.16-2.el7.x86_64.rpm                                       | 403 MB  00:01:08
  115. -------------------------------------------------------------------------------------------------------------------
  116. 总计                                                                               6.2 MB/s | 441 MB  00:01:10
  117. 从 file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql 检索密钥
  118. 导入 GPG key 0x5072E1F5:
  119.  用户ID     : "MySQL Release Engineering <mysql-build@oss.oracle.com>"
  120.  指纹       : a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
  121.  软件包     : mysql80-community-release-el7-3.noarch (installed)
  122.  来自       : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
  123. Running transaction check
  124. Running transaction test
  125. Transaction test succeeded
  126. Running transaction
  127.   正在安装    : mysql-community-common-8.0.16-2.el7.x86_64                                                     1/7 
  128.   正在安装    : mysql-community-libs-8.0.16-2.el7.x86_64                                                       2/7 
  129.   正在安装    : mysql-community-client-8.0.16-2.el7.x86_64                                                     3/7 
  130.   正在安装    : net-tools-2.0-0.24.20131004git.el7.x86_64                                                      4/7 
  131.   正在安装    : mysql-community-server-8.0.16-2.el7.x86_64                                                     5/7 
  132.   正在安装    : mysql-community-libs-compat-8.0.16-2.el7.x86_64                                                6/7 
  133.   正在删除    : 1:mariadb-libs-5.5.60-1.el7_5.x86_64                                                           7/7 
  134.   验证中      : mysql-community-libs-8.0.16-2.el7.x86_64                                                       1/7 
  135.   验证中      : net-tools-2.0-0.24.20131004git.el7.x86_64                                                      2/7 
  136.   验证中      : mysql-community-libs-compat-8.0.16-2.el7.x86_64                                                3/7 
  137.   验证中      : mysql-community-client-8.0.16-2.el7.x86_64                                                     4/7 
  138.   验证中      : mysql-community-common-8.0.16-2.el7.x86_64                                                     5/7 
  139.   验证中      : mysql-community-server-8.0.16-2.el7.x86_64                                                     6/7 
  140.   验证中      : 1:mariadb-libs-5.5.60-1.el7_5.x86_64                                                           7/7 
  142. 已安装:
  143.   mysql-community-libs.x86_64 0:8.0.16-2.el7            mysql-community-libs-compat.x86_64 0:8.0.16-2.el7
  144.   mysql-community-server.x86_64 0:8.0.16-2.el7
  146. 作为依赖被安装:
  147.   mysql-community-client.x86_64 0:8.0.16-2.el7             mysql-community-common.x86_64 0:8.0.16-2.el7
  148.   net-tools.x86_64 0:2.0-0.24.20131004git.el7
  150. 替代:
  151.   mariadb-libs.x86_64 1:5.5.60-1.el7_5
  153. 完毕！
  155. # 启动mysql
  156. # systemctl start mysqld
  157. [root@localhost dnt] systemctl start mysqld
  158. [root@localhost dnt] pstree | grep mysql
  159.         |-mysqld---37*[{mysqld}]
  161. # 设置开机启动mysql
  162. # systemctl enable mysqld
  163. [root@localhost dnt] systemctl enable mysqld
  164. [root@localhost dnt] reboot
  165. Connection closing...Socket close.
  167. Connection closed by foreign host.
  169. Disconnected from remote host(MySQL_CentOS) at 10:56:42.
  171. Connecting to 192.168.36.205:22...
  172. Connection established.
  173. To escape to local shell, press 'Ctrl+Alt+]'.
  175. WARNING! The remote SSH server rejected X11 forwarding request.
  176. Last login: Wed May 15 10:35:07 2019 from 192.168.36.144
  177. [dnt@localhost ~]$ pstree | grep mysql
  178.         |-mysqld---37*[{mysqld}]
  180. # 查看mysql的状态
  181. # systemctl status mysqld
  182. [dnt@localhost ~]$ systemctl status mysqld
  183. ● mysqld.service - MySQL Server
  184.    Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
  185.    Active: active (running) since 三 2019-05-15 10:57:26 CST; 1min 3s ago
  186.      Docs: man:mysqld(8)
  187.            http://dev.mysql.com/doc/refman/en/using-systemd.html
  188.   Process: 3934 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
  189.  Main PID: 3969 (mysqld)
  190.    Status: "SERVER_OPERATING"
  191.    CGroup: /system.slice/mysqld.service
  192.            └─3969 /usr/sbin/mysqld

2.初始化配置附录

  1. # 查看初始密码
  2. # cat /var/log/mysqld.log | grep "password"
  3. [dnt@localhost ~]$ cat /var/log/mysqld.log | grep "password"
  4. 2019-05-15T02:55:51.132377Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: wI>X.(tHE5&e
  6. # 安全初始化
  7. # mysql_secure_installation
  8. [dnt@localhost ~]$ mysql_secure_installation
  10. Securing the MySQL server deployment.
  12. Enter password for user root: 
  13. The 'validate_password' component is installed on the server.
  14. The subsequent steps will run with the existing configuration
  15. of the component.
  16. Using existing password for root.
  18. Estimated strength of the password: 100 
  19. Change the password for root ? ((Press y|Y for Yes, any other key for No) : n
  21.  ... skipping.
  22. By default, a MySQL installation has an anonymous user,
  23. allowing anyone to log into MySQL without having to have
  24. a user account created for them. This is intended only for
  25. testing, and to make the installation go a bit smoother.
  26. You should remove them before moving into a production
  27. environment.
  29. Remove anonymous users? (Press y|Y for Yes, any other key for No) : y
  30. Success.
  33. Normally, root should only be allowed to connect from
  34. 'localhost'. This ensures that someone cannot guess at
  35. the root password from the network.
  37. Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y
  38. Success.
  40. By default, MySQL comes with a database named 'test' that
  41. anyone can access. This is also intended only for testing,
  42. and should be removed before moving into a production
  43. environment.
  46. Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
  47.  - Dropping test database...
  48. Success.
  50.  - Removing privileges on test database...
  51. Success.
  53. Reloading the privilege tables will ensure that all changes
  54. made so far will take effect immediately.
  56. Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y
  57. Success.
  59. All done!

3.权限附录

  1. # 用root账号登录
  2. # mysql -uroot -p
  3. [dnt@localhost ~]$ mysql -uroot -p
  4. Enter password:
  5. Welcome to the MySQL monitor.  Commands end with ; or \g.
  6. Your MySQL connection id is 38
  7. Server version: 8.0.16 MySQL Community Server - GPL
  9. Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
  11. Oracle is a registered trademark of Oracle Corporation and/or its
  12. affiliates. Other names may be trademarks of their respective
  13. owners.
  15. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  17. # show databases;
  18. mysql> show databases;
  19. +--------------------+
  20. | Database           |
  21. +--------------------+
  22. | information_schema |
  23. | mysql              |
  24. | performance_schema |
  25. | sys                |
  26. +--------------------+
  27. 4 rows in set (0.00 sec)
  29. # 创建用户dnt
  30. # create user dnt@'%' identified by '含大小写字母+数字的密码';
  31. mysql> create user dnt@'%' identified by '含大小写字母+数字的密码';
  32. Query OK, 0 rows affected (0.06 sec)
  34. # 查看当前有哪些用户
  35. # select user,authentication_string,host from mysql.user;
  36. mysql> select user,authentication_string,host from mysql.user;
  37. +------------------+------------------------------------------------------------------------+-----------+
  38. | user             | authentication_string                                                  | host      |
  39. +------------------+------------------------------------------------------------------------+-----------+
  40. | dnt              | $A$005$yOK}8VFp<    LE0BLBPFmeTy2vi8Q1JdmkhkPkaWBilxWYW2/jSsJ4OEa7B | %         |
  41. | mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | localhost |
  42. | mysql.session    | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | localhost |
  43. | mysql.sys        | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | localhost |
  44. | root             | $A$005$yAn@!RwTRzRLdyRrHMdoneUh7pdKEJVFUl9LHdG5MHeL.gdovFMI7z22 | localhost |
  45. +------------------+------------------------------------------------------------------------+-----------+
  46. 5 rows in set (0.00 sec)
  48. # 创建一个数据库
  49. # create database dotnetcrazy charset=utf8;
  50. mysql> create database dotnetcrazy charset=utf8;
  51. Query OK, 1 row affected, 1 warning (0.71 sec)
  53. mysql> show databases;
  54. +--------------------+
  55. | Database           |
  56. +--------------------+
  57. | dotnetcrazy        |
  58. | information_schema |
  59. | mysql              |
  60. | performance_schema |
  61. | sys                |
  62. +--------------------+
  63. 5 rows in set (0.00 sec)
  65. # 给用户dnt分配数据库dotnetcrazy的所有权限
  66. # grant all on dotnetcrazy.* to dnt;
  67. mysql> grant all on dotnetcrazy.* to dnt;
  68. Query OK, 0 rows affected (0.69 sec)
  70. # 刷新权限
  71. # flush privileges;
  72. mysql> flush privileges;
  73. Query OK, 0 rows affected (0.59 sec)
  75. # 显示新用户有哪些权限
  76. # show grants for dnt;
  77. mysql> show grants for dnt;
  78. +------------------------------------------------------+
  79. | Grants for dnt@%                                     |
  80. +------------------------------------------------------+
  81. | GRANT USAGE ON *.* TO `dnt`@`%`                      |
  82. | GRANT ALL PRIVILEGES ON `dotnetcrazy`.* TO `dnt`@`%` |
  83. +------------------------------------------------------+
  84. 2 rows in set (0.00 sec)
  86. mysql> exit
  87. Bye
  89. # 用新增用户登录
  90. # mysql -udnt -p
  91. [dnt@localhost ~]$ mysql -udnt -p
  92. Enter password:
  93. Welcome to the MySQL monitor.  Commands end with ; or \g.
  94. Your MySQL connection id is 39
  95. Server version: 8.0.16 MySQL Community Server - GPL
  97. Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
  99. Oracle is a registered trademark of Oracle Corporation and/or its
  100. affiliates. Other names may be trademarks of their respective
  101. owners.
  103. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  105. # show databases;
  106. mysql> show databases;
  107. +--------------------+
  108. | Database           |
  109. +--------------------+
  110. | dotnetcrazy        |
  111. | information_schema |
  112. +--------------------+
  113. 2 rows in set (0.01 sec)

4.配置附录

  1. [dnt@localhost ~]$ su
  2. 密码：
  3. [root@localhost dnt]# ls /etc/ | grep my
  4. my.cnf
  5. my.cnf.d
  6. [root@localhost dnt]# ls /etc/my.cnf.d/
  8. # 修改配置，运行远程登录
  9. [root@localhost dnt]# vi /etc/my.cnf
  10. [root@localhost dnt]# cat /etc/my.cnf
  11. [mysqld]
  12. bind-address=0.0.0.0 # 新增内容
  14. datadir=/var/lib/mysql
  15. socket=/var/lib/mysql/mysql.sock
  17. log-error=/var/log/mysqld.log
  18. pid-file=/var/run/mysqld/mysqld.pid
  20. # 查看一下防火墙状态
  21. # systemctl status firewalld
  22. [root@localhost dnt] systemctl status firewalld
  23. ● firewalld.service - firewalld - dynamic firewall daemon
  24.    Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
  25.    Active: active (running) since 三 2019-05-15 17:37:49 CST; 28min ago
  26.      Docs: man:firewalld(1)
  27.  Main PID: 3467 (firewalld)
  28.    CGroup: /system.slice/firewalld.service
  29.            └─3467 /usr/bin/python -Es /usr/sbin/firewalld --nofork --nopid
  31. 5月 15 17:37:47 localhost.localdomain systemd[1]: Starting firewalld - dynamic firewall daemon...
  32. 5月 15 17:37:49 localhost.localdomain systemd[1]: Started firewalld - dynamic firewall daemon.
  34. # 开放3306端口的远程访问权限
  35. # firewall-cmd --zone=public --add-port=3306/tcp --permanent
  36. [root@localhost dnt]# firewall-cmd --zone=public --add-port=3306/tcp --permanent
  37. success
  39. # 刷新防火墙规则
  40. # firewall-cmd --reload
  41. [root@localhost dnt]# firewall-cmd --reload
  42. success
  44. # 重启MySQL
  45. # systemctl restart mysqld
  46. [root@localhost dnt]# systemctl restart mysqld


下节预估：MySQL日志篇

mysql
文章转载自逸鹏说道，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

评论