Connect MySQL database with Navicat Premium

Navicat Premium is a multi-connection database management tool that allows you to connect at the same time as a single program.

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.

Because the original MySQL database view table corresponding to the trigger is very difficult and not intuitive, so on the Internet to see this dedicated to connect the database tool.

First, the new MySQL connection



Second, the connection method is as follows



iii. Possible errors






You will bind-address this line of comments and then Post from its MySQL service.




If prompted to deny access, then is not enough permissions, this time need to grant access to MYSQK, according to the following code slightly modified.

'test' db_test'@'%'123456';       

Connect MySQL database with Navicat Premium