Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for MariaDB, Navicat Premium

Apply Navicat Version No.: All

 

MySQL & MariaDB

The reasons for not connecting to your server successfully may involve few aspects. We would suggest you to check the following issues:

1. Do you have the correct hostname of your server?
2. Are you using the correct TCP/IP port number when trying to connect to the server? (The default port number for mysql is 3306.)
3. Are you behind any firewall that blocks the port number?
4. Is your public IP address of your desktop PC changed by your ISP recently?

We would like to remind you that after server is installed, it would only allow "localhost" connection by default. Any client PCs will be blocked by the remote server until the user privileges has been configured.

If you are using server provided by hosting company, most of the hosting companies will block access to the server from outside the hosting company's network, and only grant access to users connecting from localhost. For this case, you will need to configure SSH Tunnel Connection to solve the problem.

MySQL Testing Account:

We offer a testing account for you to evaluate Navicat more easily. Navicat remote connection setting for testing account:

(Please note that this account only allows Select privilege)

Connection name: server1.navicat.com

Host address: server1.navicat.com

Username: navicat

Password: testnavicat

Port number: 4406

 

PostgreSQL

The reasons for not connecting to your PostgreSQL server successfully may involve few aspects. We would suggest you to check the following issues:

1. Do you have the correct hostname of your PostgreSQL server?
2. Are you using the correct TCP/IP port number when trying to connect to the PostgreSQL server? (The default port number for PostgreSQL is 5432.)
3. Are you behind any firewall that blocks the port number?
4. Is your public IP address of your desktop PC changed by your ISP recently?

Navicat only supports PostgreSQL 7.3 or above.

Please enable remote connections function while installation or configure postgresql.conf for setting remote access.

PostgreSQL Testing Account:

We offer a testing account for you to evaluate Navicat more easily. Navicat remote connection setting for testing account:

(Please note that this account only allows Select privilege)

Connection name: server1.navicat.com

Host address: server1.navicat.com

Username: navicat

Password: testnavicat

Port number: 5432

Initial Database: HR

 

Oracle

The reasons for not connecting to your Oracle server successfully may involve few aspects. We would suggest you to check the following issues:

1. Did you install the correct Instant Client version and set the correct path in Navicat?
2. Do you have the correct hostname of your Oracle server?
3. Are you using the correct TCP/IP port number when trying to connect to the Oracle server?
4. Are you behind any firewall that blocks the port number?
5. Is your public IP address of your desktop PC changed by your ISP recently?

Navicat only supports Oracle 8.1 or above.