GNU/Linux |
RedHat 9.0(Shrike) |
|
![]() |
mysqlaccess(1) |
![]() |
mysqlaccess
− Create new users to mysql.
mysqlaccess [host [user [db]]] OPTIONS
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]
−?|−−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.
+ 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
’*’)
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),
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)
![]() |
mysqlaccess(1) | ![]() |