Database administration Tools Navicat installation and use tutorial __ database

Navicat-Database management tools

First, Introduction

"1"Navicat is a powerful Visual database management tool for developing and managing databases such as Mysql,oracle,sql Server,sqlite

"2"Navicat Premium is a Mac database management tool, connect this tool to the database, you can see the details of various databases

"3" official website: https://www.navicat.com

second, the installation

Reference Link: https://www.navicat.com/download/navicat-for-mysql

Iii. Use of the tutorial (MAC)

"1" database Connection (MySQL): The connection name casually fills in, the IP address, the port number, the user names have the corresponding default value

"2" New database: connection name right key, you can create a database

"3" new table: table Right key, can create datasheet

Table right, you can choose "Design Table"

"4" set character encoding: You can set the character encoding in an option

"5" Query Editor: two ways to access the Query Editor

To enter the query Editor, you can edit and execute the SQL statement

"6" Reference link

http://www.jianshu.com/p/326c1aaa1052

http://www.weiruoyu.cn/?p=175