Shulou(Shulou.com)05/31 Report--

This article mainly shows you how to use the database management tool Navicat. The content is simple and easy to understand. It is clearly organized. I hope it can help you solve your doubts. Let Xiaobian lead you to study and learn the article "How to use the database management tool Navicat."

Navicat Premium is a powerful third-party database management tool that can connect and manage MySQL, Oracle, PostgreSQL, SQLite and SQL Server databases.

1. Enter the autonomous management platform, click Database Management, and view the details of MYSQL database (use external IP to connect to the database)

2. Enter the autonomous management platform, click Database Management, and view the details of SQLSERVER database.

Connect to MySQL Database:

1. Open navicat software, click "File", select "New Connection", select "MySQL"

2. Fill in the information connected to the database

3. After the database information is completed, click "OK". If the information is filled in correctly, the connection is successful.

4. Import data, right-click "Database Name" and click "Run SQL File"

5. Select sql file, code select "UTF-8","Continue in case of error" Do not check, click "Start"

6. Import succeeded.

Third, connect to the MSSQL database:

1. Open navicat software, click File, select New Connection, select SQL Server

2. Fill in the information connected to the database, as shown in the figure below.

3. After the database information is completed, click "OK". If the information is filled in correctly, the connection is successful.

4. Import data, right-click "Database Name" and click "Run SQL File"

5. Select sql file, code select "UTF-8","Continue in case of error" Do not check, click "Start"

The above is "how to use Navicat database management tool" all the contents of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

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.