Thursday, August 30, 2012

mysql tidbits

To list all the database, type the following command
mysql> show databases;
To list all the users, type the following command
SELECT user FROM mysql.user;

No comments:

Post a Comment