Access to MySQL appears "Access denied for user root@localhost" (using Password:no) solutions

First of all, there are many reasons for this hint, and the following is only for a situation I have encountered

When using the decompression version of the installation of MySQL, the Data folder is a new, My-default.ini is also their own configuration, when the direct start of the MySQL service, will appear prompt

"MySQL is starting" "MySQL cannot boot" because the data folder is empty and needs to initialize something in

So I used the mysqld--initialize command.

The egg hurts, this command will default to the root user to set a random password, resulting in the use of the mysql-uroot instruction can not enter (if you do not want to appear this random password, you need to use mysqld--initialize-inscure)

To know this password, you need to find the ". Err" suffix file under the Data folder in the MySQL directory and open it with Notepad

Find "[Note] A temporary password is generated for [email protected]:" XXXXXX this line, the resulting random password after the colon

This password allows you to access MySQL for database operations

Note that the password can only be used once, you need to find ways to change your password

Access to MySQL appears "Access denied for user [email protected]" (using Password:no) solution