mysqlaccess
Section: MySQL database (1)
Updated: 19 December 2000
Index
Return to Main Contents
NAME
mysqlaccess
- Create new users to mysql.
USAGE
mysqlaccess [host [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
- -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
- --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 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 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 wildcards)
+ If no host is given, `localhost' is assumed
+ Wilcards (*,?,%,_) are allowed for host, user and db, but be sure
to escape them from your shell!! (ie type or '*')
SEE ALSO
isamchk (1),
isamlog (1),
mysqlaccess (1),
mysqladmin (1),
mysqlbug (1),
mysqld (1),
mysqldump (1),
mysqlshow (1),
msql2mysql (1),
perror (1),
replace (1),
safe_mysqld (1),
which1 (1),
zap (1),
AUTHOR
Ver 1.0, distribution 3.23.29a
Michael (Monty) Widenius (monty@tcx.se),
TCX Datakonsult AB (http://www.tcx.se).
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)
Index
- NAME
-
- USAGE
-
- SYNOPSIS
-
- DESCRIPTION
-
- NOTE
-
- SEE ALSO
-
- AUTHOR
-
This document was created by
man2html,
using the manual pages.
Time: 19:49:16 GMT, May 09, 2025