Shulou(Shulou.com)06/01 Report--

This article is about how navicat connects to other people's databases. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

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

0) prerequisites

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 share information, find the connected network, click to view details, and find the IPv4 address

2) establish users (take A connection B as an example)

Open Navicat in B and click user-New user:

User name: customizin

Host: IP address of A

Secret codes: customizin

Confirm password: customizin

Server permissions-check all Select, Insert, etc.

3) connect users

Open Navicat in An and click Connect-New connection:

Connection name: not filled in

Hostname: IP address of B

Port: 3306

User name: user name defined in B

Password: password defined in B

4) Test connection

Click on the connection test, if it is successful, it means that you are connected to OK.

Ps: take B connection An as an example

Create a new user in An and a new connection in B.

Thank you for reading! This is the end of the article on "how to connect navicat to other people's databases". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.