Posted by deaconzero on August 27, 2006 at 11:55pm
So, I just installed the newest version of Drupal, starting on a new site, and everything worked fine but I got the message
Access denied for user: '****@*****' to database '***_****' query: LOCK TABLES cache WRITE in /home/*****/public_html/drupal/includes/database.mysql.inc on line 120.
(The *** are just substitutes for the real things, didn't really wanna post it on here)
when I first went to the site. So, I tried to sign up to test it out and I signed up fine, but I got that message again. Then I posted a news story to test it, and it posted fine, but I still got the same message. Any idea???
Comments
Looks like you need to go
Looks like you need to go into your database and give more permissions to the database user (allow it to do everything, including locking tables).
Sorry... any idea on how to
Sorry... any idea on how to do that. In phpmyadmin or in my cpanel or somewhere else? Sorry for the bothersome questions. Hope you can help :)
FAQ
Troubleshooting FAQ » "LOCK TABLES sequences WRITE" error
--
The Manual | Tips for posting | How to report a security issue.
--
The Manual | Troubleshooting FAQ | Tips for posting.