第一步:

bin/mysqld_safe --defaults-file=/data/percona-mysql/my.cnf --skip-grant-tables &


第二步:执行更新程序 

bin/mysql_upgrade -S /data/percona-mysql/mysql_3309.sock

Looking for 'mysql' as: bin/mysql

Looking for 'mysqlcheck' as: bin/mysqlcheck

Running 'mysqlcheck' with connection arguments: '--socket=/data/percona-mysql/mysql_3309.sock' 

Running 'mysqlcheck' with connection arguments: '--socket=/data/percona-mysql/mysql_3309.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

Running 'mysql_fix_privilege_tables'...

Running 'mysqlcheck' with connection arguments: '--socket=/data/percona-mysql/mysql_3309.sock' 

Running 'mysqlcheck' with connection arguments: '--socket=/data/percona-mysql/mysql_3309.sock' 

settlement.ZJS_TEMP                                OK

settlement.mytest                                  OK

settlement.t_assessment_files                      OK

settlement.t_assessment_rule                       OK

settlement.t_audit_note_file_details               OK

settlement.t_cm_group_base_files                   OK

settlement.t_cm_group_base_settle_data             OK

settlement.t_cm_group_bill_record                  OK

settlement.t_cm_group_bill_record_p                OK

settlement.t_cm_group_bill_settle                  OK

settlement.t_cm_group_budget_data                  OK

settlement.t_cm_group_budget_files                 OK

settlement.t_cm_group_income_maintain              OK

settlement.t_cm_group_settle_track                 OK

settlement.t_cm_supplemental_base_files            OK

settlement.t_cm_supplemental_base_settle_data      OK

settlement.t_cm_supplemental_bill_record           OK

settlement.t_cm_supplemental_bill_record_p         OK

settlement.t_cm_supplemental_bill_settle           OK

settlement.t_coop_assessment                       OK

settlement.t_coop_message                          OK

settlement.t_cooperate                             OK

settlement.t_cooperate_bak                         OK

settlement.t_cooperate_his                         OK

settlement.t_esmt_settlement_bill                  OK

settlement.t_esmt_settlement_bill_20110801         OK

settlement.t_esmt_settlement_bill_20111214         OK

settlement.t_esmt_settlement_bill_bk_20100521      OK

settlement.t_esmt_settlement_bill_record           OK

settlement.t_esmt_settlement_bill_record_20111214  OK

settlement.t_esmt_settlement_log                   OK

settlement.t_esmt_settlement_log_detail            OK

settlement.t_esmt_settlement_log_detail_20111214   OK

settlement.t_esmt_settlement_tune_detail           OK

settlement.t_esmt_settlement_tune_detail_20111214  OK

settlement.t_log_history                           OK

settlement.t_message                               OK

settlement.t_mobile_area                           OK

settlement.t_note_file_details                     OK

settlement.t_note_files                            OK

settlement.t_oper_type                             OK

settlement.t_product_div_per                       OK

settlement.t_product_div_per_20110715              OK

settlement.t_product_div_per_20111217              OK

settlement.t_product_div_per_20120509              OK

settlement.t_product_div_per_20130821              OK

settlement.t_product_div_per_BK20131105            OK

settlement.t_product_div_per_appdx                 OK

settlement.t_product_div_per_copy                  OK

settlement.t_product_div_per_hand                  OK

settlement.t_product_div_per_his                   OK

settlement.t_product_div_per_his_20120509          OK

settlement.t_products                              OK

settlement.t_products_his                          OK

settlement.t_quarterly_settlement                  OK

settlement.t_sply_settlement_bill                  OK

settlement.t_sply_settlement_bill_record           OK

settlement.t_sply_settlement_log                   OK

settlement.t_sply_settlement_log_detail            OK

settlement.t_system_per                            OK

settlement.t_tax_percent                           OK

settlement.tmp_t_esmt_settlement_bill              OK

OK


第三步:

bin/mysqladmin -S /data/percona-mysql/mysql_3309.sock shutdown


第四步:

bin/mysqld_safe --defaults-file=/data/percona-mysql/my.cnf &


mysql> select version();

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

| version()  |

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

| 5.6.19-log |

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

1 row in set (0.00 sec)


mysql> select @@innodb_version;

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

| @@innodb_version |

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

| 5.6.19           |

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

1 row in set (0.00 sec)


至此,升级过程完毕。