MySQL database management tool navicat for MySQL

MySQL database management tool navicat for MySQL, not much like the graphical interface or inconvenient to use SQL. We can use this graphical interface database management tool to manage MySQL, this experience Nithya to briefly explain how to use navicat for MySQL management connection MySQL database

1.Navicat for MySQL how to use?

Connecting to a database

After opening navicat for MySQL, file----New connection

2. Fill in the connection parameters

In the connection settings that appear, there are many options for account information for the database that needs to be connected

Connection Name : can be filled in any, easy to identify and differentiate later

hostname or IP: fill in the hostname of the server (must be resolvable) or the server IP address, if this machine can fill localhost or 127.0.0.1

Port : Default is 3306 If you modify a different port, you need the corresponding

Password : Is the user name root password or other MySQL user's password

3. After setting the parameters of the connection database, click "Connect"below, the "connection is successful" is set to succeed

4. Database Management

Once the database is connected, the current MySQL database is displayed on the left. Click on the corresponding database to view the table below the current database

5. Add Delete Database

If you need to add the deletion of the database, it is very simple to select the database to operate, the right mouse button to select the operation can

　　

6. Adding a Delete table

Also for the table below the database, if you want to create new words, click Select Table---New

For new tables, both the name and the type can be manually entered for the specified selection. Once set, click Save Input Table name to complete the operation.

7. How to use the command line

Although it is a graphical management tool, it is more convenient for many operations to actually require SQL commands.

Go to the SQL command line interface and click on " Tools"-"Command Column Interface".

Then in the lower right blank area into the SQL command line interface, the operation method and normal access to the MySQL command line interface like the use of commands.

If you need to clear the current screen content, you can click "Clear ".

8. Other functions

For SQL files that were previously exported by the database, or for SQL command statements that were written. You can "Run SQL Files" by selecting the database you want to import or the table right-click option

MySQL database management tool navicat for MySQL