Shulou(Shulou.com)05/31 Report--

Editor to share with you how to upgrade the wdCP panel MySQL version 5.6, I believe that most people do not understand, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Before the installation of wdCP panel is mainly to build WordPress personal blog, and then go to the WordPress official website to take a look, found that the system requires PHP7.3 version and MySQL5.6 version or above.

So, immediately to upgrade the version of PHP (very convenient, no trouble), and then liver for a long time to complete the upgrade of the database (I believe you can see my twists and turns in this article). Finally, when the blogger took a screenshot on the official website of WordPress, he found a sentence, "but these are not necessary." Oh, the state of mind is broken.

Server environment

System: CentOS7.7

Panel: wdCP v3.3.9

WdCP built-in database: MySQL 5.5.62

MySQL upgrade steps

In order to reduce the possibility of error, it is best to enter the following command into the Linux terminal as a copy. Because the article has an original statement (shameless), you can copy the command to notepad and then to the terminal. In order to facilitate troubleshooting, I also copied some of the run results.

Because in the process, some commands have path problems, I don't know if I can write a .sh file and run it directly. Seeing that many blogs say yes, I am skeptical and do not recommend rookies like me to try.

1. Shut down the mysql service, back up the data, and put it into the new my.cnf Wget https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.44.tar.gztar-zxvf mysql-5.6.44.tar.gzcd mysql-5.6.44cmake-DCMAKE_INSTALL_PREFIX=/www/wdlinux/mysql-5.6.44-DMYSQL_DATADIR=/www/wdlinux/mysql-5.6.44/data-DDOWNLOAD_BOOST=1-DWITH_BOOST=boost/boost_1_59_0/-DSYSCONFDIR=/www/wdlinux/etc-DWITH_INNOBASE_STORAGE _ ENGINE=1-DWITH_PARTITION_STORAGE_ENGINE=1-DWITH_FEDERATED_STORAGE_ENGINE=1-DWITH_BLACKHOLE_STORAGE_ENGINE=1-DWITH_MYISAM_STORAGE_ENGINE=1-DWITH_EMBEDDED_SERVER=1-DENABLE_DTRACE=0-DENABLED_LOCAL_INFILE=1-DDEFAULT_CHARSET=utf8mb4-DDEFAULT_COLLATION=utf8mb4_general_ci-DEXTRA_CHARSETS=allmake & & make install

There are many commands in this step, so don't copy it out! At the same time, the waiting time will be long, so you need to be patient.

4. Modify the mysql folder hyperlink in wdcp * * rm-f / www/wdlinux/mysqlln-sf / www/wdlinux/mysql-5.6.44 / www/wdlinux/mysql

Note: if you have a problem with this step, you may have missed the make install copy in the previous step (don't ask, I stepped on it).

5. Initialize mysql and grant permissions

The command for this step is executed in the / www/wdlinux/mysql directory, so pay attention to the switch.

Scripts/mysql_install_db-- user=mysql-- basedir=/www/wdlinux/mysql-- datadir=/www/wdlinux/mysql/datachown-R mysql.mysql / www/wdlinux/mysql/data6, operational data restore * *

This is a crappy step, and the order had better be copied step by step! Because after the first line of the cp command (press y many times), you will be asked if you want to overwrite, so the commands you copy later are gone.

The cp command on lines 3 and 4 needs to be executed with the cd command to the / www/wdlinux/mysql-5.6.44 directory. I'm talking about my own directory, which you can adjust according to your own situation. (it's all my trample.)

Mv / www/wdlinux/mysql/data/mysql / www/wdlinux/mysql/data/mysql1cp-pR / www/wdlinux/mysql_bk/* / www/wdlinux/mysql/data/cp support-files/mysql.server / www/wdlinux/init.d/mysqldcp support-files/mysql.server / etc/init.d/mysqldchmod 755 / www/wdlinux/init.d/mysqldchmod 755 / etc/init.d/mysqld7, start mysql, and use mysql_upgrade to repair structural errors after mysql upgrade * *

If you report an error in the mysql_upgrade command in this step, there is a problem with the previous step, you can execute the command in step 6 again.

Service mysqld startmysql_upgrade-u root-p

The last time I saw this, I had tears in my eyes.

The above is all the contents of the article "how to upgrade the wdCP panel to MySQL version 5.6". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.