DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) Windows testing

Info Catalog (mysql.info.gz) Windows start service (mysql.info.gz) Windows installation (mysql.info.gz) Windows troubleshooting
 
 2.3.13 Testing The MySQL Installation
 -------------------------------------
 
 You can test whether the MySQL server is working by executing any of the
 following commands:
 
      C:\> C:\mysql\bin\mysqlshow
      C:\> C:\mysql\bin\mysqlshow -u root mysql
      C:\> C:\mysql\bin\mysqladmin version status proc
      C:\> C:\mysql\bin\mysql test
 
 If `mysqld' is slow to respond to TCP/IP connections from client
 programs on Windows 9x/Me, there is probably a problem with your DNS.
 In this case, start `mysqld' with the `--skip-name-resolve' option and
 use only `localhost' and IP numbers in the `Host' column of the MySQL
 grant tables.
 
 You can force a MySQL client to use a named pipe connection rather than
 TCP/IP by specifying the `--pipe' option or by specifying `.' (period)
 as the host name.  Use the `--socket' option to specify the name of the
 pipe.  As of MySQL 4.1, you should use the `--protocol=PIPE' option.
 
 There are two versions of the MySQL command-line tool:
 *Binary*       *Description*
 `mysql'        Compiled on native Windows, offering limited text editing
                capabilities.
 `mysqlc'       Compiled with the Cygnus GNU compiler and libraries,
                which offers `readline' editing. `mysqlc' was intended
                for use primarily with Windows 9x/Me. It does not support
                the updated authentication protocol used beginning with
                MySQL 4.1, and is not supported in MySQL 4.1 and above.
                Beginning with MySQL 4.1.8, it is no longer included in
                MySQL Windows distributions.
 
 If you want to use `mysqlc', you must have a copy of the
 `cygwinb19.dll' library installed somewhere that `mysqlc' can find it.
 Current distributions of MySQL include this library in the same
 directory as `mysqlc' (the `bin' directory under the base directory of
 your MySQL installation). If your distribution does not have the
 `cygwinb19.dll' library in the `bin' directory, look for it in the
 `lib' directory and copy it to your Windows system directory
 (`\Windows\system' or a similar place).
 
Info Catalog (mysql.info.gz) Windows start service (mysql.info.gz) Windows installation (mysql.info.gz) Windows troubleshooting
automatically generated byinfo2html