Seth Woolley's Man Viewer

mysql(1) - mysql - text-based client for mysqld, a SQL-based relational database daemon - man 1 mysql

([section] manual, -k keyword, -K [section] search, -f whatis)
man plain no title

mysql(1)                        MySQL database                        mysql(1)



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

USAGE
       mysql [OPTIONS] [Database]

SYNOPSIS
       mysql [-B|--batch] [-#|--debug= logfile] [-T|--debug-info]  [-e|--exec=
       command]     [-f|--force]     [-?|--help]     [-h|--host=     hostname]
       [-n|--unbuffered]  [-p[pwd(1,n,1 builtins)]]   [--password=[pwd(1,n,1 builtins)]]   [-P|--port=   pnum]
       [-q|--quick]  [-r|--raw]  [-s|--silent] [-S|--socket= snum] [-u|--user=
       uname(1,2)] [-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(3,n) 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(1,n,1 builtins)]
              Employ the specified password when connecting  to  the  database
              server.   If  a  password  is not supplied, it will be requested
              interactively.

       -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(3,n) 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(2,7,n) file(1,n) for connecting to the  database
              server.

       -u|--user=uname(1,2)
              Employ the specified user name for logging in(1,8) to the server.

       -v|--verbose
              Verbose mode: write(1,2) more Specifying this option twice produces a
              tabular output format.

       -V|--version
              Print the mysql version(1,3,5) number and exit.

       -w|--wait
              Wait and retry if(3,n) the database server connection is down.

FILES
       /etc/my.cnf           MySQL configuration file(1,n)

       /usr/bin/mysql        Client executable

       /usr/libexec/mysqld   Server executable

       /usr/bin/mysqld_safe  executable  shell  script  for  starting   mysqld
                             safely

       /var/lib/mysql        location of database files

EXAMPLE
       You can also read(2,n,1 builtins) a backup dump file(1,n) back into MySQL with:

       mysql  database < backup-file.sql

SEE ALSO
       isamchk(1),   isamlog(1),   mysqlaccess(1),  mysqladmin(1),  mysqld(1),
       mysqld_multi(1),   mysqld_safe(1),    mysqldump(1),    mysql_fix_privi-
       lege_tables(1), mysqlshow(1), mysql_zap(1), perror(1,3)(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    6.3,    distribution    4.0.21    Michael    (Monty)    Widenius
       (monty@mysql.com), MySQL AB (http://www.mysql.com/) 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).



MySQL 4.0                      19 December 2000                       mysql(1)

References for this manual (incoming links)