Unexpected Exception: SQLSTATE[HY000] [1045] Acces

问题:

An application was handed to me by an old colleague to manage. However, whenever I try to run it, I keep getting this error. Please any help would do.

http://i.stack.imgur.com/zPYuJ.jpg

回答1:

Sometimes Access denied Exception Error because your mysql credentials are invalid. Secondly, from my experience i observed that this also happens because you did not set password to your database connectivity. eg

private $host = "localhost";
private $db_name = "db_dbtest"; // Database name
private $username = "db_user"; // your database username
private $password = "db_password"; // Your password
public $conn;

}

Try and set password to your database connectivity. I had such experience and after changing my Collation to utf8_general_ci on the Operations tab, this could not solve my problem. I thought of adding password to my database connection and immediately it connected. You can tesrun this and see if it helps.

回答2:

You're getting Access denied Exception Error because your mysql credentials are invalid.

回答3:

This is due to the wrong sql information provided by you.Changing it to the right one can solve this error .

回答4:

I was getting this same error code. I'm using phpMyAdmin and added the database with the import of a sql file. The website was using all the same code that had worked before. To fix this error go inside phpMyAdmin and click on the database then operations tab. Change the collation of my database to "ut8_general_ci". Afterwards it was able to verify the username/password access to the database.

Also you might want to make sure you added the user accounts tab the username,password and privileges to access the database.

回答5:

Well it means the SQL credentials you are using are wrong there is nothing much we can do, you need to use the correct ones or use the root account to change the user's password or rights.

回答6:

I know this is an old question, but for me I had to set my password in Sequel Pro to the password that was listed in my .env config file. Hope this helps someone!

回答7:

The site you got handed has the login credentials for your colleague's machine/site. Depending on the site, different files need to be changed. Example, Wordpress usually has the settings in a file called wp-config.php

Until you find this file, maybe you can change your XAMPP user login to match. This article on SO tells how to change SQL login credentials:

How do I use MySQL through XAMPP?