1、查看当前需要升级的版本


2、停止当前运行mysql

3、下载需要更新的8.0.30版本
https://dev.mysql.com/downloads/mysql/

4、解压新版本的包
5、修改之前的文件名;mysql—>mysqlold
| mv /usr/local/mysql /usr/local/mysqlold |
| |
| [root;localhost ~] |
| [root;localhost ~] |
| [root;localhost ~] |
| [root;localhost ~] |
| [root;localhost ~] |
| State Recv-Q Send-Q Local Address:Port Peer Address:Port Process |
| LISTEN 0 128 0.0.0.0:22 0.0.0.0:* |
| LISTEN 0 128 [::]:22 [::]:* |
| LISTEN 0 70 *:33060 *:* |
| LISTEN 0 128 *:3306 *:* |
| |
| [root;localhost ~] |
| 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 10 |
| Server version: 8.0.30 MySQL Community Server - GPL |
| |
| Copyright (c) 2000, 2022, Oracle and/or its affiliates. |
| |
| 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> select version(); |
| ;-----------; |
| | version() | |
| ;-----------; |
| | 8.0.30 | |
| ;-----------; |
| 1 row in set (0.00 sec) |
| |
| //查看数据 |
| mysql> show databases; |
| ;--------------------; |
| | Database | |
| ;--------------------; |
| | information_schema | |
| | mysql | |
| | performance_schema | |
| | sys | |
| | yy | |
| ;--------------------; |
| 5 rows in set (0.00 sec) |
| |
| |
| |