Hello Jacques-Beaudoin,

JB> I would like to now de mysql command to put in
JB> a bash script to list all the users in a dbmail database.

List users:

select userid from dbmail.user

List aliases:

select alias from dbmail.aliases

You need to pipe whichever of the above you want into the mysql
command, taking into account user ID and passwords to access your
databases (we do not allow ANY unidentified access to our databases).

If the user executing the script requires no password for mysql, you
could run:

echo 'select alias from dbmail.aliases;' | mysql

-- 
Jeff Brenton
President,
Engineered Software Products, Inc
http://espi.com
Questionable web page: http://dididahdahdidit.com

Liberalism grants you the freedom to advocate any idea*.
 * Please see http://www.dididahdahdidit.com/except.php for a
   current list of exceptions

Reply via email to