SQLSTATE[HY000] [1045] Access denied for user ‘username’@’localhost’ using CakePHP

by

That error message usually means that either the password we are using doesn’t match what MySQL thinks the password should be for the user we’re connecting as, or a matching MySQL user doesn’t exist (hasn’t been created).

In MySQL, a user is identified by both a username (“test2”) and a host (“localhost”).

The error message identifies the user (“test2”) and the host (“localhost”) values…

  'test2'@'localhost'

We can check to see if the user exists, using this query from a client we can connect from:

 SELECT user, host FROM mysql.user

We’re looking for a row that has “test2” for user, and “localhost” for host.

 user     host       
 -------  -----------
 test2     127.0.0.1  cleanup
 test2     ::1        
 test2     localhost

If that row doesn’t exist, then the host may be set to wildcard value of %, to match any other host that isn’t a match.

If the row exists, then the password may not match. We can change the password (if we’re connected as a user with sufficient privileges, e.g. root

 SET PASSWORD FOR 'test2'@'localhost' = PASSWORD('mysecretcleartextpassword')

We can also verify that the user has privileges on objects in the database.

 GRANT SELECT ON jobs.* TO 'test2'@'localhost'

EDIT

If we make changes to mysql privilege tables with DML operations (INSERT,UPDATE,DELETE), those changes will not take effect until MySQL re-reads the tables. We can make changes effective by forcing a re-read with a FLUSH PRIVILEGES statement, executed by a privileged user.

More Related Contents:

  1. How to store repeating dates keeping in mind Daylight Savings Time
  2. PHP Fatal error: Class ‘PDO’ not found
  3. How to use multiple databases dynamically for one model in CakePHP
  4. Cakephp-3.x: How to change the data type of a selected alias?
  5. Encryption/Decryption of Form Fields in CakePHP 3
  6. CakePHP Database connection “Mysql” is missing, or could not be created
  7. UNION syntax in Cakephp
  8. Im trying to create some temporary tables in mysql using php
  9. How to apply bindValue method in LIMIT clause?
  10. Importing CSV data using PHP/MySQL
  11. Convert latin1 characters on a UTF8 table into UTF8
  12. Best way to parse bbcode
  13. mysql_fetch_array() expects parameter 1 to be resource problem [duplicate]
  14. PDO multiple queries
  15. Using strtotime for dates before 1970
  16. Php – Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  17. mysql select query within a serialized array
  18. mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in php [duplicate]
  19. Whats the easiest way to determine if a user is online? (PHP/MYSQL)
  20. What is the advantage of using try {} catch {} versus if {} else {}
  21. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  22. How to convert ISO8601 to Date format in php
  23. return one value from database with mysql php pdo
  24. onbeforeprint() and onafterprint() equivalent for non IE browsers
  25. How can I pass an array of PDO parameters yet still specify their types?
  26. MySQL & PHP Parameter 1 as Resource
  27. MySQL GROUP BY and Fill Empty Rows
  28. mysql injection damages?
  29. How do I save PHP session data to a database instead of in the file system?
  30. Escaping SQL queries in Codeigniter

Leave a Comment