Mysql5.7 installation, mysql5.7.9 installation tutorial

Mysql5.7 installation, mysql5.7.9 installation tutorial

For more information about installing mysql 5.7 in windows

• Note:

After installing mysql 5.7, the ROOT account has the default password, which can be found in mysql in windows. under the data folder specified in the ini configuration file, that is. find the file with the suffix err.

2016-07-16T04: 14: 27.448186Z 1 [Note] A temporary password is generated for root @ localhost :? Wxxx

It is best to remove the folder name of mysql, such,

There are other installation posts on the Internet said to create a new, my. ini, I new mysql service can not start, if you want to change the configuration, directly in the my-default.ini to change it.

• For other installations, follow the install steps in the official documentation,

Download, decompress, and add the mysql bin directory to the environment variable. Specify the bin path in the path.

 

Run cmd. Run it with admin. Run cd in the mysql bin directory and run the following command:

Add service commands to add mysql to windows services, which can be set to automatic start: mysqld install MySQL -- defaults-file = "D: \ mysql \ mysql57 \ my-default.ini"

Command: mysqld remove (if you want to remove mysql, try again)

 

Start mysql in command line cmd command: net start mysql

Run the following command to disable mysql: net stop mysql.

At this time, you can log on to mysql using mysql-u root-p and find the password in the xx. err file.

 

• At this time, you can try to create a new user, create a new database, and use the new database for new users,

Create user xiaofang identified by 'root ';

Create database online_shopping;

Grant all privileges on online_shopping. * to xiaofang @ '%' identified by 'root ';

Commit;
Flush privileges;

 

Then use the newly created xiaofang to connect to the database and check whether the database is successful.