mysql_upgrade 升级_采用MySQL_upgrade升级授权表方式升级

[[email protected] MySQL]# /usr/local/MySQL/bin/MySQL_upgrade

Looking for ‘MySQL‘ as: bin/MySQL

Looking for ‘MySQLcheck‘ as: bin/MySQLcheck

Running ‘MySQLcheck‘ with connection arguments: ‘--port=3306‘ ‘--socket=/tmp/MySQL.sock‘

Running ‘MySQLcheck‘ with connection arguments: ‘--port=3306‘ ‘--socket=/tmp/MySQL.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.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.heartbeat                                     OK

test.log20111127                                   OK

test.log20111128                                   OK

test.log20111129                                   OK

test.log20111130                                   OK

test.log20111201                                   OK

test.log20111202                                   OK

test.log20111203                                   OK

test.log20111204                                   OK

test.log20111205                                   OK

test.log20111206                                   OK

test.log20111207                                   OK

test.t1                                                       OK

test.t2                                                       OK

Running ‘MySQL_fix_privilege_tables‘...

OK

.7.1　采用MySQL_upgrade升级授权表方式升级(2)

6)再次关闭MySQL服务，命令如下：

/etc/init.d/MySQL stop或MySQLadmin -uroot -p123456 shutdown

7)正常启动MySQL服务，命令如下：

MySQLd_safe  --defaults-file=/etc/my.cnf --user=MySQL &

8)来查看一下版本，如下所示：

MySQL> select version();

+-----------------------------------------------------------+

| version()                                                                |

+-----------------------------------------------------------+

| 5.5.20-enterprise-commercial-advanced-log |

+-----------------------------------------------------------+

1 row in set (0.00 sec)

MySQL> select @@innodb_version;

+----------------------------+

| @@innodb_version |

+----------------------------+

| 1.1.8                            |

+----------------------------+

1 row in set (0.00 sec)

至此，升级过程完毕。

在升级过程中，有一个需要注意的问题，这是作者之前在安装时遇到的。RHEL5.3安装MySQL5.5时出现系统崩溃(如图1-24所示)，当时的环境为：系统是RHEL5.3，64位，XFS分区，MySQL5.5.20二进制版本。

系统崩溃时，作者用DELLDRAC远程管理卡抓的截屏如图1-25所示。

可以看出，XFS文件系统在读写时出现报错。出现此问题的原因是，RHEL5.3系统内核未自带XFS文件系统，是通过往内核打补丁使之支持的，后来把系统升级为RHEL5.5，系统正常了，没有出现死机情况。

注意

RHEL5.5版本开始，内核支持XFS文件系统。