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.
Related Articles
MySQL: 001 : Unknown MySQL server host 'Server_Name'
Causes : The error indicates that the logged in Windows user does not have permission to connect to MySQL. This could be due to restricted or limited access on MySQL. Solution : You will have to provide permissions for the MySQL root user, as this ...
Migrate v10 Globodox MySQL DB
Step 1: Backup DB on old machine Follow instructions from the link below to take a backup of the MySQL DB... https://www.globodox.com/support/help/index.htm?backup_a_mysql_based_db.htm Note: Make sure you take a backup of all the DBs. Make sure you ...
MySQL: 002 : Repair corrupted MySQL DB
Repairing a MySQL DB from Windows Command Line Step 1: Open the Windows Command Line - Go to Start >> and Search for 'cmd'. Click on 'Command Prompt' once the Search results show up. You can alternatively type in (Windows + R) to open the Run Dialog ...
Connection to the server failed
Cause: GLOBODOX cannot connect to the server installation. There could be many reasons for this, you can follow the below steps to fix this issue. Step 1: If your Operating System language is not English... Go to C:\ProgramData\ITAZ\Globodox\Web ...
ODBC drivers for MySQL based DB
If you are using GLOBODOX v9 or below... Please download the ODBC connector for MySQL from the link below... https://downloads.mysql.com/archives/get/p/10/file/mysql-connector-odbc-5.1.4-win32.msi Run the msi file on all the machines on which ...