MySQL: 001 : Unknown MySQL server host 'Server_Name'

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 will allow GLOBODOX machines to access the MySQL DB.

- On the machine on which MySQL is installed, start MySQL Command Line Client from Start >> MySQL >> MySQL Command Line Client.
- Type in the password for root user, once the MySQL command window launch.
- At the cursor, type Grant all on *.* to 'root'@'%' identified by 'password';
      Replace password with the password of the root user.
Note: Also make sure that the port 3306 is opened in the Windows Firewall

- Press Enter. The above query will be executed with a confirmation message.

- Now, again at the cursor type Flush Privileges; and press Enter.

You can close the MySQL Command line window and then access GLOBODOX.

    • Related Articles

    • 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 ...
    • 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 ...
    • 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: 003 : Data source name not found and no default driver specified

       Cause:  The compatible  MySQL ODBC driver is not installed on the machine.  Solution:  If you are using GLOBODOX v9 or below... Please download the ODBC connector for MySQL from the link below... ...
    • Find if your GLOBODOX DB is MS Access based, MySQL Server based or MS SQL Server based

      Start GLOBODOX and go to Settings Click on DB List under System Settings Under the column name Type, you will find the type of DB (please refer to the screenshot below) That's it!