By flourishing on

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: 'tradesignal@localhost' to database 'mydatabase'.

i check the password and the previlege of the database it's all ok.why ? could any one give me some help ? thank you.

⋅ Categories: Drupal 5.x

Comments

dgorton’s picture

dgorton commented

The answer is in the error -- this is an issue with your MySQL configuration, and more specifically, with the 'tradesignal' user accessing the 'mydatabase' database. Do both of those exist? What about the password: do you have a password? Is it typed in correctly?

If you're positive that all of the above are ok (double- and triple-check), then it may be that your 'tradesignal' user doesn't have the LOCK TABLES permission. If you're using something like phpMyAdmin to manage the database, you can check these things under the 'privileges' link on the starting page.

If tracking these things down doesn't solve the problem (or your unsure how to track them down) then you'll need to provide a lot more information so someone can tell you exactly where to find/change the necessary info. Describe the environment (local? server on the internet?), how you're managing MySQL (command line? phpMyAdmin? other?) and how you're doing the test (just a php script? using Drupal and the connection in the settings.php file? other?)

Drew Gorton
Gorton Studios

flourishing’s picture

flourishing commented

thank you .

the reason is the service provider haven't change the previlege lock table.