SEARCH
NEW RPMS
DIRECTORIES
ABOUT
FAQ
VARIOUS
BLOG
DONATE


YUM REPOSITORY

 
 

MAN page from Trustix mysql-client-3.23.58-3tr.i586.rpm

mysqlaccess

Section: MySQL database (1)
Updated: 19 December 2000
Index 

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 makingchanges 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.29aMichael (Monty) Widenius (montyAATTtcx.se),TCX Datakonsult AB (http://www.tcx.se).This software comes with no warranty.Manual page by L. (Kill-9) Pedersen (kill-9AATTkill-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 byman2html,using the manual pages.