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. Note: This level of access is insufficient
for an ezmlm-test(1)
user or main list user.
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'' creates 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)