MySQL Forums
Forum List  »  Security

Re: Grant Statement...
Posted by: Rakesh Gupta
Date: March 30, 2005 06:14PM

Once you login into MySQL you can run show databases; command to list all the available databases.
You can find MYSQL database into the listing.
> use mysql; command to switch to MYSQL database.
You can find the list of tables using > show tables; command.
You can find USER table listed into mysql database.
you can find host, user and password that you defined into GRANT statement.
> select host, user, password from user;
(> desc user; command to list the available columns of USER table)

hope it will help.

Options: ReplyQuote


Subject
Views
Written By
Posted
5590
March 30, 2005 12:01PM
Re: Grant Statement...
2387
March 30, 2005 06:14PM
2522
March 30, 2005 07:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.