[SOLVED][Drupal Errors][Drupal 6] "LOCK TABLES sequences WRITE" error

| | 1 min read

Many Drupal users have encountered the following error in their Drupal sites. "user error: Access denied for user: 'user@host' to database 'database' query: LOCK TABLES sequences WRITE in [path]/database.mysql.inc on line xx". If you are facing the same error message in your Drupal site then read on to find out the solution.

This error message occurs if the database user account does not have the necessary privileges within the database. Follow the steps below to remove the error message.

  • First confirm if you have granted all the necessary privileges to your user.
  • You can grant the LOCK tables privilege by running the following command
    GRANT LOCK TABLES ON databasename.* TO username@localhost IDENTIFIED BY 'password';
  • If that does not work, you need to follow it by "FLUSH PRIVILEGES"
  • If you are still getting this problem request your host to provide global LOCK TABLES privilege for your database user.

Hope that helps.

The easiest way to solve a Drupal issue is to hand it to the Drupal experts. We can provide a wide range of Drupal services to help you maintain and manage your Drupal websites. Get in touch with us to know more.