MySQL 5.7.18 installation and configuration tutorial under Windows

This article shares the installation and configuration tutorial of MySQL 5.7.18 under Windows for your reference. The specific contents are as follows

Prepare:

Operating system: win7

Download the 64-bit zip version of MySQL from http://dev.mysql.com/downloads/mysql/

I downloaded the latest version of MySQL. After decompression, the directory is as follows:

As you can see in the figure above, MySQL 5.7.18 does not have a data directory. If there is no data directory, an error will be reported when starting after installation:

The correct installation steps are as follows:

1. Enter the DOS command line and run it as an administrator.

2. Enter the MySQL bin directory and enter mysqld –install to install MySQL

3. Enter the following command mysqld --initialize --user=root --console to initialize the MySQL database. After initialization, the default password generated by MySQL will be printed out. The default password is circled at the bottom.

After initialization, you can see that there is an additional data directory under the MySQL directory

4. Start the MySQL service: net start mysql

5. Use the default generated password to enter mysql

6. After entering mysql, you can change the default password (I changed the default password to root)

At this point, the MySQL environment under Windows has been installed.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.