Windows MySQL free installation configuration (step over the pit) précis-writers

Download

Download from official website (https://dev.mysql.com/downloads/mysql/)

The free-to-install version here is relatively clean, but you need to configure a lot of things yourself.

Configuration

The first is the service that registers windows.

Open terminal, CD to MySQL directory bin with administrator privileges, execute command mysqld--initialize

This command initializes the database and the service, which is automatically created without the data directory (the MySQL root directory).

Step over the Pit one

Download the extract and locate the MySQL installation directory directly, run Mysql-u root

Tip Error 2003 (HY000): Can ' t connect to MySQL server on ' localhost ' (10061)

The 10061 error is that the network connection failed because the MySQL service did not start. Resolved by the configuration above.

Step over the pit two

I used to be the first command mysqld--install, the service was installed, but when the service started to error, errors are as follows:

The MySQL service on the local computer stops after it starts. Are some services automatically stopped when they are not being used by other services or programs?

After deleting the contents of the data directory, re-executed the mysqld--initialize to be installed.

Step over the pit three

After initialization is completed and then logged in with Mysql-u root, it is found that the password is still required, found that mysqld--initialize initialization will generate a random password, I found a. err file below the data directory, and found a line from the

2018-03-03t15:29:14.852669z 1 [Note] A temporary password is generated for [email protected]: FSL***HK

I use this password to finally log in successfully, the next step is to change the password, as follows to change the password to root.

Alter user ' root ' @ ' localhost ' identified by ' root ';

Windows MySQL free installation configuration (step over the pit) précis-writers