Man page or keyword search:   man All Sections 1 - General Commands 2 - System Calls 3 - Subroutines, Functions 4 - Special Files 5 - File Formats 6 - Games and Screensavers 7 - Macros and Conventions 8 - Maintenence Commands 9 - Kernel Interface New Commands Server 4.4BSD AIX Alpinelinux Archlinux Aros BSDOS BSDi Bifrost CentOS Cygwin Darwin Debian DigitalUNIX DragonFly ElementaryOS Fedora FreeBSD Gentoo GhostBSD HP-UX Haiku Hurd IRIX Inferno JazzOS Kali Knoppix LinuxMint MacOSX Mageia Mandriva Manjaro Minix MirBSD NeXTSTEP NetBSD OPENSTEP OSF1 OpenBSD OpenDarwin OpenIndiana OpenMandriva OpenServer OpenSuSE OpenVMS Oracle PC-BSD Peanut Pidora Plan9 QNX Raspbian RedHat Scientific Slackware SmartOS Solaris SuSE SunOS Syllable Tru64 UNIXv7 Ubuntu Ultrix UnixWare Xenix YellowDog aLinux   31559 pages apropos Keyword Search (all sections) Output format html ascii pdf view pdf save postscript

mysqlaccess(1)		  MySQL database	   mysqlaccess(1)

NAME
       mysqlaccess-Createnewuserstomysql.

USAGE
       mysqlaccess [host [user [db]]] OPTIONS

SYNOPSIS
       mysqlaccess  [-?|--help]	 [-v|--version] [-p|--password=#]
       [-h|--host=#] [-d|--db=#] [-U|--superuser=#]  [-P|--spass-
       word=#]	  [-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), mysqld_safe (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.mercurme-
       dia.com)

MySQL 4.0		 19 December 2000	   mysqlaccess(1)

Vote for polarhome