Quick MySQL Command Question

[GreatSageCorban]

I'm trying to figure out how to check MySQL permissions on different users. (self made, root, ect. ect.) What's the command to check permissions, and/or delete an additional username. Thanks.

[mikenune]

There's no easy way to do it.

I know I'm starting to sound like a broken record, but if you have a Web Server installed on your computer (such as IIS/PWS or Apache's HTTPd) then I'd strongly reccommend setting up PHPMyAdmin (from http://www.phpmyadmin.org/, you'll need PHP first :P). If you have that set up then you can just click on the "Permissions" link for an easy view.

If you don't want to go that route you'll have to come up with an effective SQL query. I don't know how to do it though since it requires looking at 4 tables to get all the info you need.

[Derision]

Originally Posted by GreatSageCorban

I'm trying to figure out how to check MySQL permissions on different users. (self made, root, ect. ect.) What's the command to check permissions, and/or delete an additional username. Thanks.

Here is a good introduction to mysql permissions:

http://www.databasejournal.com/featu...le.php/3311731

type 'use mysql' before issuing the example commands that they give in that article.

[GreatSageCorban]

Thanks both of you. :o That link is going to be very useful, if I run into additional problems I will post here again.