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... ...

    • GLOBODOX Server Silent Installation

      Step 1: Create an INF file (This file will store all the wizard settings that you configure when running the manual setup for a Server Machine) Download the GLOBODOX setup on a machine, please don't run the setup yet. The name of GLOBODOX setup ...