Installation method of MySQL 5.7.18 decompressed version under Win7x64

Related reading:

Solve the problem that the service cannot be started when installing the decompressed version of mysql 5.7.18 winx64 on Win7 x64

1. Download the installation package Baidu Cloud link

2. After decompression, put it in C:\Program Files\MySQL\mysql5.7.18

3. Create my.ini in the folder with the following content:

 [mysqld]
 #Password-free login skip-grant-tables
 bind-address = 0.0.0.0
 port = 3306
 basedir=C:/Program Files/mysql/mysql5.7.18
 datadir=C:/Program Files/MySQL/mysql5.7.18/data
 max_connections=200

4. Installation:

Be sure to go to the bin file directory, otherwise an error may occur during startup.

 C:\Program Files\MySQL\mysql5.7.18\bin>mysqld -install

uninstall:

C:\Program Files\MySQL\mysql5.7.18\bin>mysqld -remove

5. Since the decompressed mysql does not have a data folder, we need to initialize it:

Command line input cmd

cd C:\Program Files\MySQL\mysql5.7.18\bin
 C:\Program Files\MySQL\mysql5.7.18\bin>mysqld -initialize

The data folder is automatically generated after running.

If it is not initialized, the following error will occur when the service is started:

The MySQL service is starting.

The MySQL service cannot be started.

The service did not report any errors.

6. Configure environment variables

Add after Path:

 ;C:\Program Files\MySQL\mysql5.7.18\bin

7. Start mysql:

net start mysql close mysql:

net stop mysql

View all services:

services.msc

8. Change password:

I have newly installed MySQL 5.7. When I log in, it prompts that the password is wrong. I did not change the password during installation. Later, I changed the password by logging in without password. When I enter update mysql.user set password=password('root') where user='root', it prompts ERROR 1054 (42S22): Unknown column 'password' in 'field list'. It turns out that there is no password field in the MySQL database. The password field has been changed to authentication_string.

To change your password, follow these steps:

mysql -u root -p to enter mysql
 use mysql;
 update mysql.user set authentication_string=password('root') where user='root';

Delete skip-grant-tables in step 3 and restart mysql

The above is the installation method of the decompressed version of Mysql5.7.18 under Win7x64 introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!