[RESOLVED] Get databases/premissions

[dougal85]

Well I know about 'SHOW DATABASES' ...

how can I get a list of the databases that the current user has access too?

Also, How can i get the permissions of a user? ie. user x can SELECT, DELETE, UPDATE on database one but only SELECT on database two.

[Shrike]

http://dev.mysql.com/doc/refman/4.1/en/show-databases.html

http://dev.mysql.com/doc/refman/4.1/en/show-grants.html

Tsk :p

[dougal85]

oops :o ...
I had a quick look but didn't see anything and I thought show databases allowed you to see them all... obviously not.

Thanks, i'll look harder next time 😛 I blame the fact that its 2:30 AM.