Shulou(Shulou.com)06/01 Report--

This article records the detailed tutorials of mysql installation and shares them with you.

I. the choice of version

Before the installation of Mysql, now to sum up, it seems a little late, the background to change the system, now from the newly installed Mysql, feel a lot of pits, I come to step on the pit, you see the pit do not jump, so you can save some installation time, this twists and turns for two days, installed many versions, finally installed, and finally chose the latest version of mysql-installer-community-5.7.16.0.

In the past, I downloaded it from other software websites, but I think it is more reliable to download it from the official website.

Go to the official MySql website and go to the download interface. When you see this, select "MySQL Installer 5.7.16" instead of "MySQL Installer 8.0.0 dmr" and select the 385.2m version of "Windows (x86, 32-bit), MSI Installer".

Second, download

3. Normal installation

Create this folder and put the installation path in this file. (English name folder)

Fourth, installation process (stepped on the pit)

(1) No installation of the compressed package version, one error was solved, another error was solved, another one was solved, and finally the installed version was replaced.

1. Installation-free version has been installed before, but it always fails. System error 1067

2. Cannot start the local MySQL Service. The following figure pops up.

Pop-up window, system error 2: the system cannot find the specified file.

Solution:

In windows+R, type regedit, go to the registry, change the ImagePath path, and put the folder path you unzipped in the path.

3. When I start MySQL service again, this error pops up. Error 5: access denied.

(2) the installed version of Mysql install used

I chose MSI instead of ZIP Archive.

V. the true process of successful installation (mysql-installer-community-5.7.16.0)

1. Start-"double-click, and the following figure appears

2. Follow the following figure

3. You can choose the installation path and database path.

Click Yes

Click execute

Click install

After a while, this pops up

Continue install

Next

Execute

Wait for a while to install

4. Then come to the Installation step, that is, the installation step. The components you selected in the previous step will be installed here. As shown in the figure, click execute Excute, and then click Next next after all installation is completed.

5. Next is the product configuration, that is, the database configuration Product Configuration, and move on to the next step

6. There are two points to pay attention to in the configuration database, one is Config Type, developers can choose the Developtment Machine shown in the figure, and so can the server, followed by the port number. Mysql generally uses 3306 as the port. Of course, you can modify your own port, as long as it does not conflict with other applications.

7. Next, set the database password and repeat, this password is the password of the root user, Super Admin.

You can add a mysql User Accounts.

8. Proceed to the next step, which is the service name. The default is MySQL56, which is named in the cmd command or in the service. You can use the default to start and stop the mysql service by using net start mysql56 and net stop mysql56 in cmd.

You can change the name of the mysql server under windows.

If you want your database to be used as a remote database for the server, check this.

And then go back to this place.

Connect to the database

And then it appears, as shown below.

After running the above, the following appears:

13. Finally, install the application configuration. When the configuration is complete, the mysql installation is complete.

Sixth, the successful installation of this, in fact, this installation includes the visual tool workbench part of mysql.

Create a new database connection

Database test succeeded

Then click ok, and that's fine.

Then you can see the newly created database.

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.