Make sure the MySQL port is opened in Windows Firewall on the machine on which MySQL is installed.
To open a port...
- Press the Windows + R button. The Run dialog will be launched.
- In the Open: textbox, type wf.msc
- Click OK. The 'Windows Firewall with Advanced Security' dialog will be launched.
- In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane.
- In the Rule Type dialog box, select Port, and then click Next.
- In the Protocol and Ports dialog box, select TCP. Select Specific local ports, and then type the port number of MySQL (by default 3306) . Click Next.
- In the Action dialog box, select Allow the connection, and then click Next.
- In the Profile
dialog box, select any profiles that describe the computer connection
environment when you want to connect to MySQL, and then
click Next.
- In the Name dialog box, type a name and description for this rule, and then click Finish.
That's it!
If the above still does not work, proceed to Step 2.
Step 2:
Make sure the root user has permission to access MySQL from any Client machine.
To do this...
- On the machine on which MySQL is installed, start MySQL Command Line Client.
- Enter the password for the root user.
- Type the following command...
grant all on *.* to 'root'@'%' identified by 'password';
(Replace password with the password of the root user.)
That's it!
If the above still does not work, proceed to Step 3.
Step 3:
Make sure the correct ODBC driver is installed on the machine on which you receive the error.