Help Desk

            MySQL : 004 : Can't connect to MySQL server

            Error:
                  
                  Message:
                  Failed to connect to database 'MainDB'. (ErrNo:-2147467259
                  Details:[MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '(machinename)/(ipaddress)' (10060))

            Cause:

            The error message indicates that GLOBODOX is unable to connect to MySQL. 

            Solution:

            Step 1: 

            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.

            Click here to install the correct ODBC driver.


            If none of the above works, please drop an email to support@globodox.com
            Updated: 14 Feb 2017 05:59 PM
            Helpful?  
            Help us to make this article better
            0 0