Detailed tutorial for upgrading MySQL5.7.17 installation-free version under Windows (x86, 64bit)

This article mainly introduces the Windows (x86, 64bit) upgrade MySQL 5.7.17 installation-free version detailed tutorial, friends in need can refer to it

MySQL needs to be upgraded to 5.5 .3 and above versions only support the default utf8mb64 character encoding of Laravel 5.4. Therefore, I upgraded MySQL. I still encountered some minor problems during the process. I recorded them for reference.

Upgrade preparation

1. Back up the data directory (database directory) under the MySql directory before.

2. Download the MySQL 5.7.17 version compressed package from the MySql official website.

3. Run the command line as administrator and enter the net stop mysql command to stop the mysql service.

4. Enter sc delete mysql command, delete mysql service.

5. Uninstall the current version of MySQL.

Start the upgrade

Decompress the MySQL 5.7.17 compressed package to the corresponding directory (example: E:\Software\mysql-5.7.17- winx64).

Configuration

Copy my-default.ini to the bin directory and name it my.ini (copying directly to the root directory sometimes causes an initialization error).

Add the following content to my.ini file:

[mysqld]
basedir = E:\Software\mysql-5.7.17-winx64
datadir = E:\Software\mysql-5.7.17-winx64\data
port = 3306
default-character-set = utf8
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
[WinMySQLadmin]
Server = E:\Software\mysql-5.7.17-winx64\bin\mysqld.exe
user = root
password =
[client]
default-character-set = utf8

Note: sql_mode=NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES should be placed above [WinMySQLadmin] and client, otherwise an error will be reported. And the above paths need to be changed to the decompression directory.

Installation service

1. Administrator identity command line, enter the bin directory, enter the mysqld --initialize command to initialize MySQL.

2. Enter the mysqld --install command to install the MySQL service.

3. Enter the net start msyql command to start the M SQL service.

4. Enter the mysql -h localhost -u root -p command to log in to MySQL.

At this time, you are required to enter a password. When MySQL 5.7.17 is initialized, a temporary password is created. After opening the err file named with the administrator name in the data directory, check the first Note. , the temporary password can be found.

2017-02-12T07:22:42.516404Z 1 [Note] A temporary password is generated for root@localhost: RqfpPhxhJ0%a

1. After entering MySQL, enter alter user 'root'@'localhost' identified by 'new password'; to set the password.

2. Enter flush privileges; refresh.

3. Enter quit; to exit, and then you can use the new password to log in to MySQL.

Import data

Open the previously backed up data directory, copy each database directory to the data directory of the new version of MySQL, and then you can use the previous data directory. database.

Note: It may be due to version issues that the data is incompatible and cannot be used. You need to check the official documentation for resolution.

The above is the detailed content of Detailed tutorial for upgrading MySQL5.7.17 installation-free version under Windows (x86, 64bit). For more information, please follow other related articles on the PHP Chinese website!