I installed MySQL on Microsoft Windows 8 Using a noinstall Zip Archive. But when I tested by executing the following commands on windows prompt, the above error showed up.
C:\> "C:\MySQL\bin\mysqlshow" C:\> "C:\MySQL\bin\mysql" test
The error (2003) Can't connect to MySQL server on ' server ' (10061) indicates that the network connection has been refused. You should check that there is a MySQL server running, that it has network connections enabled, and that the network port you specified is the one configured on the server.
normally means that there is no MySQL server running on the system or that you are using an incorrect Unix socket file name or TCP/IP port number when trying to connect to the server. You should also check that the TCP/IP port you are using has not been blocked by a firewall or port blocking service.
The error above means that your request to connect to the MySQL server has been refused. There are two things you need to check to fix this error: Make sure that your MySQL service is actually running. Check that you are attempting to connect to the right port number.
You don't need to restart your windows. The easiest way to achieve this is
<Extracted folder location>/bin/
mysqld
(service)mysql.exe
or the better way to do is add the location to PATH environment VariableIf you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With