If you encounter difficulties during installation, see Section 2.3.5, “Troubleshooting a Microsoft Windows MySQL Server Installation” . 

For more information about stopping or removing a Windows service, see Section 5.8.2.2, “Starting Multiple MySQL Instances as Windows Services” . 

## 2.3.4.9 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 8.0\bin\mysqlshow" C:\> "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqlshow" -u root mysql C:\> "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqladmin" version status proc C:\> "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql" 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 mysqld  with the skip_name_resolve  system variable enabled and use only localhost  and IP addresses in the Host  column of the MySQL grant tables. (Be sure that an account exists that specifies an IP address or you may not be able to connect.) 

You can force a MySQL client to use a named-pipe connection rather than TCP/IP by specifying the -- pipe  or --protocol=PIPE  option, or by specifying .  (period) as the host name. Use the --socket option to specify the name of the pipe if you do not want to use the default pipe name. 

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 -u  and -p  options with the commands shown previously. See Section 4.2.4, “Connecting to the MySQL Server Using Command Options” . 

For more information about mysqlshow , see Section 4.5.7, “mysqlshow — Display Database, Table, and Column Information” . 

## 2.3.5 Troubleshooting a Microsoft Windows MySQL Server Installation 

When installing and running MySQL for the first time, you may encounter certain errors that prevent the MySQL server from starting. This section helps you diagnose and correct some of these errors. 

Your first resource when troubleshooting server issues is the error log. The MySQL server uses the error log to record information relevant to the error that prevents the server from starting. The error log is located in the data directory specified in your my.ini  file. The default data directory location is C:\Program Files\MySQL\MySQL Server 8.0\data , or C:\ProgramData\Mysql  on Windows 7 and Windows Server 2008. The C:\ProgramData  directory is hidden by default. You need to change your folder options to see the directory and contents. For more information on the error log and understanding the content, see Section 5.4.2, “The Error Log” . 

For information regarding possible errors, also consult the console messages displayed when the MySQL service is starting. Use the SC START mysqld_service_name  or NET START mysqld_service_name  command from the command line after installing mysqld  as a service to see any error messages regarding the starting of the MySQL server as a service. See Section 2.3.4.8, “Starting MySQL as a Windows Service” . 

The following examples show other common error messages you might encounter when installing MySQL and starting the server for the first time: 

•If the MySQL server cannot find the mysql  privileges database or other critical files, it displays these messages: 

System error 1067 has occurred. 

