How to install Mysql5.7.18 in Win7x64, win7x64mysql5.7.18

How to install Mysql5.7.18 in Win7x64, win7x64mysql5.7.18

Related reading:

Solve the problem that Windows x64 cannot be started when mysql 5.7.18 winx64 is installed and decompressed

1. Download the installation package Baidu cloud Link

2. decompress the package and place it in C: \ Program Files \ MySQL \ mysql5.7.18.

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

[Mysqld] # password-free logon 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 binfile directory. Otherwise, an error may be reported during startup.

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

Uninstall:

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

5. Because the unzipped 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 Initialization is not performed, the following error occurs during service startup:

MySQL service is starting.

The MySQL service cannot be started.

The Service did not report any errors.

6. Configure Environment Variables

Add the following 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 the password:

For the newly installed MySQL5.7, a Password error is prompted during logon. The password is not changed during installation. Then, you can change the password through password-free logon and enter update mysql. user set password = password ('root') where user = 'root' ERROR 1054 (42S22): Unknown column 'Password' in 'field list ', it turns out that there is no password field in the mysql database, and the password field is changed to authentication_string.

To change the password, follow these steps:

Mysql-u root-p enters 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 Mysql5.7.18 decompressed version under Win7x64 introduced by the small editor. I hope it will help you. If you have any questions, please leave a message and I will reply to you in time. Thank you very much for your support for the help House website!