MySQL ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: NO,

MySQL ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: NO,

MySQL ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: NO) solution and cause

I downloaded MySQL5.7.11 for installation in the past two days and found that no matter how many times I entered the password for the first time, I couldn't even add skip-grant-tables under mysqld as I said on the Internet, after studying the problem for two days, I finally found out the cause and solution.

Copy codeThe Code is as follows:
[Mysqlld]
Skip-grant-tables;

Cause: Mysql 5.6 and later versions come from security considerations. The root password is not empty. Therefore, during MySQL installation, a random password is generated as the initial password.

Enter a random password.

The password is:

D: \ Program Files \ mysql-5.7.11-winx64 \ data

Including:

This is a random password. You can use the root account and the random password to log on.