I don't see any user grants

[leegold]

I know mysql root has all the permissions so in the “manage Permissions For Users” window i should see a lot of check marks.

But I see none!

This seems really misleading to me. And for users with DB specific grants I again see no boxes checked were i know for a fact they have grants.

Please explain. Using 4.1 lite.

Thanks

[peterlaursen]

From tools … usermanager you can either choose “edit user” or “manage permissions”.

Under “edit user” you will find the GLOBAL privileges of the user, i,e, permissions that apply to ALL databases.

Under “manage permissions” you will find the SPECIFIC privileges of the user, i,e, permissions that apply to SPECIFIC databases.

In Mysql if the user has a global privilege to (for example) UPDATE, there is no need to grant right to specific privileges.

So check tools … usermanager … “edit user” – you probably will see the checkmarks there!

[leegold]

Yes I understand about the root case. But there are other cases where users have DB specific grants and they are not being shown. On the cmd line or phpmyadmin they are being displayed. So I think there is bug.

[peterlaursen]

Could be ….

However if your Mysql-version has been updated from an earlier version you must run the script provided by myaql to update the user grant tables.

Try cheking if the issue persist if you use “MySQL Administrator” from http://www.mysql.com.

If it persists it bust be an issue with your MySQL-installation.

If it's OK with MySQL Administrato it probably is a bug in sqlyog.

[Author]

Posts