MYSQL升级5.5.31至5.5.37

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 |

  

posted @ 2014-06-09 23:04 SMALL-D 阅读(...) 评论(...)  编辑 收藏