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

Re: how to view all acounts in a database

[Евгений Килимчук]

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 

Re: how to view all acounts in a database

[RaMeSh]

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 ; 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
> MySQL DBA
>



-- 
Ramesh

Re: how to view all acounts in a database

[Suresh Kuna]

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
MySQL DBA