This article details the download and installation of MySQL tutorial, the text with the download address, as well as the environment configuration of MySQL, each step has a detailed introduction, to everyone to reference, I hope to help you.
1. Download MySQL (take MySQL5.7 version for example)
Download URL: https://dev.mysql.com/downloads/mysql/5.7.html#downloads
Generally download MySQL 32-bit binary compression package, 64-bit version of the general installation will be reported "MySQL service does not start 3534" error,
If the download is a 64-bit binary installation package, also reported that "MySQL service can not start 3534" and other similar errors, please Baidu solution by itself,
This article takes the 32-bit MySQL binary compression package installation as an example, as shown in:
To download a different version of MySQL, download the URL as shown below:
https://dev.mysql.com/downloads/mysql/
2. MySQL Environment Configuration
Unzip the downloaded MySQL binary compression package to where you feel fit, then right-click on My Computer-Properties-Advanced system settings
--Environment variable "Enter the environment variable interface as shown in:
Then add the path of your extracted MySQL file with the bin directory to the paths variable,
As shown in the following:
3. Configuration verification and MySQL installation
Open DOS Command window with administrator Run Fang, enter Mysql-v, if print out MySQL version good,
It proves that the environment configuration of MySQL is successful as follows:
(1), MySQL initialization (no password initialization)
Continue under the DOS command window that the administrator runs, enter the mysqld--initialize-insecure command to continue without initial password initialization,
As shown in the following:
The official documentation is as follows (can be skipped):
The URL is as follows (can be skipped):
Https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization-mysqld.html
(2), install MySQL
Continuing is a step, enter the Mysqld install command again, and the service successfully installed will appear.
Indicates that the installation was successful, as shown in:
(3). Start MySQL Service
Continue to the previous step, enter the net start MySQL command to start the MySQL service as shown in:
(4), connect MySQL
Enter the Mysql-u root-p command again, since no password continues directly to enter the MySQL interface,
As shown in the following:
5. Set the password (if necessary)
Continue in the previous step of the MySQL interface, enter, set password = password ("Your password"); enter
That is, if the password is set successfully, the MySQL installation succeeds as shown in:
6, Navicat Premium 12 and cracked patch download address (install Navicat software and install other normal software no difference,
Crack instructions in the patch file, Baidu can also), it is:
Link: https://pan.baidu.com/s/1wfs9tIhbhNN4E5OIW8s6Jg Password: JCPF
7. End
Related articles:
MySQL Installation and configuration
MySQL installation and master-slave configuration