Re: how to view all acounts in a database

[John Meyer]

On 2/5/2010 5:15 AM, Suresh Kuna wrote:
In the mysql prompt, execute the below
use mysql ; select user from user ;

will show all the accounts in a MySQL database.



Alternatively, you can use myphpadmin.  I guess it all depends upon what 
you need the information for and to what purpose.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org