MySQL Database management tool (Navicat for MySQL)

Navicat Premium is a multi-connection database management tool that allows you to connect to MySQL, Oracle, PostgreSQL, SQLite, and SQL Server databases at the same time with a single program, making it easier to manage different types of databases. Navicat Premium combines the functionality of other NAVICAT members. With the connectivity capabilities of different database types, Navicat Premium supports the transfer of data between MySQL, Oracle, PostgreSQL, SQLite, and SQL Server. It supports most of the features of MySQL, Oracle, PostgreSQL, SQLite, and SQL Server.

Navicat Premium enables you to easily and quickly transfer data between various database systems, or to transfer a plain text file that specifies SQL format and encoding. This simplifies the process of migrating data from one server to another type of server. batch jobs for different databases can also be scheduled and run at a specified time.

PC Official version

Navicat for PostgreSQL11.2.16 official Chinese version SQLite database management (Navicat for SQLite) V11.2.15.0 Chinese installation version

Navicat for MySQL:

Navicat for MySQL is a set of high-performance database management and development tools designed for MySQL. It can be used with any version 3.21 or more MySQL database server, and support most of the latest MySQL version of the features, including triggers, stored procedures, functions, events, views, administrative users and so on.

Tap or select File--New connection to set the connection properties.
Connection settings
After you create the connection, you can connect to the database, manage its objects, data in the table, and so on. Take a look at the help below to learn how to run these operations in the simplest way.

Working with databases or schemas

Work with database or schema objects Navicat Browser!

The Navicat window includes a navigation pane (the left pane) and an Object pane (the right pane).

Navigation Pane One is the basic way to navigate connections, databases, and database objects. It is a tree-like structure that allows you to use the database and its objects quickly and easily through pop-up menus.

The object pane displays open tables, queries, and so on. The toolbar at the top of the window provides additional controls that you can use to manipulate your data.

share some of the Navicat tips below to help those who get started getting familiar with the software as soon as possible. Write today Navicat How to connect to the local MySQL database.

Navicat How to connect to MySQL:

1. First of all, you must have MySQL database installed on your computer. (If you are not sure if you have successfully installed MySQL, you can enter "MySQL" In the Start menu to search)

2. Open your navicat for Mysql (you can also use the above method, enter ' Navicat ' in the Start menu search box)

3. Open the first "connection" on the left side of the toolbar to enter the Connection page.

4, the most important step: Open the interface has five boxes need to input, the first: Connection name needs to enter the name of your new connection, here we name ' local ', the second one:

Host NAME/IP address you need to enter the Ip addresses of your native or direct input ' localhost ', here we choose the second type. The third: port, enter your installation time port number, generally default 3306, fourth and fifth are: username and password, meaning you need to enter your database name username and password, my username is: root, Password: (Confidential, hey). Finally, put the "Save Passwod" in the small box to tick.

5, complete the above steps, and then click on the bottom left corner there is a ' Test connectiion ' if pop-up success, congratulations you directly click on the bottom right corner of the ' Save ' button on it. If the error pops up, you'll need to re-examine where you've filled in the wrong.

6, click ' Save ', you can double-click "Local" (Here is the ' local ' is the connection Name you just entered), and then open your database.

I use the English version of Navicat, but the Chinese version of the same.

Software Tags: navicat mysql database

Registration code: NAVH-WK6A-DMVK-DKW3

Name and organization not required

SoftwarePro If you think Sissy can bring you help, please help CC give a praise under Thank you:)Last one, next one.(1/ 2) Installation details

MySQL Database management tool (Navicat for MySQL)