Cdbconnection failed to open the DB connection:sqlstate[28000] [1045] Access denied for user ' root ' @ ' localhost ' (using PA Ssword:yes)

Error connecting MySQL: Cdbconnection failed to open the DB connection:sqlstate[28000] [1045] Access denied for user ' root ' @ ' localhost ' (using Password:yes)

Note here that the ' root ' @ ' localhost ', when checking the login user and login password without errors, can be viewed in the Mysql.user table, whether there is a root user in the user column, and also pay attention to the host column, note that This field is used to restrict the source host address of the MySQL connection.

This means: If you use localhost to connect the need to configure localhost here, if you are using the Local intranet address [such as 192.168.100.100], also need to be configured here.

Final re-execution: mysql> flush privileges;

Cdbconnection failed to open the DB connection:sqlstate[28000] [1045] Access denied for user ' root ' @ ' localhost ' (using PA Ssword:yes)