How to use Navicat for MySQL

MySQL database management tool navicat for MySQL

• 7

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, briefly explain how to use Navicat for MySQL management connection MySQL

2. 1

   download and install software

   use navicate for mysl  Before course first download the software, you can search by Baidu  navicate  special attention, please look for Baidu Security certification best to the official website, or the regular software download station download

   650) this.width=650; "Class=" Exp-image-default "alt=" MySQL database management tool navicat for MySQL how to use? "Src=" https://imgsa.baidu.com/exp/w=500/sign=70456a15d5ca7bcb7d7bc72f8e086b3f/ Cb8065380cd791239596c7a2af345982b3b780f5.jpg "style=" border:0px; "/>

4. 2

   after downloading the software, Install Navicat for mysql (Note the plugin's custom selection between the installation process)

   650) this.width=650; "class=" Exp-image-default "alt=" MySQL database management tool navicat for MySQL how to use? "Src=" https://imgsa.baidu.com/exp/w=500/sign=e1023a8636a85edffa8cfe23795509d8/ F9dcd100baa1cd112fb821f6bb12c8fcc2ce2ddd.jpg "style=" border:0px; "/>

   650) this.width=650; "class=" Exp-image-default "alt=" MySQL database management tool navicat for MySQL how do I use it? "Src=" https://imgsa.baidu.com/exp/w=500/sign=65d0b7a5af4bd11304cdb7326aaea488/ B21c8701a18b87d68a3af8c9050828381e30fde8.jpg "style=" border:0px; "/>

6. How does Navicat for MySQL work?

   Connecting to a database

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

   650) this.width=650; "class=" Exp-image-default "alt=" MySQL database management tool navicat for MySQL how to use? "Src=" https://imgsa.baidu.com/exp/w=500/sign=7036531ce4cd7b89e96c3a833f254291/ B21bb051f8198618924bbc5248ed2e738ad4e6dc.jpg "style=" border:0px; "/>

7. Connection parameter filling

   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

   650) this.width=650; "class=" Exp-image-default "alt=" MySQL database management tool navicat for MySQL how to use? "Src=" https://imgsa.baidu.com/exp/w=500/sign=98dc489589d4b31cf03c94bbb7d7276f/ 42166d224f4a20a494126f1192529822730ed0dc.jpg "style=" border:0px; "/>

9. connection appears "Connection succeeded" setting succeeded

   650) this.width=650; "class=" Exp-image-default "alt=" MySQL database management tool navicat for MySQL how to use? "Src=" https://imgsa.baidu.com/exp/w=500/sign=7f5fd6b7fa1986184147ef847aec2e69/ 503d269759ee3d6d99bfd41d41166d224e4adeef.jpg "style=" border:0px; "/>

11. Database management

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

    650) this.width=650; "class=" Exp-image-default "alt=" MySQL database management tool navicat for MySQL how to use? "Src=" Https://imgsa.baidu.com/exp/w=500/sign=049fad0974094b36db921bed93cd7c00/ Bd315c6034a85edfb883adf54b540923dc5475dc.jpg "style=" border:0px; "/>

13. add Delete database

    650) this.width=650; "class=" Exp-image-default "alt=" MySQL database management tool navicat for MySQL how to use? "Src=" https://imgsa.baidu.com/exp/w=500/sign=dde29bf94334970a4773102fa5cbd1c0/ 38dbb6fd5266d0167c15cdfe952bd40734fa35d3.jpg "style=" border:0px; "/>

15. add Delete table

     

    for new tables, both names and types can be manually entered for the specified selection. After Setup, click Save Input Table name to complete the operation

    650) this.width=650; "class=" Exp-image-default "alt=" MySQL database management tool navicat for How does MySQL work? "Src=" https://imgsa.baidu.com/exp/w=500/sign=a0fb0a67820a19d8cb03840503fb82c9/ A5c27d1ed21b0ef47791cb88dfc451da80cb3eee.jpg "style=" border:0px; "/>

17. Click on the added table, or the database table. Double-clicking on the right will list the current table's detailed column items and properties

    650) this.width=650; "class=" Exp-image-default "alt=" MySQL database management tool navicat for MySQL how to use? "Src=" https://imgsa.baidu.com/exp/w=500/sign=9db76c3760d9f2d3201124ef99ed8a53/ Eaf81a4c510fd9f9316906bf272dd42a2934a4ee.jpg "style=" border:0px; "/>

19. how to use the command line

    Tools--Command column interface such as arrow position

    650) this.width=650; "class=" Exp-image-default "alt=" MySQL database management tool navicat for MySQL how to use? "Src=" https://imgsa.baidu.com/exp/w=500/sign=40fd1d6f9c510fb378197797e932c893/ F9198618367adab4ecdd489589d4b31c8601e4d3.jpg "style=" border:0px; "/>

21.    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 to

    650) this.width=650; "class=" Exp-image-default "alt=" MySQL database management tool navicat for MySQL how to use? "Src=" https://imgsa.baidu.com/exp/w=500/sign=07f2b3848735e5dd902ca5df46c7a7f5/ Bd3eb13533fa828bee2ece35ff1f4134960a5ad2.jpg "style=" border:0px; "/>

23. Other features

    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

    650) this.width=650; "class=" Exp-image-default "alt=" MySQL database management tool navicat for MySQL how to use? "Src=" https://imgsa.baidu.com/exp/w=500/sign=2a7b6fc5df54564ee565e43983df9cde/ B812c8fcc3cec3fd9f2cf4a3d488d43f869427d1.jpg "style=" border:0px; "/>

25. 
    

This article from "Sunshine Honey Juice" blog, reproduced please contact the author!

How to use Navicat for MySQL