Detailed introduction to mysql5.7.17 winx64 installation and configuration tutorial (picture)

This article mainly introduces in detail the mysql 5.7.17 winx64 installation and configuration tutorial, which has certain reference value. Interested friends can refer to it

Today we have another Install the MySQL database on your computer once. Every time you reinstall the system, you have to reinstall the database, but every time you have to refer to Baidu's installation and configuration tutorial. So I decided to write a blog post to introduce the MySQL installation tutorial when I have nothing to do. This is my first time writing a blog post. I hope you can forgive me if I have any mistakes!

Let’s start with my installation introduction:

My computer is win764, so this blog post also introduces the 64-bit installation.

1. So the first step is to download Windows (x86, 64-bit), ZIP Archive

2. Download After completion, unzip it to the path you want to install . For example, I unzipped it to the path D:\MySQL\mysql-5.7.17-winx64. After unzipping, it should be the following folders:

3. This step is to start the configuration . If your file suffix is ​​not displayed, it is recommended that you set your own file suffix display. , because we need to use when adding config file: Steps to set file suffix display: win7 selects double-click "Computer" -> click "Organization" under the navigation bar -> select "Folder" and search options" -> Click "View" -> Uncheck "Hide extensions for known file types".

4.Create a new my.ini configuration file. This configuration file will overwrite the my-default.ini file in the current folder. , setting the display file suffix in the previous step is to prepare for this step. Open this configuration file and add the following code to the file:

Among them, we want Create a new empty folder of data in our installation directory:

5. The preliminary preparations have been made, and then we will start installing the service as an administrator. Run cmd.exe, remember to run it as an administrator, enter the installation bin directory, the most important and important command is here, it is essential, otherwise the service cannot be started after the service is installed, enter mysqld --initialize -insecure --user=mysql command, then press Enter,

6. Then enter mysqld install to install the service. If the installation is successful, it will prompt that the installation is successful, and then start MySQL The service is OK,

7. Configure environment variables——>Right-click the computer and "Properties"——>"Advanced System Settings"——> "Environment variable" -> "path" -> Copy the path of the bin directory to the path environment variable. It is best to copy it to the front, and then add a semicolon after it. 8. Open MySQL, open cmd.exe, enter the mysql -uroot -p command, there is no password by default, press Enter to enter. If some have already set a password, you need to enter the password to enter. If you have a password, you can use mysql -uroot -p password, or mysql -uroot -p and press Enter to enter the password. The second option is recommended.

Now you’re done! Enter exit to exit mysql.

The above is the detailed content of Detailed introduction to mysql5.7.17 winx64 installation and configuration tutorial (picture). For more information, please follow other related articles on the PHP Chinese website!