Navicat Premium uses--navicat to connect to MySQL database

Source: Internet
Author: User

recently, in learning Navicat Premium This third-party software, he is a tripartite database Management software, I used this software to invoke the database on the server during my internship, but I decided to make a careful summary of the software that I had not looked at at the time.

What does it do?

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.

batch jobs for different databases can be scheduled and run at a specified time. Additional features include Import Wizard, Export Wizard, query creation tool, report creation tool, data synchronization, backup, work plan, and more.

That is to say, we can connect to multiple databases at the same time through Navicat Premium, or a database on multiple servers, which is very useful when we work together.

How do I use it?

First, download the software and install it. (This is very simple, online there are a lot of this software, as well as different versions, choose one you like, download use)

Then, open the software and go to the main interface, as shown in, select the database you want to connect to (here is MySQL for example).

Select MySQL and then, fill in the database name and password you want to connect to, test the connection first, and if successful, then modify your input. (for example, connect to a local database, as shown)

Summary:

Macro understanding and understanding, is the first step to use, Navicat is a more practical software. Occupied space is relatively small, practical and convenient, through the navicat to manipulate the speed of the database faster, more perfect function, other advantages, I am still in the excavation ...



Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Navicat Premium uses--navicat to connect to MySQL database

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.