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

This article mainly introduces the details of mysql download and installation steps, has a certain reference value, friends in need can refer to. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

This article explains in detail the download and installation of mysql tutorial, with the download address, as well as the environment configuration of MySQL, each step has a detailed introduction, for your reference, I hope it will be helpful to you. (mysql Free Learning Video recommendation: mysql tutorial)

1. Download MySQL (take MySQL5.7 version as an example)

Download URL: https://dev.mysql.com/downloads/mysql/5.7.html#downloads

Generally download MySQL 32-bit binary package, 64-bit version of the general installation will report "mysql service cannot start 3534" error

If you download a 64-bit binary installation package and report similar errors such as "mysql service cannot start 3534", please solve the problem by yourself.

This article takes the installation of a 32-bit MySQL binary package as an example, as shown in the following figure:

To download another version of MySQL, the download URL is as follows, as shown in the following figure:

Https://dev.mysql.com/downloads/mysql/

2. Environment configuration of MySQL

Extract the downloaded MySQL binary package to where you think it is appropriate, and then right-click "my computer-- Properties-- Advanced system Settings."

-- Environment variables enter the environment variables interface, as shown in the following figure:

Then add the extracted MySQL file with the path of the bin directory to the path variable

As shown in the following figure:

3. Configuration verification and installation of MySQL

Open the dos command window in the way the administrator runs fang, and type mysql-V, if you print out the version of MySQL

Then it proves that the environment configuration of MySQL is successful, as follows:

(1) initialization of MySQL (no password initialization)

Continue under the dos command window run as an administrator, enter the mysqld-- initialize-insecure command to continue initialization without an initial password

As shown in the following figure:

The official documentation is as follows (which can be skipped):

The URL is as follows (which can be skipped):

Https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization-mysqld.html

(2) install MySQL

Continue to be a step, enter the mysqld install command again, and there will be Service successfully installed.

The installation is successful, as shown in the following figure:

(3) start the MySQL service

To continue in the previous step, enter the net start mysql command to start the MySQL service, as shown in the following figure:

(4). Connect MySQL

Enter the mysql-u root-p command again. Enter directly if you continue without a password and enter the MySQL interface.

As shown in the following figure:

5. Set the password (if necessary)

Continue to enter set password = password ("your password") in the MySQL interface in the previous step; enter

That is, if the password is set successfully, MySQL is installed successfully, as shown in the following figure:

6. Navicat premium 12 and the download address of the cracked patch (installing navicat software is no different from installing other ordinary software

Broken.

Thank you for reading this article carefully. I hope it will be helpful for everyone to share the details of mysql download and installation. At the same time, I also hope you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

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.