Navicat How to connect MySQL? Navicat connection MySQL detailed graphics and text tutorial

The latest version of Navicat for MySQL, with its own registration code. has been green, extracted to any directory can be run.

Navicat Premium is a reusable database management tool that enables you to connect to MySQL, Oracle, PostgreSQL, SQLite, and SQL Server databases 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 the 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.

　　Navicat for MySQL:

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

Click or select File-> New connection to set connection properties.

Connection settings

After you create the connection, you can connect to the database, manage its objects, the data in the table, and so on. See the help below to find out how to run these operations in the simplest way.

Working with databases or schemas

Working with a database or schema object Navicat Browser!

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

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

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

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

　　Navicat How to connect to MySQL:

1. First, you must have a MySQL database installed on your computer. (If you do not know if you have successfully installed MySQL, you can enter "MySQL" In the Start menu, search)

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

3, open a stand-alone toolbar on the left of the first ' connection ', into the connection page.

4, the most important step: Open the interface has five boxes to enter, the first: Connection name needs to enter the name of your new connection, where we will be named ' Local ', the second:

Host NAME/IP address you need to enter your local Ip addresses or direct input ' localhost ', here we choose the second. The third: port, enter your installation time of the port number, generally the default of 3306; the fourth and fifth are: username and password, meaning that you need to enter your database name username and password, my username is: root, Password: (Confidential, hehe). Finally, put the following ' Save passwod ' small box on the hook.

5, complete the above steps, and then click on the lower left corner of a ' Test connectiion ' If the pop-up success, congratulations to you directly click on the lower right corner of the ' Save ' button on it. If you eject the error, you will need to look again at where you filled out the wrong one.

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

I use the English version of Navicat, but the Chinese version is also similar.