阿里云CentOS7服务器下安装MySQL 8.0 (GA)

最新推荐文章于 2024-07-25 15:50:18 发布

不懂_if_else_

最新推荐文章于 2024-07-25 15:50:18 发布

阅读量7.5k

点赞数 6

分类专栏： linux 文章标签：阿里云l linux mysql 8.0 登陆报错解决

本文链接：https://blog.csdn.net/qq_32672633/article/details/80325470

版权

linux 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

阿里云服务器安装MySQL 8.0 (GA)

一. MySQL官方地址 MySQL Yum仓库的RPM安装包

这里写图片描述

通过wget方式获取yum包

wget http://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm

这里写图片描述

二. 安装MySQL RPM安装包

命令：

yum localinstall mysql80-community-release-el7-1.noarch.rpm

这里写图片描述

看到安装MySQL8.0安装完成后可到/etc/yum.repos.d/目录下看到：

mysql-community.repo
mysql-community-source.repo

两个文件,说明MySQL Yum仓库添加成功。

三. 安装MySQL

[root@*******0x2dru8ftg3uz yum.repos.d]# yum install mysql-community-server
Loaded plugins: fastestmirror
base                                                                                                              | 3.6 kB  00:00:00     
epel                                                                                                              | 4.7 kB  00:00:00     
extras                                                                                                            | 3.4 kB  00:00:00     
mysql-connectors-community                                                                                        | 2.5 kB  00:00:00     
mysql-tools-community                                                                                             | 2.5 kB  00:00:00     
mysql80-community                                                                                                 | 2.5 kB  00:00:00     
updates                                                                                                           | 3.4 kB  00:00:00     
(1/10): epel/x86_64/group_gz                                                                                      |  84 kB  00:00:00     
(2/10): base/7/x86_64/group_gz                                                                                    | 166 kB  00:00:00     
(3/10): epel/x86_64/updateinfo                                                                                    | 922 kB  00:00:00     
(4/10): extras/7/x86_64/primary_db                                                                                | 104 kB  00:00:00     
(5/10): base/7/x86_64/primary_db                                                                                  | 5.9 MB  00:00:00     
(6/10): epel/x86_64/primary_db                                                                                    | 6.4 MB  00:00:00     
(7/10): updates/7/x86_64/primary_db                                                                               | 1.0 MB  00:00:00     
(8/10): mysql80-community/x86_64/primary_db                                                                       |  16 kB  00:00:00     
(9/10): mysql-connectors-community/x86_64/primary_db                                                              |  20 kB  00:00:00     
(10/10): mysql-tools-community/x86_64/primary_db                                                                  |  41 kB  00:00:00     
Determining fastest mirrors
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:8.0.11-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 8.0.11-1.el7 for package: mysql-community-server-8.0.11-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.0 for package: mysql-community-server-8.0.11-1.el7.x86_64
--> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: mysql-community-server-8.0.11-1.el7.x86_64
--> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: mysql-community-server-8.0.11-1.el7.x86_64
--> Processing Dependency: libaio.so.1()(64bit) for package: mysql-community-server-8.0.11-1.el7.x86_64
--> Running transaction check
---> Package libaio.x86_64 0:0.3.109-13.el7 will be installed
---> Package mysql-community-client.x86_64 0:8.0.11-1.el7 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.0 for package: mysql-community-client-8.0.11-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:8.0.11-1.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.56-2.el7 will be obsoleted
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
---> Package mysql-community-libs.x86_64 0:8.0.11-1.el7 will be obsoleting
--> Running transaction check
---> Package mysql-community-libs-compat.x86_64 0:8.0.11-1.el7 will be obsoleting
--> Finished Dependency Resolution

Dependencies Resolved

=========================================================================================================================================
 Package                                    Arch                  Version                         Repository                        Size
=========================================================================================================================================
Installing:
 mysql-community-libs                       x86_64                8.0.11-1.el7                    mysql80-community                2.2 M
     replacing  mariadb-libs.x86_64 1:5.5.56-2.el7
 mysql-community-libs-compat                x86_64                8.0.11-1.el7                    mysql80-community                2.1 M
     replacing  mariadb-libs.x86_64 1:5.5.56-2.el7
 mysql-community-server                     x86_64                8.0.11-1.el7                    mysql80-community                341 M
Installing for dependencies:
 libaio                                     x86_64                0.3.109-13.el7                  base                              24 k
 mysql-community-client                     x86_64                8.0.11-1.el7                    mysql80-community                 26 M
 mysql-community-common                     x86_64                8.0.11-1.el7                    mysql80-community                537 k

Transaction Summary
=========================================================================================================================================
Install  3 Packages (+3 Dependent packages)

Total download size: 371 M
Is this ok [y/d/N]: y
Downloading packages:
(1/6): libaio-0.3.109-13.el7.x86_64.rpm                                                                           |  24 kB  00:00:00     
warning: /var/cache/yum/x86_64/7/mysql80-community/packages/mysql-community-common-8.0.11-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Public key for mysql-community-common-8.0.11-1.el7.x86_64.rpm is not installed
(2/6): mysql-community-common-8.0.11-1.el7.x86_64.rpm                                                             | 537 kB  00:00:00     
(3/6): mysql-community-libs-8.0.11-1.el7.x86_64.rpm                                                               | 2.2 MB  00:00:00     
(4/6): mysql-community-libs-compat-8.0.11-1.el7.x86_64.rpm                                                        | 2.1 MB  00:00:00     
(5/6): mysql-community-client-8.0.11-1.el7.x86_64.rpm                                                             |  26 MB  00:00:01     
(6/6): mysql-community-server-8.0.11-1.el7.x86_64.rpm                                                             | 341 MB  00:00:27     
-----------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                     13 MB/s | 371 MB  00:00:28     
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Importing GPG key 0x5072E1F5:
 Userid     : "MySQL Release Engineering <mysql-build@oss.oracle.com>"
 Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
 Package    : mysql80-community-release-el7-1.noarch (installed)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : mysql-community-common-8.0.11-1.el7.x86_64                                                                            1/7 
  Installing : mysql-community-libs-8.0.11-1.el7.x86_64                                                                              2/7 
  Installing : mysql-community-client-8.0.11-1.el7.x86_64                                                                            3/7 
  Installing : libaio-0.3.109-13.el7.x86_64                                                                                          4/7 
  Installing : mysql-community-server-8.0.11-1.el7.x86_64                                                                            5/7 
  Installing : mysql-community-libs-compat-8.0.11-1.el7.x86_64                                                                       6/7 
  Erasing    : 1:mariadb-libs-5.5.56-2.el7.x86_64                                                                                    7/7 
  Verifying  : mysql-community-server-8.0.11-1.el7.x86_64                                                                            1/7 
  Verifying  : mysql-community-client-8.0.11-1.el7.x86_64                                                                            2/7 
  Verifying  : mysql-community-libs-8.0.11-1.el7.x86_64                                                                              3/7 
  Verifying  : mysql-community-common-8.0.11-1.el7.x86_64                                                                            4/7 
  Verifying  : mysql-community-libs-compat-8.0.11-1.el7.x86_64                                                                       5/7 
  Verifying  : libaio-0.3.109-13.el7.x86_64                                                                                          6/7 
  Verifying  : 1:mariadb-libs-5.5.56-2.el7.x86_64                                                                                    7/7 

Installed:
  mysql-community-libs.x86_64 0:8.0.11-1.el7                       mysql-community-libs-compat.x86_64 0:8.0.11-1.el7                    
  mysql-community-server.x86_64 0:8.0.11-1.el7                    

Dependency Installed:
  libaio.x86_64 0:0.3.109-13.el7      mysql-community-client.x86_64 0:8.0.11-1.el7      mysql-community-common.x86_64 0:8.0.11-1.el7     

Replaced:
  mariadb-libs.x86_64 1:5.5.56-2.el7                                                                                                     

Complete!

完成之后数据库会有一个初始密码，可通过一下命令查看：

[root@*******2dru8ftg3uz log]# sudo grep 'temporary password' /var/log/mysqld.log

这里写图片描述

至此，MySQL8.0 安装完成，下面进行启动配置。

四、启动MySQL8.0

##启动MySQL服务
[root@**********2dru8ftg3uz log]# sudo service mysqld start
Redirecting to /bin/systemctl start mysqld.service
[root@**********2dru8ftg3uz log]# 
##查看MySQL进程
[root@******0x2dru8ftg3uz log]# ps -ef |grep mysql
mysql    10746     1  4 15:22 ?        00:00:00 /usr/sbin/mysqld
root     10791 10479  0 15:22 pts/0    00:00:00 grep --color=auto mysql
[root@*********dru8ftg3uz log]# service mysqld status
Redirecting to /bin/systemctl status mysqld.service
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Tue 2018-05-15 15:22:19 CST; 7min ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 10678 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 10746 (mysqld)
   Status: "SERVER_OPERATING"
   CGroup: /system.slice/mysqld.service
           └─10746 /usr/sbin/mysqld

May 15 15:22:09 **********2dru8ftg3uz systemd[1]: Starting MySQL Server...
May 15 15:22:19 **********2dru8ftg3uz systemd[1]: Started MySQL Server.
##停止MySQL服务：service mysqld stop

五、进行一些必要的配置

1、修改初始密码

##查看默认密码
shell> sudo grep 'temporary password' /var/log/mysqld.log
##使用默认密码登陆
shell> mysql -uroot -p
#MySQL8.0修改密码需要有大小写字母、数字、特殊字符组合
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

官方给出的密码修改说明：
这是官方

#默认情况下密码策略要求密码至少包含一个大写字母、一个小写字母、一个数字和一个特殊字符，并且总密码长度至少为8个字符。
否则回报出：ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

validate_password is installed by default. The default password policy implemented by validate_password requires that passwords contain at least one upper case letter, one lower case letter, one digit, and one special character, and that the total password length is at least 8 characters.

2、外网/客户端访问问题

客户访问报错:ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL

解决方案：
    服务端登陆MySQL，修改user表登陆用户的host。
shell>
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
| columns_priv              |
此处省略n个表
| time_zone_transition      |
| time_zone_transition_type |
| user                      |
+---------------------------+
33 rows in set (0.00 sec)

mysql> update user set host='%' where user='root';
Query OK, 1 row affected (0.07 sec)
Rows matched: 1  Changed: 1  Warnings: 0

这里写图片描述

客户端报错：2059 - authentication plugin 'caching_sha2_password' ...
这里写图片描述
解决方案：
执行sql：

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Your password';

另外阿里云的防火墙默认端口是不开放的，需要在控制台进行设置，不打开端口外网也是访问不到的。

终于大功告成。

6
点赞
踩
35

收藏

觉得还不错? 一键收藏
4
评论
阿里云CentOS7服务器下安装MySQL 8.0 (GA)

阿里云服务器安装MySQL 8.0 (GA)本教程为yum在线安装一. MySQL官方地址 MySQL Yum仓库的RPM安装包通过wget方式获取yum包wget http://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm二. 安装MySQL RPM安装包命令：yu...
复制链接

扫一扫

专栏目录