.TH mysqlaccess 1 "19 December 2000" "MySQL @MYSQL_BASE_VERSION@" "MySQL database" .SH NAME .BR mysqlaccess \- Create new users to mysql. .SH USAGE mysqlaccess [host [user [db]]] OPTIONS .SH SYNOPSIS .B mysqlaccess .RB [ \-? | \-\-help ] .RB [ \-v | \-\-version ] .RB [ \-p | \-\-password=# ] .RB [ \-h | \-\-host=# ] .RB [ \-d | \-\-db=# ] .RB [ \-U | \-\-superuser=# ] .RB [ \-P | \-\-spassword=# ] .RB [ \-H | \-\-rhost=# ] .RB [ \-\-old_server ] .RB [ \-b | \-\-brief ] .RB [ \-t | \-\-table ] .RB [ \-\-relnotes] .RB [ \-\-plan ] .RB [ \-\-howto ] .RB [ \-\-debug=N ] .RB [ \-\-copy ] .RB [ \-\-preview ] .RB [ \-\-commit ] .RB [ \-\-rollback ] .SH DESCRIPTION .TP .BR \-? | \-\-help display this helpscreen and exit .TP .BR \-v | \-\-version print information on the program `mysqlaccess' .TP .BR \-u | \-\-user=# username for logging in to the db .TP .BR \-p | \-\-password=# validate password for user .TP .BR \-h | \-\-host=# name or IP\-number of the host .TP .BR \-d | \-\-db=# name of the database .TP .BR \-U | \-\-superuser=# connect as superuser .TP .BR \-P | \-\-spassword=# password for superuser .TP .BR \-H | \-\-rhost=# remote MySQL\-server to connect to .TP .BR \-\-old_server connect to old MySQL\-server (before v3.21) which does not yet know how to handle full where clauses. .TP .BR \-b | \-\-brief single\-line tabular report .TP .BR \-t | \-\-table report in table\-format .TP .BR \-\-relnotes print release\-notes .TP .BR \-\-plan print suggestions/ideas for future releases .TP .BR \-\-howto some examples of how to run `mysqlaccess' .TP .BR \-\-debug=N enter debuglevel N (0..3) .TP .BR \-\-copy reload temporary grant\-tables from original ones .TP .BR \-\-preview show differences in privileges after making changes in (temporary) grant\-tables .TP .BR \-\-commit copy grant\-rules from temporary tables to grant\-tables (!don't forget to do an mysqladmin reload) .TP .BR \-\-rollback undo the last changes to the grant\-tables. .SH NOTE At least the user and the db must be given (even with wildcards) 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 '*') .SH "SEE ALSO" isamchk(1), isamlog(1), mysql(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privilege_tables(1), mysqlshow(1), mysql_zap(1), perror(1), replace(1) .P 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/ .SH BUGS Please refer to http://bugs.mysql.com/ to report bugs. .SH AUTHOR Ver 1.0, distribution @MYSQL_NO_DASH_VERSION@ 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) .\" end of man page