How to upgrade the MySQL database version in PhpStudy integrated environment

Many people are wondering how to upgrade the mysql database version in phpstudy. There is no place to set it in phpstudy. This article will teach you how to upgrade it in phpstudyUpgrade the version of mysql.

The default version of the mysql database in the PhpStudy integrated environment is mysql5.5. The following is the method for PhpStudy to upgrade the database to mysql5.7:

#1: Back up the current database data and export the database file as a backup.

2: Back up the MySQL folder under PhpStudy in case the upgrade fails, and you can also use an older version of the database

3: Download MySQL5 .7. Unzip and place it in the MySQL folder under PhpStudy

Address: http://www.php.cn/xiazai/search?k=mysql

4: Copy a copy of my-default.ini, rename it my.ini, open my.ini and add:

basedir="E:/phpStudy/MySQL/"

datadir="E:/phpStudy/MySQL/data/"

These two addresses are changed to their corresponding mysql directory and database directory in phpstudy.

5: Then run cmd as an administrator, enter the MySQL directory, as shown in the figure to indicate success, execute as follows:

> mysqld --initialize

> mysqld -install

6: Just restart phpstudy.

The above is how to upgrade the MySQL database version in the PhpStudy integrated environment. For beginners, it does not matter whether the database version is upgraded or not. For more information, please go to PHP Chinese website Search~

Related recommendations:

Picture and text tutorial on the installation steps of PHPstudy in Windows environment

Mysql-phpstudy had an error when accessing the local website source code

After installing phpstudy, it was found that port 80 was occupied

The above is the detailed content of How to upgrade the MySQL database version in PhpStudy integrated environment. For more information, please follow other related articles on the PHP Chinese website!