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 Facebook
Facebook
Tweet about this on Twitter
Twitter
Share on Google+
Google+
Share on Tumblr
Tumblr
Buffer this page
Buffer
Pin on Pinterest
Pinterest
Email this to someone
email

You may also like...