mysq

創(chuàng)新互聯(lián)是一家集網(wǎng)站建設,內(nèi)江企業(yè)網(wǎng)站建設,內(nèi)江品牌網(wǎng)站建設,網(wǎng)站定制,內(nèi)江網(wǎng)站建設報價,網(wǎng)絡營銷,網(wǎng)絡優(yōu)化,內(nèi)江網(wǎng)站推廣為一體的創(chuàng)新建站企業(yè)，幫助傳統(tǒng)企業(yè)提升企業(yè)形象加強企業(yè)競爭力。可充分滿足這一群體相比中小企業(yè)更為豐富、高端、多元的互聯(lián)網(wǎng)需求。同時我們時刻保持專業(yè)、時尚、前沿，時刻以成就客戶成長自我，堅持不斷學習、思考、沉淀、凈化自己，讓我們?yōu)楦嗟钠髽I(yè)打造出實用型網(wǎng)站。l升級是經(jīng)常要做的工作，整理下升級步驟（物理升級）
1，關閉mysql服務
2，高版本軟件覆蓋低版本軟件（替換掉basedir）
3，賦予新的高版本軟件mysql權(quán)限
4，使用新的軟件開啟數(shù)據(jù)庫
5，執(zhí)行mysql_upgrade升級
實驗：
5.6.23升級到5.7.12
1，關閉正在運行的mysql5.6.23的服務
2，刪除低版本的mysql軟件（basedir）
[root@mysqlupgrade mysql]# rm -rf mysql/
3，解壓高版本的mysql軟件包，覆蓋到原來的位置
[root@mysqlupgrade soft]# tar xzvf mysql-5.7.12-linux-glibc2.5-x86_64.tar.gz -C /data/mysql/
[root@mysqlupgrade mysql]# mv mysql-5.7.12-linux-glibc2.5-x86_64 mysql
4，賦予權(quán)限
[root@mysqlupgrade mysql]# chown -R mysql:mysql mysql/
5，開啟數(shù)據(jù)庫
[root@mysqlupgrade mysql]# bin/mysqld_safe --ledir=/data/mysql/mysql/bin --user=mysql &
6，進入數(shù)據(jù)庫，查看當前版本
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.7.12    |
+-----------+
1 row in set (0.00 sec)
6，mysql_upgrade升級
[root@mysqlupgrade mysql]# bin/mysql_upgrade  -udbauser -p123456 -h292.168.56.99 -P3306
mysql_upgrade: [Warning] Using a password on the command line interface can be insecure.
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
Checking system database.
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.engine_cost                                  OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.gtid_executed                                OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.server_cost                                  OK
mysql.servers                                      OK
mysql.slave_master_info                            OK
mysql.slave_relay_log_info                         OK
mysql.slave_worker_info                            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
Upgrading the sys schema.
Checking databases.
sys.sys_config                                     OK
Upgrade process completed successfully.
Checking if update is needed.
[root@mysqlupgrade mysql]#
備注：
升級的時候報錯
[root@mysqlupgrade mysql]# /data/mysql/mysql/bin/mysql_upgrade -udbauser -p123456
Warning: Using a password on the command line interface can be insecure.
Looking for 'mysql' as: /data/mysql/mysql/bin/mysql
Looking for 'mysqlcheck' as: /data/mysql/mysql/bin/mysqlcheck
Error: Failed while fetching Server version! Could be due to unauthorized access.
FATAL ERROR: Upgrade failed
mysql -udbauser -p123abc456 -h292.168.56.99 -P3306
測試下這樣 是否可以連上，必須要能連上才可以。

當前名稱：mysql升級（物理升級）-創(chuàng)新互聯(lián)
標題來源：http://chinadenli.net/article12/cephgc.html

成都網(wǎng)站建設公司_創(chuàng)新互聯(lián)，為您提供品牌網(wǎng)站設計、網(wǎng)站內(nèi)鏈、網(wǎng)站營銷、網(wǎng)站改版、全網(wǎng)營銷推廣、App設計

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)