MYSQL升级5.5.31至5.5.37-优快云博客

本文详细介绍了如何从旧版本平滑升级至MySQL5.5.37，包括解压新软件、关闭数据库、更新链接文件、启动MySQL及运行升级程序等步骤，并验证了升级后的版本。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1. 解压新的软件：
tar -xzvf mysql-5.5.37-linux2.6-x86_64.tar.gz

2.关闭数据库：
/apps/sh/mysql5.sh stop

3. 删除/apps/svr/mysql5 链接文件，交将新的5.5.37解压文件链接到/APPS/SVR/MYSQL5
rm -rf mysql5
ln -s /apps/svr/mysql-5.5.37-linux2.6-x86_64 /apps/svr/mysql5

4. 启动MYSQL
/apps/sh/mysql5.sh start


5. 跑升级程序：
[apps@testmysql1 svr]$ /apps/svr/mysql5/bin/mysql_upgrade -uroot -p -S /tmp/mysql3306.sock 
Enter password: 
Looking for 'mysql' as: /apps/svr/mysql5/bin/mysql
Looking for 'mysqlcheck' as: /apps/svr/mysql5/bin/mysqlcheck
Running 'mysqlcheck' with connection arguments: '--socket=/tmp/mysql3306.sock' 
Running 'mysqlcheck' with connection arguments: '--socket=/tmp/mysql3306.sock' 
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
test.t                                             OK
Running 'mysql_fix_privilege_tables'...
OK

尝试连接，查询版本：
dba@localhost : (none) 13:39:24> select @@version;
+------------+
| @@version  |
+------------+
| 5.5.37-log |

转载于:https://www.cnblogs.com/o-to-s/articles/3778982.html