How to upgrade MySQL version to 5.7.17 in phpStudy

This article mainly introduces you to the method and 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 can follow Let’s take a look together. Hope it helps everyone.

Preface

I found an error at work today. When importing the data table locally, I always reported an error:

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

The data table field where the error was reported:

`字段名` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP

A colleague 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. Extract the downloaded MySQL compressed file to the MySQL directory under phpStudy, and copy my-default. ini, renamed 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 the mySQL version at this time:

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

Summary

Reference:

phpStudy upgrade MySQL tutorial

mysql5.7 Installation method (different from the old one)

Solution to mysql forgetting root password in windows environment

How to modify the root password of MySQL 5.7.9 version and some new changes

Related recommendations:

How to upgrade the MySQL database version in the PhpStudy integrated environment

How to quickly upgrade the MySQL system table

Explain in detail how to safely upgrade MySQL_MySQL

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