mysql 8.0.15升级_从mysql8.0.15升级到8.0.16

[root@db144 mysql_3306]# cd /opt/[root@db144 opt]# ll

total367488drwxr-xr-x. 9 root root 4096 Apr 10 00:00 mysql-8.0.15-linux-glibc2.12-x86_64-rw-r--r--. 1 root root 376303592 Apr 4 16:20 mysql-8.0.15-linux-glibc2.12-x86_64.tar.xz

[root@db144 opt]#wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.16-linux-glibc2.12-x86_64.tar.xz

# 解压安装包[root@db144 opt]# tar -xJf mysql-8.0.16-linux-glibc2.12-x86_64.tar.xz

# 停库

[root@db144 opt]# cd /usr/local/

[root@db144 local]# ll

total 40

drwxr-xr-x. 2 root root 4096 Sep 23 2011 bin

drwxr-xr-x. 2 root root 4096 Sep 23 2011 etc

drwxr-xr-x. 2 root root 4096 Sep 23 2011 games

drwxr-xr-x. 2 root root 4096 Sep 23 2011 include

drwxr-xr-x. 2 root root 4096 Sep 23 2011 lib

drwxr-xr-x. 2 root root 4096 Sep 23 2011 lib64

drwxr-xr-x. 2 root root 4096 Sep 23 2011 libexec

lrwxrwxrwx. 1 root root 40 Apr 10 00:15 mysql -> /opt/mysql-8.0.15-linux-glibc2.12-x86_64

drwxr-xr-x. 2 root root 4096 Sep 23 2011 sbin

drwxr-xr-x. 5 root root 4096 Mar 12 22:38 share

drwxr-xr-x. 2 root root 4096 Sep 23 2011 src

[root@db144 local]# mysql.3306.stop

[1] 9775

[root@db144 local]# mysqladmin: [Warning] Using a password on the command line interface can be insecure.

[1]+ Done /usr/local/mysql/bin/mysqladmin -h127.0.0.1 -P 3306 -uroot -p'AnvcTMagdLarwNV3CKaC' shutdown

[root@db144 local]#

[root@db144 local]# unlink mysql

# 备份数据目录

[root@db144 local]# cp -r /data/mysql/mysql_3306 /data/mysql/mysql_3306.bak

# 做软连接

[root@db144 local]# ln -s /opt/mysql-8.0.16-linux-glibc2.12-x86_64 /usr/local/mysql

[root@db144 local]# ll

total 40

drwxr-xr-x. 2 root root 4096 Sep 23 2011 bin

drwxr-xr-x. 2 root root 4096 Sep 23 2011 etc

drwxr-xr-x. 2 root root 4096 Sep 23 2011 games

drwxr-xr-x. 2 root root 4096 Sep 23 2011 include

drwxr-xr-x. 2 root root 4096 Sep 23 2011 lib

drwxr-xr-x. 2 root root 4096 Sep 23 2011 lib64

drwxr-xr-x. 2 root root 4096 Sep 23 2011 libexec

lrwxrwxrwx. 1 root root 40 May 5 18:21 mysql -> /opt/mysql-8.0.16-linux-glibc2.12-x86_64

drwxr-xr-x. 2 root root 4096 Sep 23 2011 sbin

drwxr-xr-x. 5 root root 4096 Mar 12 22:38 share

drwxr-xr-x. 2 root root 4096 Sep 23 2011 src

[root@db144 local]# chown -R mysql.mysql mysql

[root@db144 local]#

# 启动数据库

[root@db144 local]# mysql.3306.start

[1] 9801

[root@db144 local]# 2019-05-05T10:22:01.454070Z mysqld_safe Logging to '/data/mysql/mysql_3306/logs/error.log'.

2019-05-05T10:22:01.630984Z mysqld_safe Starting mysqld daemon with databases from /data/mysql/mysql_3306/data

# my.cnf中去掉这个参数  #internal_tmp_disk_storage_engine = InnoDB

[root@db144 local]# mysql_upgrade -s -uroot -p -h 127.0.0.1 -P 3306

Enter password:

The mysql_upgrade client is now deprecated. The actions executed by the upgrade client are now done by the server.

To upgrade, please start the new MySQL binary with the older data directory. Repairing user tables is done automatically. Restart is not required after upgrade.

The upgrade process automatically starts on running a new MySQL binary with an older data directory. To avoid accidental upgrades, please use the --upgrade=NONE option with the MySQL binary. The option --upgrade=FORCE is also provided to run the server upgrade sequence on demand.

It may be possible that the server upgrade fails due to a number of reasons. In that case, the upgrade sequence will run again during the next MySQL server start. If the server upgrade fails repeatedly, the server can be started with the --upgrade=MINIMAL option to start the server without executing the upgrade sequence, thus allowing users to manually rectify the problem.

[root@db144 local]#

# 经查证，现在已经不使用这个了，服务在启动时，自动帮你升级完毕了。

[root@db144 local]# mysql.3306.login

mysql: [Warning] Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 9

Server version: 8.0.16 MySQL Community Server - GPL

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> \s;

--------------

/usr/local/mysql/bin/mysql Ver 8.0.16 for linux-glibc2.12 on x86_64 (MySQL Community Server - GPL)

Connection id:9

Current database:

Current user:root@127.0.0.1

SSL:Cipher in use is DHE-RSA-AES128-GCM-SHA256

Current pager:stdout

Using outfile:''

Using delimiter:;

Server version:8.0.16 MySQL Community Server - GPL

Protocol version:10

Connection:127.0.0.1 via TCP/IP

Server characterset:utf8mb4

Db characterset:utf8mb4

Client characterset:utf8mb4

Conn. characterset:utf8mb4

TCP port:3306

Uptime:9 min 9 sec

Threads: 2 Questions: 8 Slow queries: 0 Opens: 1133 Flush tables: 3 Open tables: 16 Queries per second avg: 0.014

--------------

ERROR:

No query specified

mysql> exit

Bye

[root@db144 local]#