By peacho on

After running a Fantastico script to get Drupal 5.1 set up on my web site, I was prompted to enter database settings which I did, mostly, by a process of copying and pasting from the cpanel. However, after many attempts, I cannot seem to get past it. I keep getting this error:

We were unable to lock a test table on your MySQL database server. We tried locking a table with the command LOCK TABLES drupal_install_test WRITE and MySQL reported the following error: Access denied for user '%username%' to database '%databasename%'.

I've replaced my username and databasename with the fillers above for protection, but you get the main point. I had previously used this system to install Drupal 5.0, but because I had lost my Adminstrator password, I had to start completely over. (And in case you're wondering, it's too late to get the old database back).

How do I fix this critical error?

⋅ Categories: Drupal 5.x

Comments

ñull’s picture

ñull commented

It looks like you did not grant the user LOCK permission. Best is to delete the user of the database in Cpanel and create it anew with the same user name and password, but now granting all permissions.

harry slaughter’s picture

harry slaughter
Location Omaha NE USA
commented

Or you can just fix the current mysql user.

I suggest granting no permissions to the drupal user in the mysql.user table and then granting appropriate db permissions in the mysql.db table either adding one row per db or using something like 'drupal\_%' in the mysql.db.db field if you have a naming convention for your drupal databases.

You don't want your drupal user having free reign over the entire server.

--
Drupal tips, tricks and services
http://devbee.com/ - Effective Drupal

--
Devbee - http://devbee.net/