Posted by kat gjovik on November 21, 2009 at 1:06am
Anyone working with Drupal sites hosted by APlus and serious difficulties with their Nov 6 OS upgrade? Still trying to find/resolve root cause of files not found, blank pages at log-in, etc; would like to commiserate. Thanks!
Comments
Yes in fact
We've been getting the following errors ever since their upgrade.
user warning: Access denied for user 'dkorten-1'@'%' to database 'dkorten-1' query: LOCK TABLES cache_menu WRITE in /services5/webpages/util/d/k/dkorten.site.aplus.net/public/includes/database.mysql.inc on line 172.
Any insight into what might be at the root of that?
Kevin
MySQL Permissions
Drupal 5 requires the LOCK TABLES permission on the MySQL user account that's accessing the Drupal database. The error you're getting seems to indicate that your MySQL user no longer has that privilege granted. Here's the page that shows all the MySQL permissions needed:
http://drupal.org/getting-started/5/install/create-database/mysql
I'd contact the host and ensure that all these permissions are on the 'dkorten-1' user.
cheers!