Seth Woolley's Man Viewer

mysqlaccess(1) - .BR mysqlaccess - Create new users to mysql - man 1 mysqlaccess

([section] manual, -k keyword, -K [section] search, -f whatis)
man plain no title

mysqlaccess(1)                  MySQL database                  mysqlaccess(1)



NAME
       mysqlaccess-Createnewusers(1,5)tomysql.

USAGE
       mysqlaccess [host(1,5) [user [db]]] OPTIONS

SYNOPSIS
       mysqlaccess  [-?|--help] [-v|--version] [-p|--password=#] [-h|--host=#]
       [-d|--db=#]   [-U|--superuser=#]   [-P|--spassword=#]    [-H|--rhost=#]
       [--old_server]    [-b|--brief]   [-t|--table]   [--relnotes]   [--plan]
       [--howto] [--debug=N] [--copy] [--preview] [--commit] [--rollback]

DESCRIPTION
       -?|--help
              display this helpscreen and exit(3,n,1 builtins)

       -v|--version
              print information on the program `mysqlaccess'

       -u|--user=#
              username for logging in(1,8) to the db

       -p|--password=#
              validate password for user

       -h|--host=#
              name or IP-number of the host(1,5)

       -d|--db=#
              name of the database

       -U|--superuser=#
              connect as superuser

       -P|--spassword=#
              password for superuser

       -H|--rhost=#
              remote MySQL-server to connect to

       --old_server
              connect to old MySQL-server (before v3.21) which  does  not  yet
              know how to handle full where clauses.

       -b|--brief
              single-line tabular report

       -t|--table
              report in(1,8) table-format

       --relnotes
              print release-notes

       --plan print suggestions/ideas for future releases

       --howto
              some examples of how to run `mysqlaccess'

       --debug=N
              enter debuglevel N (0..3)

       --copy reload temporary grant-tables from original ones

       --preview
              show  differences  in(1,8) privileges after making changes in(1,8) (tempo-
              rary) grant-tables

       --commit
              copy grant-rules from temporary tables to  grant-tables  (!don't
              forget to do an mysqladmin reload)

       --rollback
              undo the last changes to the grant-tables.

NOTE
       At  least the user and the db must be given (even with wildcards) If no
       host(1,5) is given, `localhost' is assumed Wildcards (*,?,%,_)  are  allowed
       for  host(1,5),  user  and  db, but be sure to escape them from your shell!!
       (i.e., type \* or '*')

SEE ALSO
       isamchk(1),    isamlog(1),    mysql(1),    mysqladmin(1),    mysqld(1),
       mysqld_multi(1),    mysqld_safe(1),    mysqldump(1),   mysql_fix_privi-
       lege_tables(1), mysqlshow(1), mysql_zap(1), perror(1,3)(1), replace(1)

       For more information please refer to the MySQL reference manual,  which
       may  already be installed locally and which is also available online at
       http://www.mysql.com/doc/en/

BUGS
       Please refer to http://bugs.mysql.com/ to report bugs.

AUTHOR
       Ver    1.0,    distribution    4.0.21    Michael    (Monty)    Widenius
       (monty@mysql.com),  MySQL  AB  (http://www.mysql.com/).   This software
       comes  with  no  warranty.   Manual  page  by  L.   (Kill-9)   Pedersen
       (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer
       (http://www.mercurmedia.com)




MySQL 4.0                      19 December 2000                 mysqlaccess(1)

References for this manual (incoming links)