Hi Guys,
Which command can allow me view all accounts in a Mysql database
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
Login to mysql with the command
mysql -uroot -px -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
Hi!
Use mysql client:
mysql *SELECT `user`, `host` FROM `mysql`.`user` LIMIT 0, 5;*
2010/2/5 ishaq gbola ishaq...@yahoo.co.uk:
Hi Guys,
Which command can allow me view all accounts in a Mysql database
--
Best regards,
Eugene Kilimchuk ekilimc...@gmail.com
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.