mysql(1) [redhat man page]

MYSQL(1)						      General Commands Manual							  MYSQL(1)

NAME

       mysql - text-based client for mysqld, a SQL-based relational database daemon

SYNOPSIS

       mysql   [-B|--batch]   [-#|--debug=   logfile]  [-T|--debug-info]  [-e|--exec=  command]  [-f|--force]  [-?|--help]  [-h|--host=  hostname]
       [-n|--unbuffered] [-p[pwd]] [--password=[pwd]] [-P|--port= pnum] [-q|--quick]  [-r|--raw]  [-s|--silent]  [-S|--socket=	snum]  [-u|--user=
       uname] [-v|--verbose] [-V|--version] [-w|--wait]

DESCRIPTION

       The  mysql  program provides a curses-based interface to the SQL-based database server daemon, mysqld(1).  Full fuller documentation, refer
       to the HTML documents installed with the package.

OPTIONS

       -B|--batch
	      Print results with a tab as separator, each row on a new line.

       -#|--debug=logfile
	      Employ the specified debug log.

       -T|--debug-info
	      Print debug information upon exiting.

       -e | --exec=command
	      Execute the specified command and quit (--batch is implicit).

       -f|--force
	      Continue even if the face of a SQL error.

       -?|--help
	      Display a help message and exit.

       -h|--host=hostname
	      Connect to the specified host.

       -n|--unbuffered
	      Flush the buffer after each query.

       -p|--password[=pwd]
	      Employ the specified password when connecting to the database server.  If a password is not supplied, it will be requested  interac-
	      tively.

       -P|--port=pnum
	      Employ the specified port number for connecting to the database server.

       -q|--quick
	      Do not cache the result; print it row by row.  This may slow down the server if the output is suspended.

       -r|--raw
	      Write fields without conversion.	(used with --batch).

       -s|--silent
	      Silent mode: reduce the amount of output.

       -S|--socket=snum
	      Employ the specified socket file for connecting to the database server.

       -u|--user=uname
	      Employ the specified user name for logging in to the server.

       -v|--verbose
	      Verbose mode: write more Specifying this option twice produces a tabular output format.

       -V|--version
	      Print the mysql version number and exit.

       -w|--wait
	      Wait and retry if the database server connection is down.

FILES

       /depot/bin/mysql      executable

       /depot/bin/mysqld     executable

       /depot/bin/safe_mysqld
			     executable shell script for starting mysqld safely

       /site/var/mysql/data  location of database files

EXAMPLE

       You can also read a backup dump file back into MySQL with:

       mysql  database < backup-file.sql

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 6.3, distribution 3.20.20 Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se).  This software comes with no
       warranty.   Manual  page  by  R. P. C. Rodgers, Lister Hill National Center for Biomedical Communication, U.S. National Library of Medicine
       (rodgers@nlm.nih.gov).

								   13 June 1997 							  MYSQL(1)

Check Out this Related Man Page

MYSQLACCESS(1)						      General Commands Manual						    MYSQLACCESS(1)

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 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), safe_mysqld (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.mer-
       curmedia.com)

								 19 December 2000						    MYSQLACCESS(1)

Linux and UNIX Man Pages

mysql(1) [redhat man page]

Check Out this Related Man Page