MySQL issue during installation
dharvey - December 3, 2006 - 10:07
| Project: | Drupal |
| Version: | 5.0-beta2 |
| Component: | mysql database |
| Category: | support request |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | by design |
Jump to:
Description
Hello,
During the installation of Drupal 5.0-beta2, the following error occurs:
The following error must be resolved before you can continue the installation process:
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: 'd-w-harv@localhost' to database 'd-w-harv_website'.
Other CMS systems such as Serendipity or PHPBB are not affected.
Thanks
David harvey
#1
Are you sure that 1) You've created the database; 2) You've created the user d-w-harv, and given that user "all privileges" on that database? Basic permissions (select, insert, update, delete) aren't enough. Drupal requires lock, create, and drop permissions as well.
#2
Actually, in MySQL 3.23 you must have SELECT, INSERT, DELETE, and UPDATE privileges. As of 4.02 you'll need LOCK TABLES as well. But like Crell said, you might try checking your table permissions, and be sure to FLUSH PRIVILEGES after performing any GRANT statements.
If you still have trouble, then knowing what version of MySQL you're running would be helpful.
#3
Marking as 'by design'. Read this post for some help: http://drupal.org/node/17241.
#4
Hello,
My web host has enabled the privileges for the error I encountered.
David Harvey