MySQL database                                     mysqlaccess(1)



NAME
     mysqlaccess-Createnewusersto

USAGE
     mysqlaccess [host [user [db] OPTIONS

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

DESCRIPTION
     -?--help
          display this helpscreen and exit

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

     -u--user=#
          username for logging in to the db

     -p--password=#
          validate password for user

     -h--host=#
          name or IP-number of the host

     -d--db=#
          name of the database

     -U--superuser=#
          connect as superuser

     -P--spassword=#
          password for superuser

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

     --oldserver
          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 table-format

     --relnotes



MySQL 4.0         Last change: 19 December 2000                 1






MySQL database                                     mysqlaccess(1)



          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 privileges after making changes  in
          (temporary) 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  wild-
     cards) If no host is given, `localhost' is assumed Wildcards
     (*,?,%,) are allowed for host, 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),
     mysqldmulti(1),        mysqldsafe(1),        mysqldump(1),
     mysqlfixprivilegetables(1),  mysqlshow(1),  mysqlzap(1),
     perror(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.24  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 Archi-
     tect / system developer (http:/www.mercurmedia.com)





MySQL 4.0         Last change: 19 December 2000                 2






MySQL database                                     mysqlaccess(1)



ATRIBUTES
     See attributes(5) for descriptions of the  following  attri-
     butes:

     
       ATRIBUTE TYPE              ATRIBUTE VALUE          
    
     Availability         SUNWmysqlr, SUNWmysqlu, SUNWmysqlt
    
     Interface Stability  External                          
    

NOTES
     Source for mysql is available on http:/opensolaris.org.









































MySQL 4.0         Last change: 19 December 2000                 3