You can test whether the MySQL server is working by executing any of the following commands:
"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqlshow"C:\>
"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqlshow" -u root mysqlC:\>
"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqladmin" version status procC:\>
"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql" test
By default, mysqlshow will try to connect
ODBC user. This user is not
created by default. You should specify a valid user, or
root with the right password to check the
operation of the server.
If mysqld is slow to respond to TCP/IP
connections from client programs, there is probably a problem
with your DNS. In this case, start mysqld
option and use only
localhost and IP
addresses in the
Host column of the MySQL
You can force a MySQL client to use a named-pipe connection
rather than TCP/IP by specifying the
--protocol=PIPE option, or by
. (period) as the host name. Use
--socket option to specify
the name of the pipe if you do not want to use the default pipe
Note that if you have set a password for the
root account, deleted the anonymous account,
or created a new user account, then to connect to the MySQL
server you must use the appropriate
-p options with the commands shown previously.
See Section 4.2.2, “Connecting to the MySQL Server”.
For more information about mysqlshow, see Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”.