MAN Solaris - mysqlaccess (1)

advertisement


NAME

mysqlaccess-Createnewuserstomysql.

CONTENTS

Usage
Synopsis
Description
Note
Bugs
Author
Attributes
Notes

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]

advertisements

advertisements


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 Wildcards (*,?,%,_) are allowed for host, user and db, but be sure to escape them from your shell!! (i.e., type \* or ’*’)

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)

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/

BUGS

Please refer to http://bugs.mysql.com/ to report bugs.

AUTHOR

Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius ([email protected]), MySQL AB (http://www.mysql.com/). This software comes with no warranty. Manual page by L. (Kill-9) Pedersen ([email protected]), Mercurmedia Data Model Architect / system developer (http://www.mercurmedia.com)

ATTRIBUTES

See attributes(5) for descriptions of the following attributes:

ATTRIBUTE TYPEATTRIBUTE VALUE
AvailabilitySUNWmysqlr, SUNWmysqlu, SUNWmysqlt
Interface StabilityExternal

NOTES

Source for mysql is available on http://opensolaris.org.
Jump to page    or go to Top of page |  Section 1 |  Main Solaris Index.


MySQL 4.0 mysqlaccess (1) 19 December 2000
Generated by Open Solaris Forum from /usr/share/man/man1/mysqlaccess.1 using man macros with tbl support.