Changing SQL user name and password

[jamessonny]

Hey guys,

I had bad luck with 3 freelancers and now I have to get back into it. I used to work on osCommerce back in the day but my knowledge around Magento is very limited.

Right now I have to change all shop and server credentials. I got all done but when I change the SQL DB user and password in Plesk and in local.xml, I get:

SQLSTATE[28000] [1045] Access denied for user 'xxxxxxxx'@'localhost' (using password: YES)

Trace:
#0 /var/www/vhosts/feisol.net/httpdocs/lib/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /var/www/vhosts/feisol.net/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(320): Zend_Db_Adapter_Pdo_Mysql->_connect()

Since I can't access the backend, I deleted via FTP the cache under var/cache. This worked for the test shop under a sub domain, but the life shop still comes back with the 'access denied' error message.

I read somewhere that I also need to start the compiler. Is that correct? How can I do that via SSH? Any other suggestions?

Magento ver. 1.9.1.1

Thank you for looking into this.

[Damian Culotta]

Hi @jamessonny,

First of all, on Magento1, don't use the compiler (are more the problems than the solutions).

Second, if you can access through SSH try to connect to your mysql server with the same credentials you are using on /app/etc/local.xml

mysql -u YOUR_USERNAME -p -h IP_OR_HOSTNAME_IF_DIFFERENT_TO_LOCALHOST

(If the host is localhost, don't use the -h part).

Then you'll be asked for your password.

If you are able to connect using those credentials, you should use the same on /app/etc/local.xml.