CentOS Liunx MySQL升级为MySQL8

MySQL 12/26 阅读 1099 views次 人气 0
摘要:

CentOS Liunx MySQL升级为MySQL8,CentOS Liunx MySQL升级为MySQL8,CentOS Liunx MySQL升级为MySQL8

卸载旧版本的MySQL:

yum remove mysql mysql-*


查看mysql组件:

rpm -qa | grep mysql


下载:https://repo.mysql.com/mysql80-community-release-el6.rpm

rpm -ivh mysql80-community-release-el6.rpm 

[root@localhost ~]# rpm -ivh mysql80-community-release-el6.rpm 
warning: mysql80-community-release-el6.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                ########################################### [100%]
   1:mysql80-community-relea########################################### [100%]


安装:yum install mysql-server

[root@localhost ~]# yum install mysql-server
Loaded plugins: fastestmirror, refresh-packagekit, security
Determining fastest mirrors
 * base: mirrors.aliyun.com
 * extras: mirrors.aliyun.com
 * updates: mirrors.aliyun.com
mysql80-community                                                                                                                                        | 2.5 kB     00:00     
mysql80-community/primary_db                                                                                                                             |  36 kB     00:00     
Setting up Install Process
Package mysql-server is obsoleted by mysql-community-server, trying to install mysql-community-server-8.0.13-1.el6.x86_64 instead
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:8.0.13-1.el6 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 8.0.13-1.el6 for package: mysql-community-server-8.0.13-1.el6.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.0 for package: mysql-community-server-8.0.13-1.el6.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:8.0.13-1.el6 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.0 for package: mysql-community-client-8.0.13-1.el6.x86_64
---> Package mysql-community-common.x86_64 0:8.0.13-1.el6 will be installed
--> Running transaction check
---> Package mysql-community-libs.x86_64 0:8.0.13-1.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================================================================================================================
 Package                                           Arch                              Version                                 Repository                                    Size
================================================================================================================================================================================
Installing:
 mysql-community-server                            x86_64                            8.0.13-1.el6                            mysql80-community                            425 M
Installing for dependencies:
 mysql-community-client                            x86_64                            8.0.13-1.el6                            mysql80-community                             28 M
 mysql-community-common                            x86_64                            8.0.13-1.el6                            mysql80-community                            673 k
 mysql-community-libs                              x86_64                            8.0.13-1.el6                            mysql80-community                            2.5 M

Transaction Summary
================================================================================================================================================================================
Install       4 Package(s)

Total download size: 456 M
Installed size: 1.8 G
Is this ok [y/N]: y
Downloading Packages:
(1/4): mysql-community-client-8.0.13-1.el6.x86_64.rpm                                                                                                    |  28 MB     00:15     
(2/4): mysql-community-common-8.0.13-1.el6.x86_64.rpm                                                                                                    | 673 kB     00:00     
(3/4): mysql-community-libs-8.0.13-1.el6.x86_64.rpm                                                                                                      | 2.5 MB     00:01     
(4/4): mysql-community-server-8.0.13-1.el6.x86_64.rpm                                                                                                    | 425 MB     06:11     
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                           1.2 MB/s | 456 MB     06:29     
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
  Installing : mysql-community-common-8.0.13-1.el6.x86_64                                                                                                                   1/4 
  Installing : mysql-community-libs-8.0.13-1.el6.x86_64                                                                                                                     2/4 
  Installing : mysql-community-client-8.0.13-1.el6.x86_64                                                                                                                   3/4 
  Installing : mysql-community-server-8.0.13-1.el6.x86_64                                                                                                                   4/4 
  Verifying  : mysql-community-server-8.0.13-1.el6.x86_64                                                                                                                   1/4 
  Verifying  : mysql-community-common-8.0.13-1.el6.x86_64                                                                                                                   2/4 
  Verifying  : mysql-community-libs-8.0.13-1.el6.x86_64                                                                                                                     3/4 
  Verifying  : mysql-community-client-8.0.13-1.el6.x86_64                                                                                                                   4/4 

Installed:
  mysql-community-server.x86_64 0:8.0.13-1.el6                                                                                                                                  

Dependency Installed:
  mysql-community-client.x86_64 0:8.0.13-1.el6               mysql-community-common.x86_64 0:8.0.13-1.el6               mysql-community-libs.x86_64 0:8.0.13-1.el6              

Complete!


检查是否安装成功: mysqladmin -V

[root@localhost ~]# mysqladmin -V
mysqladmin  Ver 8.0.13 for Linux on x86_64 (MySQL Community Server - GPL)


启动:

service mysqld start

service mysqld status

启动失败:

2018-12-26T00:32:10.962636Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.13) starting as process 10658
2018-12-26T00:32:11.107451Z 1 [ERROR] [MY-013090] [InnoDB] Unsupported redo log format (0). The redo log was created before MySQL 5.7.9
2018-12-26T00:32:11.107536Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2018-12-26T00:32:11.608776Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2018-12-26T00:32:11.609275Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2018-12-26T00:32:11.609337Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-12-26T00:32:11.610955Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.13)  MySQL Community Server - GPL.

清空:/var/lib/mysql


启动日志:

2018-12-26T00:35:52.497269Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.13) initializing of server in progress as process 10747
2018-12-26T00:35:55.780743Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: nyJKVtP=i5lh
2018-12-26T00:35:57.738825Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.13) initializing of server has completed
2018-12-26T00:36:00.106701Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.13) starting as process 11028
2018-12-26T00:36:00.866349Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2018-12-26T00:36:00.908009Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.13'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server - GPL.
2018-12-26T00:36:01.072640Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060

其中:nyJKVtP=i5lh 是初始化密码。


登录后

mysql> use mysql;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.


修改密码:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'L**D**!**4';

注意:

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

密码策略,符合一定的安全复杂度。

评论

表情

分享到: