WDCP控制面板升級(jí)mysql為5.7.11的方法

1、下載解壓

我們提供的服務(wù)有：網(wǎng)站建設(shè)、做網(wǎng)站、微信公眾號(hào)開(kāi)發(fā)、網(wǎng)站優(yōu)化、網(wǎng)站認(rèn)證、婺源ssl等。為成百上千企事業(yè)單位解決了網(wǎng)站和推廣的問(wèn)題。提供周到的售前咨詢和貼心的售后服務(wù)，是有科學(xué)管理、有技術(shù)的婺源網(wǎng)站制作公司

下載地址為：http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.12-linux-glibc2.5-x86_64.tar.gz

tar -xvf mysql-5.7.11-linux-glibc2.5-x86_64.tar
得到mysql-5.7.11-linux-glibc2.5-x86_64.tar.gz mysql-test-5.7.11-linux-glibc2.5-x86_64.tar.gz
tar -zxvf mysql-5.7.11-linux-glibc2.5-x86_64.tar.gz
tar -zxvf mysql-test-5.7.11-linux-glibc2.5-x86_64.tar.gz
------------------------

2、備份
mysqldump -uroot -p"Bgichina1&test" db_wegram > db_wegram_test.dump
mysqldump -uroot -p"Bgichina1&test" wdcpdb > wdcpdb_test.dump

-------------------------------------------
ps -ax | grep mysql
warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.8/FAQ
620 pts/0 D+ 0:00 grep mysql
1066 ? S 0:00 /bin/sh /www/wdlinux/mysql-5.1.69/bin/mysqld_safe --datadir=/www/wdlinux/mysql-5.1.69/var --pid-file=/www/wdlinux/mysql-5.1.69/var/10-4-35-234.pid
1254 ? Sl 10:46 /www/wdlinux/mysql-5.1.69/libexec/mysqld --basedir=/www/wdlinux/mysql-5.1.69 --datadir=/www/wdlinux/mysql-5.1.69/var --user=mysql --log-error=/www/wdlinux/mysql-5.1.69/var/10-4-35-234.err --pid-file=/www/wdlinux/mysql-5.1.69/var/10-4-35-234.pid --socket=/tmp/mysql.sock --port=3306
---------------------------------------------------------------
mv mysql-5.7.11 /www/wdlinux/
關(guān)閉數(shù)據(jù)庫(kù)
cd /www/wdlinux
cd init.d
[root@10-4-35-234 init.d]# ./mysqld stop
Shutting down MySQL. SUCCESS!

mysql_upgrade -uroot -p"Bgichina1&test"
cp mysqld mysqld~

cd /www/wdlinux/etc
cp my.cnf my~.cnf

cd /www/wdlinux/
mv mysql mysql~

cd mysql-5.7.11
mkdir var
chown -R mysql var
-----------------------------------
軟連接
ln -s mysql-5.7.11 mysql

編輯/www/wdlinux/etc/my.cnf

[mysqld]

#-----------------------------------
#added by musictom
early-plugin-load=""
datadir=/www/wdlinux/mysql-5.7.11/var
basedir=/www/wdlinux/mysql-5.7.11
user=root

character-set-server=utf8mb4

collation_server=utf8mb4_unicode_ci

character-set-client-handshake = FALSE

init_connect='SET NAMES utf8mb4'

#
#-----------------------------------
注釋thread_concurrency
#thread_concurrency = 8

------------------------------------

[mysql]

#-------------------------------

#added by musictom

default-character-set = utf8mb4

#-------------------------------

初始化數(shù)據(jù)庫(kù)
mysqld --basedir=/www/wdlinux/mysql-5.7.11 --user=mysql --datadir=/www/wdlinux/mysql-5.7.11/var --initialize
生成的root初始密碼為"IWse#l?eh6#1"

[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-04-13T02:46:02.891041Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-04-13T02:46:03.137034Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-04-13T02:46:03.201517Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: dcd726b9-0121-11e6-9763-525400b32df6.
2016-04-13T02:46:03.202687Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-04-13T02:46:03.203686Z 1 [Note] A temporary password is generated for root@localhost: IWse#l?eh6#1

--------------------------------------
啟動(dòng)數(shù)據(jù)庫(kù)
cd /www/wdlinux/init.d
./mysqld start
Starting MySQL. SUCCESS!

---------------------------------------
修改root密碼
mysqladmin -u root -p"IWse#l?eh6#1" password "Bgichina1&test"

mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.
---------------------------------------
還原數(shù)據(jù)庫(kù)
mysql -uroot -p"Bgichina1&test"
create database db_wegram;
create database wdcpdb;

mysql -uroot -p"Bgichina1&test" db_wegram < db_wegram_test.dump
mysql -uroot -p"Bgichina1&test" wdcpdb < wdcpdb_test.dump

-----------------------------------------
修改表的charset
alter table chat_message CHARSET=utf8mb4;
alter table chat_message CHANGE content content VARCHAR(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

-----------------------------------------
解決“無(wú)法連接mysql，請(qǐng)檢查mysql是否已啟動(dòng)及用戶密碼是否設(shè)置正確!:”的問(wèn)題
在phpmyadmin里添加用戶wdcp@localhost
點(diǎn)擊localhost>>wdcpdb>>點(diǎn)右側(cè)的人行圖標(biāo)，提示“檢查數(shù)據(jù)庫(kù)wdcpdb的權(quán)限”
點(diǎn)下方的“添加新用戶”按鈕
密碼輸入abcd1234
用戶數(shù)據(jù)庫(kù)的選項(xiàng)選擇“授予數(shù)據(jù)庫(kù)“wdcpdb”的所有權(quán)限。”，然后保存
密碼還可以修改的

然后cd /www/wdlinux/wdcp/data
vim db.inc.php
$dbuser='wdcp';
$dbpw='abcd1234';
保存就可以了,注意如果注釋行的話用//而不是#，不然有可能會(huì)讓wdcp面板出現(xiàn)白板

當(dāng)前名稱：WDCP控制面板升級(jí)mysql為5.7.11的方法
鏈接地址：http://www.muchs.cn/article24/csoje.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供品牌網(wǎng)站設(shè)計(jì)、網(wǎng)站建設(shè)、標(biāo)簽優(yōu)化、網(wǎng)站維護(hù)、手機(jī)網(wǎng)站建設(shè)、App開(kāi)發(fā)

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

猜你還喜歡下面的內(nèi)容