Permission problem

[BangingHead]

I am having real difficulty with the permission tables.

Have created a User who has all permissions for the database Mall (have checked in the Mysql db table and everything is set to 'y') yes I am not allowed to create permissions for other users. Every time i try it it says i don't have access to the 'mysql' database.

I even tried out of desperation setting the grant_priv to 'y' in the user table and still don't seem to be able to grant permissions. Does anyone know where I am going wrong?

Thank you very much

 

[tshot]

after u have direclty updated the grant table did u issue flush privilges or restart the mysqld server.

then check for case snsitivity. some of them are (undr unix)
==========================
Column Case sensistiv
------------------------------------------
Host No
User Yes
Password Yes
Db Yes
Table Name Yes
Column Name No
==========================
also check for the following equation

user or (db and host) or tables_priv or coulmns_priv.

this is the way server checks for permmissions




----------------
ur feedback is a very welcome desire

 

[QatQat]

I would not get lost in the privileges tables and users tables.

The GRANT utility can do everything for you.

More on this:

http://www.mysql.com/doc/en/GRANT.html

Bye

Qatqat






Life is what happens when you are making other plans.

 

[BangingHead]

I did use grant initially to set up these permission i have tried specifying the grant ability in the permissions and using the with grant option at the end. it doesn't seem to like it so am probably going to have to set this to do it manually as i am noy sure i like the idea of setting up a super user even if it is being used only from a php script