How to use Navicat for MySQL

Source: Internet
Author: User
Tags mysql command line

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

  1. 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; "/>

  2. 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; "/>

  3. 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; "/>

  4. 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; "/>

  5. 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; "/>

  6. 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; "/>

  7. 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; "/>

  8. 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; "/>

  9. 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; "/>

  10. 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; "/>

  11.    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; "/>

  12. 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; "/>



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

How to use Navicat for MySQL

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.