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)

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

       mysql [OPTIONS] [Database]

       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]

       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.

              Print results with a tab as separator, each row on a new line.

              Employ the specified debug log.

              Print debug information upon exiting.

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

              Continue even if(3,n) the face of a SQL error.

              Display a help message and exit.

              Connect to the specified host.

              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

              Employ the specified port number for connecting to the  database

              Do  not  cache  the  result; print it row by row.  This may slow
              down the server if(3,n) the output is suspended.

              Write fields without conversion.  (used with --batch).

              Silent mode: reduce the amount of output.

              Employ the specified socket(2,7,n) file(1,n) for connecting to the  database

              Employ the specified user name for logging in(1,8) to the server.

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

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

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

       /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

       /var/lib/mysql        location of database files

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

       mysql  database < backup-file.sql

       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

       Please refer to to report bugs.

       Ver    6.3,    distribution    4.0.21    Michael    (Monty)    Widenius
       (, MySQL AB ( 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 (

MySQL 4.0                      19 December 2000                       mysql(1)

References for this manual (incoming links)