how to view all acounts in a database

--0-347926349-1265371046=:24602
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hi Guys,

Which command can allow me view all accounts in a Mysql database
=0A
--0-347926349-1265371046=:24602--

Re: how to view all acounts in a database

--001636e1f938743c09047ed9674d
Content-Type: text/plain; charset=ISO-8859-1

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

--001636e1f938743c09047ed9674d--

Re: how to view all acounts in a database

--0016e68debd647594d047edad03b
Content-Type: text/plain; charset=ISO-8859-1

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

--0016e68debd647594d047edad03b--

Re: how to view all acounts in a database

--000e0cd1194889d90b047ee025b4
Content-Type: text/plain; charset=ISO-8859-1

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

--000e0cd1194889d90b047ee025b4--

Re: how to view all acounts in a database

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=gcdmg-mysql-2@m.gmane.org