Re: Grant Statement...
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.
Subject
Views
Written By
Posted
5708
March 30, 2005 12:01PM
Re: Grant Statement...
2435
March 30, 2005 06:14PM
2578
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.