A comprehensive analysis of the method for installing mysql5.7 under Windows _mysql

about installing MySQL 5.7 under Windows

• The new pits to be noted:

After the 5.7 version is installed, the root account has a default password, which can be found under Windows under the Data folder specified by the Mysql.ini configuration file, which is located in the file for the. err suffix name.

2016-07-16t04:14:27.448186z 1 [note] A temporary password are generated for root@localhost:? wxxx

MySQL folder name best get rid of,--,. Such a character,

There are other installation posts on the Internet that a new, My.ini, I built after the MySQL service does not start, if you want to change the configuration, directly in the My-default.ini inside the change is good.

• Other installation, follow the official document of the install steps to go,　

Download, unzip, add MySQL Bin directory to environment variables, path inside specify bin paths.

Run cmd, preferably with admin run, CD to MySQL bin directory, run the following command:

Add a service command to add MySQL to Windows services, which can be set to start automatically: mysqld install MySQL--defaults-file= "D:\mysql\mysql57\ My-default.ini "

The Remove Service command is: mysqld remove (if you want to remove MySQL, start over)

Start mysql command at command line cmd: net start MySQL

Turn off MySQL command as: net stop MySQL

This time, can mysql-u root-p, login mysql, password in xx.err file inside to look for.

This time, you can try to create new users, create new databases, and use new databases,

Create user Xiaofang identified by ' root ';
Create database online_shopping;
Grant all privileges on online_shopping.* to xiaofang@ '% ' identified by ' root ';
Commit

Then use the new Xiaofang to connect to the database to see if it succeeds.

The above is a small set for you to introduce a comprehensive analysis of Windows installed mysql5.7 method, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!