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.
--
Hi!
Use mysql client:
mysql> *SELECT `user`, `host` FROM `mysql`.`user` LIMIT 0, 5;*
2010/2/5 ishaq gbola :
> Hi Guys,
>
> Which command can allow me view all accounts in a Mysql database
>
>
>
>
--
Best regards,
Eugene Kilimchuk
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 wrote:
> In the mysql prompt, execute the below
>
> use mysql ;
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 wrote:
> Hi Guys,
>
> Which command can allow me view all accounts in a Mysql database
>
>
>
>
--
Thanks
Suresh Kuna
MySQ
