ezmlm-grant(1)                                     ezmlm-grant(1)

NAME

ezmlm-grant - grant SQL access to sublist user

SYNOPSIS

ezmlm-grant [ -d database ] [ -t table_root ] host user password

DESCRIPTION

ezmlm-grant outputs the necessary SQL statements to grant sufficient access for user with password on host to the database in order to run an ezmlm sublist. Usually, the output is piped to mysql(1).

OPTIONS

NOTE: The arguments must be separated by a space from the respective switches. -d database Use database as the database, rather than the default ``ezmlm''. -t table_root Use table_root as the table root name, rather than the default ``list''.

USAGE

ezmlm-grant -d db -t list host user password | \ mysql -hdbh -uusr -p This connects to the mysql server on ``dbh'' as ``usr'' (prompting for the password) and in database ``db'' cre- ates tables gives access for sublist user ``user'' on ``host'' with password ``password'' to the database tables with root ``list''.

SEE ALSO

ezmlm-mktab(1), ezmlm-send(1), ezmlm(5), mysql(1) 1

1994 Man-cgi 1.15, Panagiotis Christias <christia@theseas.ntua.gr>