Easy to know how to test MySQL installation Q: How to test MySQL installation?
A: run the following command to test whether the MySQL server is working:
C:> C: Program FilesMySQLMySQL Server 5.1 inmysqlshowC:> C: Program
FilesMySQLMySQL Server 5.1 inmysqlshow-u root mysqlC:> C: Program
FilesMySQLMySQL Server 5.1 inmysqladmin version status procC:> C: Program
FilesMySQLMySQL Server 5.1 inmysql 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.