Technote Details :: Issue when creating a database connection: Access denied for user: username@hostname (Using password: Yes/No)
Issue
When creating a new ADODB database connection, I get an error message saying: Access denied for user: username@hostname (Using password: Yes/No).
Reason
This happens because:
The username or the password you specified for this MySQL connections are wrong.
This username is not authorized to connect from the testing server to the MySQL database
Solution
Possible solutions to this issue are:
Check that the username and password are entered correctly as they should by re-entering them.
Check if the username@hostname using the password you provided have the rights to connect to the MySQL database by looking in the mysql table.
