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