建站
咨詢
售后
建站咨詢
新聞中心
這里有您想知道的互聯(lián)網(wǎng)營銷解決方案
mysql5.6怎么升級到mysql5.7
MySQL5.6怎么升級到mysql5.7，相信很多沒有經(jīng)驗的人對此束手無策，為此本文總結(jié)了問題出現(xiàn)的原因和解決方法，通過這篇文章希望你能解決這個問題。
西安網(wǎng)站建設(shè)公司創(chuàng)新互聯(lián)建站,西安網(wǎng)站設(shè)計制作，有大型網(wǎng)站制作公司豐富經(jīng)驗。已為西安上千提供企業(yè)網(wǎng)站建設(shè)服務(wù)。企業(yè)網(wǎng)站搭建\外貿(mào)網(wǎng)站建設(shè)要多少錢，請找那個售后服務(wù)好的西安做網(wǎng)站的公司定做！
1、停止mysql5.6數(shù)據(jù)庫服務(wù)
[root@host2 mysql]# /etc/init.d/mysqld stop Shutting down MySQL.. [ OK ] [root@host2 mysql]#
2、進(jìn)入/usr/local更換軟連接指定到mysql5.7
[root@host2 local]# ls bin games lib libexec mysql mysql-5.7.16-linux-glibc2.5-x86_64 mysql-utilities-1.6.5.tar.gz share etc include lib64 my.cnf mysql-5.6.34-linux-glibc2.5-x86_64 mysql-utilities-1.6.5 sbin src [root@host2 local]# unlink mysql
創(chuàng)建新的鏈接
[root@host2 local]# ln -s mysql-5.7.16-linux-glibc2.5-x86_64 mysql [root@host2 local]# ll total 712 drwxr-xr-x. 2 root root 4096 Jun 28 2011 bin drwxr-xr-x. 2 root root 4096 Jun 28 2011 etc drwxr-xr-x. 2 root root 4096 Jun 28 2011 games drwxr-xr-x. 2 root root 4096 Jun 28 2011 include drwxr-xr-x. 2 root root 4096 Jun 28 2011 lib drwxr-xr-x. 2 root root 4096 Jun 28 2011 lib64 drwxr-xr-x. 2 root root 4096 Jun 28 2011 libexec -rw-r--r--. 1 root root 2754 Nov 6 15:44 my.cnf lrwxrwxrwx. 1 root root 34 Mar 8 15:34 mysql -> mysql-5.7.16-linux-glibc2.5-x86_64 drwxr-xr-x. 12 mysql mysql 4096 Feb 27 18:33 mysql-5.6.34-linux-glibc2.5-x86_64 drwxr-xr-x. 11 root mysql 4096 Nov 19 00:01 mysql-5.7.16-linux-glibc2.5-x86_64 drwxr-xr-x. 7 7161 31415 4096 Feb 28 02:00 mysql-utilities-1.6.5 -rw-r--r--. 1 root root 668241 Feb 28 01:59 mysql-utilities-1.6.5.tar.gz drwxr-xr-x. 2 root root 4096 Jun 28 2011 sbin drwxr-xr-x. 5 root root 4096 Nov 6 22:15 share drwxr-xr-x. 2 root root 4096 Jun 28 2011 src
3、啟動數(shù)據(jù)庫并進(jìn)入數(shù)據(jù)庫
[root@host2 local]# /etc/init.d/mysqld start Starting MySQL.............................................[ OK ].............................. [root@host2 local]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.16-log MySQL Community Server (GPL)
（可以看到數(shù)據(jù)庫已經(jīng)到5.7版本了）
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
4、更新數(shù)據(jù)結(jié)構(gòu)（生產(chǎn)環(huán)境使用mysql_upgrade更新的時候加-s參數(shù) 不重建表）
[root@host2 local]# mysql_upgrade -p123 -s mysql_upgrade: [Warning] Using a password on the command line interface can be insecure. The --upgrade-system-tables option was used, databases won't be touched. Checking if update is needed. Checking server version. Running queries to upgrade MySQL server. Upgrading the sys schema. Upgrade process completed successfully. Checking if update is needed.
至此升級成功
5、進(jìn)入數(shù)據(jù)庫查看
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | | test | +--------------------+ 可以看到sys庫已經(jīng)存在，但是直接安裝的5.7的庫是沒有test庫的，這里sys和test同時存在說明是從5.6升級到5.7
看完上述內(nèi)容，你們掌握mysql5.6怎么升級到mysql5.7的方法了嗎？如果還想學(xué)到更多技能或想了解更多相關(guān)內(nèi)容，歡迎關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道，感謝各位的閱讀！
分享標(biāo)題：mysql5.6怎么升級到mysql5.7
網(wǎng)頁網(wǎng)址：http://fisionsoft.com.cn/article/gcpeic.html
