Login to mysql with the command mysql -uroot -pxxxxx -A
use the database mysql mysql> \u mysql View the table name user mysql> show tables; To view the user mysql> select user from user; On 5 February 2010 17:45, Suresh Kuna <sureshkumar...@gmail.com> wrote: > In the mysql prompt, execute the below > > use mysql ; select user from user ; > > will show all the accounts in a MySQL database. > > > On Fri, Feb 5, 2010 at 5:27 PM, ishaq gbola <ishaq...@yahoo.co.uk> wrote: > > > Hi Guys, > > > > Which command can allow me view all accounts in a Mysql database > > > > > > > > > > > > > -- > Thanks > Suresh Kuna > MySQL DBA > -- Ramesh