79625

Testing The MySQL Installation

You can test whether the MySQL server is working by executing any of the following commands:

C:\>"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqlshow"

C:\>"C:\Program Files\MySQL\MySQL Server 5.6\bin\raysqlshow" -u root mysql

C:\>"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqladmin" version status proc

C:\>"C:\Program Files\MySQL\MySQL Server 5.6\bin\raysql" test

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 mysąld with the —skip-name-resolve [454] option and use

only localhost and IP addresses 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 --

pipę [221] or --protocol=PIPE [221] option, or by specifying . (period) as the host name. Use

the —socket [221] option to specify the name of the pipę if you do not

want to use the default pipę

name.

Notę that if you have set a password for the root account, deleted the anonymous account, or created

a new user account, then you must use the appropriate -u and -p options with the commands shown

above to connect with the MySQL Server. See Section 4.2.2, “Connecting to the MySQL Sewer”.

For morę information about mysqlshow, see Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”.