mysqlaccess.1 2.73 KB
Newer Older
unknown's avatar
unknown committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108
.TH MYSQLACCESS 1 "19 December 2000"
.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
    + Wilcards (*,?,%,_) are allowed for host, user and db, but be sure 
      to escape them from your shell!! (ie type \* or '*')
.SH "SEE ALSO"
isamchk (1),
isamlog (1),
mysqlaccess (1),
mysqladmin (1),
mysqlbug (1),
mysqld (1),
mysqldump (1),
mysqlshow (1),
msql2mysql (1),
perror (1),
replace (1),
unknown's avatar
unknown committed
109
mysqld_safe (1),
unknown's avatar
unknown committed
110 111 112 113 114 115 116 117 118 119 120 121
which1 (1),
zap (1),
.SH 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)

.\" end of man page