MySQL Database management tool (Navicat for MySQL)

Source: Internet
Author: User
Tags mysql version postgresql sqlite database

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)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.