Mysql Problem with Drupal

after i mention about Drupal vs Mambo , i getting some feedback and more putting effort for more research, i decided to use Drupal . i was playing with Drupal this few day, i found out that Drupal is not that easy as i think but its more intersting if i compare to Mambo .

So i was keep getting this error

user error: Access denied for user: ‘[email protected]’ to database ‘drupal’
query: LOCK TABLES sequences WRITE in /htdocs/bla/includes/database.mysql.inc

althought it wont really affect anything. but is quite annoying, so i decide to debug this error, i found some solution at drupal site but it seem wierd to me because my mysql is on  4.02 but i can’t see the lock table option, then i saw an error msg on phpmyadmin, i know that i need to upgrade my privilege tables. althought my mysql is on version 4.02 but my privilege tables still on version 3.23.

so these are the step

  • run this under shell mysql_fix_privilege_tables –password=root_password
  • it show some success msg and some duplicate error msg which can ignore
  • restart mysql server /etc/init.d/mysql restart
  • login phpmyadmin now you can see the lock table option
  • grant the option for the user and for the particular database

    problem solve !

    Share it with your friends, thanks !
    Share on FacebookTweet about this on TwitterShare on Google+Share on TumblrBuffer this pagePin on PinterestEmail this to someone

    You may also like...

    • ZEO

      I’m oso developing few site using drupal. But not the normal drupal. it’s civicspace the enhanced drupal. Based on drupal 4.5.
      It’s neat, clean and the installation/configuration is user friendly.
      Most of the themes is not FF friendly. Need some tweaks.