Magento – SQLSTATE[28000] [1045] Access denied for user ‘balmain’@’localhost’ (using password: YES) databasemagento-1.9magento-connectsql I'm attempting to connect on my site in magento 1.9 on my work environment. It's shown a page like this: Until other yesterday everythig worked perfectly.. Can you help me,please? Thanks! Best Answer Check the below steps DB Checks : Make sure the Db still exists , Ensure that user balmain'@'localhost has been granted access to the database in question. Xammp/WAMP/ Server Checks : Check for MYSql service is running , check if the port is changed or not . Magento Checks : clear cache ,Disable all 3rd party modules on the server , Make sure you have reset the file permissions Magento Wiki If you are still getting error messages, verify that the username, password and database name /app/etc/local.xml Related SolutionsMagento Down SQLSTATE[28000] Error – How to Fix Access Denied for User Wrong username and password or invalid access rights to you MySQL server. Check app/etc/local.xml and verify your credentials. If you need to reset you MySQL password you have to access your MySQL shell and use the following command (replace with correct information): GRANT ALL PRIVILEGES ON yourdbname.* TO 'pctekcom_magento'@'127.0.0.1' IDENTIFIED BY 'yourpassword'; NOTE: MySQL username and password, NOT Magento username and password. If you have phpMyAdmin you can use the "users" function. Also try using localhost instead of 127.0.0.1 in your app/etc/local.xml, sometimes it fails the reverse lookup for localhost. Magento – SQLSTATE[HY000] [1045] Access denied for user ‘root’@’localhost’ (using password: NO) Your server host is localhost:8889 So on the Database Server host try to give localhost:8889 instead of on localhost. Hope this will help you Related TopicMagento-1.9 – Fix SQLSTATE[HY000] [1045] Access Denied for User ‘root’@’localhost’Magento 1.9 – Fix ‘Access Denied for User root@localhost’
Best Answer
Check the below steps
If you are still getting error messages, verify that the username, password and database name
/app/etc/local.xml