Hi.

Don't know if there is a better method, but one is to run (by a user with root 
privileges):

mysql> SELECT user, host FROM mysq.user ORDER BY user, host;

Bye,

        Benjamin.


On Fri, Feb 02, 2001 at 11:17:36AM +0800, [EMAIL PROTECTED] wrote:
> hi listers,
> 
> just wanted to know the command for checking the list of usernames allowed 
> to connect to a mysql server. any help would be greatly appreciated.
> 
> thanks,
> 

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to