Use commands to test whether the MySQL server works properly _ MySQL

How can I test MySQL installation?

A: You can run the following command to test whether the MySQL server works:

C:/> C:/Program Files/MySQL Server 5.1/bin/mysqlshowC:/> C:/Program

Files/MySQL Server 5.1/bin/mysqlshow-u root mysqlC:/> C:/Program

Files/MySQL Server 5.1/bin/mysqladmin version status procC:/> C:/Program

Files/MySQL Server 5.1/bin/mysql test

If mysqld responds slowly to the TCP/IP connection of the client program, it may be a DNS problem. In this case, use the -- skip-name-resolve option to start mysqld, and only use localhost and IP number in the Host column of the MySQL authorization table.

You can use the -- pipe or -- protocol = PIPE option to force the MySQL client to use the named pipe connection instead of the TCP/IP connection, or specify. (stage) as the host name. Use the -- socket option to specify the pipe name.