Try: mysql -e "SELECT user FROM mysql.user" You may need to add the following as well mysql -h hostname -uyouruserid -pyourpassword -e "SELECT user FROM mysql.user"
-----Original Message----- From: Mike Yrabedra [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 6:55 AM To: [EMAIL PROTECTED] Subject: List users? How would I list all users via the command line? <sql,query> -- Mike Yrabedra President 323 Enterprises Home of The MacDock and The MacSurfshop [http://macdock.com] : [http://macsurfshop.com] VOICE: 770.382.1195 _______________________________________________________________________ "in all your ways acknowledge Him and He will direct your paths." Proverbs 3:6 NIV <{{{>< -- --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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