Seekon

Anonymous
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
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

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
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

Seekon

Anonymous
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?

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
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