How to connect navicat premium to database IP address

How to connect the database IP address in Navicat Premium

Step 1: Create a new connection

• Open Navicat Premium .
• Click "Connect" > "New Connection".

Step 2: Select the connection type

• In the "Connection type" drop-down list, select the corresponding database type.
• For example, for MySQL, select "MySQL".

Step 3: Enter connection information

• In the Host field, enter the IP address of the database server.
• In the "Port" field, enter the port number of the database server. Typically this is 3306 (MySQL) or 1433 (SQL Server).
• In the Username and Password fields, enter the credentials required to connect to the database.

Step 4: Advanced Options

• As needed, you can configure other connection options under the Advanced tab, for example:

  • Database Name: If you know the specific database you want to connect to, enter a name. Otherwise, leave it blank.
  • Character set: Select a character set that matches the character set used in the database.
  • SSL: Enable this option if you need to use SSL for a secure connection.

Step 5: Test Connection

• Click the "Test Connection" button to verify the connection is successful.
• If the connection is successful, you will see a message: "Connection successful".

Step 6: Save the connection

• Click "OK" to save the connection.
• Your connection will appear in Navicat Premium's connection list, and you can connect to the database at any time by double-clicking the connection.

The above is the detailed content of How to connect navicat premium to database IP address. For more information, please follow other related articles on the PHP Chinese website!