Posted on: 09/21/05 04:29am
By: Anonymous (Seekon)
im sry to disturb u guys again but im getting this error
1142: CREATE command denied to user 'seekon'@'localhost' for table 'gl_access'
I get this error after I press next in "Geeklog Database Settings (Step 2 of 2)" where u have to check "Use InnoDB tables" or not(I havent).
before this I also got an error access described in
here[*1]
and I tiped "GRANT ALL PRIVILEGES ON database_name TO user@host IDENTIFIED BY 'password';" ofcourse with mine password and it worked and now im stucked here pls help
ty for helping
Posted on: 09/21/05 02:18pm
By: Dirk
Well, the error message is pretty clear: The database user "seekon" is not allowed to create new tables. So it seems that GRANT ALL PRIVILEGES didn't work ...
bye, Dirk
ty for helping
Posted on: 09/22/05 12:19pm
By: Anonymous (Seekon)
em... when in mysql server I type this sentence:
"GRANT ALL PRIVILEGES ON geeklog TO seekon@localhost IDENTIFIED BY '***********';" *** is a password ofcourse.
when I press "ok" I get an error :
"ERROR 1046 : No database selected"
after that I tried :
"use geeklog" and I get "Database changed" and then I tried the upper sentence again "GRANT ALL PRIVILEGES..." and I get this:
"query OK, 0 rows affected "
so..... what am I doing wrong?
ty for helping
Posted on: 09/22/05 04:32pm
By: Dirk
Sound about right. I assume you're doing this while being logged in as the MySQL root user? If so, I'm out of ideas ...
bye, Dirk