Steps to upgrade MySQL version to 5.7.17 in phpStudy

This article mainly introduces you to the steps of upgrading the MySQL version to 5.7.17 in phpStudy. The article introduces it in detail through the example code. It has certain reference learning value for everyone's study or work. Friends who need it Let’s take a look together below.

Preface

I found an error at work today. When importing data tables locally, I always get an error:

[Err] 1294 - Invalid ON UPDATE clause for '字段名' column

Error data table fields:

`字段名` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP

Colleagues said that he could successfully import the same sql file. I guess it may be a problem with the database version. My colleague's version is 5.6. I checked the local database version and it is 5.5.53. After checking online, it turned out to be a version problem. 5.5 and 5.6 have different behaviors of TIMESTEMP. Versions before 5.6.5 do not support multiple CURRENT_TIMESTAMP default values.

Since the local integrated environment is phpStudy 2016, there is no option to upgrade the MySQL version, so I upgraded it myself.

Download the higher version of MySQL from the official website:

Official website: https://dev.mysql.com/downloads/file/?id=467269

Baidu Cloud Disk address: https://pan.baidu.com/s/1mi4UHtA

The selected version is 5.7.17 (later I discovered that the installation, system table fields, etc. of version 5.7 are different from the previous version) ).

Steps:

1. Back up the original MySQL installation directory in phpStudy

2. Unzip the downloaded MySQL compressed file Go to the MySQL directory under phpStudy, copy my-default.ini, and rename it to my.ini.

Open my.ini, find #basedir and edit:

basedir=D:/phpStudy/MySQL
datadir=D:/phpStudy/MySQL/data

3. Add the MySQL installation path to the system environment variable

4. Enter the MySQL bin under cmd Directory (mine is D:/phpStudy/MySQL/bin), execute:

mysqld --initialize

Initialize database

5. Install service:

mysqld -install

Start service:

net start MySQL

6. Log in to MySQL at this time and an error message is reported:

C:\Users\dell>mysql -uroot -p
Enter password: ****
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Try to change the root user password:

Open my.ini, find [mysqld], and add below:

skip-grant-tables

At this time, use the root account and press Enter in the password field to log in.

Change password:

mysql>update mysql.user set authentication_string=password('new_password') where user='root' and Host ='localhost'
mysql> ALTER USER USER() IDENTIFIED BY 'news_password';

Refresh permissions:

FLUSH PRIVILEGES;

Comment out the

skip-grant-tables

just added in my.ini and log in again.

Check mySQL version at this time:

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.7.17  |
+-----------+

The above is the detailed content of Steps to upgrade MySQL version to 5.7.17 in phpStudy. For more information, please follow other related articles on the PHP Chinese website!