How does navicat connect to other people's databases?

During the project, project team members need to access each other’s databases. Connecting to each other’s Mysql database requires the following steps:

Recommended tutorial: navicat graphic tutorial

0) Prerequisite

The two computers must be on the same network segment ;

1) Query the IP addresses of both parties

Method 1: Open cmd (windows R key), enter ipconfig, and find the IPv4 address;

Method 2: Open the Control Panel - Network and Sharing Information, find the connected network, click to view detailed information, and find the IPv4 address;

2) Create a user (take A to connect B as an example)

Open Navicat in B, click User-New User:

Username: Customized

Host: A’s IP address

Password: Customized

Confirm password: Customized

Server permissions-Select, Insert, etc. all checked

3) Connect user

Open Navicat in A, click Connect-New Connection:

Connection name: Leave it blank

Host name: B’s IP address

Port: 3306

Username: Username defined in B

Password: Password defined in B

4) Test connection

Click to connect If the test is successful, it means the connection is OK.

ps: Take B connecting to A as an example

Create a new user in A and create a new connection in B.

The above is the detailed content of How does navicat connect to other people's databases?. For more information, please follow other related articles on the PHP Chinese website!