D7 Lock out error

Posted by dskaggs on May 17, 2012 at 9:17pm

I was recently working in a D7 install trying to get some slideshow views to work when I got this error:

PDOException: SQLSTATE[28000] [1045] Access denied for user 'username'@'localhost' (using password: YES) in lock_may_be_available() (line 167 of /usr/home/dskaggs/www/7_eleven/drupal/includes/lock.inc).

Now I've looked up other info on it within drupal.org its self and what it says is kinda disturbing as far as fixes go.

The most invasive appears to be having to restart mysql completely. Others include: leaving it alone for about an hour and then logging in( however that only works for a few mins), restarting apache, or just doing a complete reinstall of D7 and starting over.

Already tried restarting apache, but that didn't work.

thoughts, issues of your own in dealing with this kind of thing?

Comments

I get this error all the time

Posted by mrosas on May 17, 2012 at 9:34pm

I get this error all the time when I'm setting up a new server (moving from production to a local environment). While it may look like an intimidating error, It simply means my database credentials aren't correct in my settings.php file. Hoping that helps.