MARIADB Database Management System Learning (ii) graphical interface management tools using the Heidisql database

Source: Internet
Author: User
Tags heidisql

Heidisql is a graphical interface for simplifying MySQL server and database management. The software agrees to browse your database, manage tables, browse and edit records, manage user permissions, and more. In addition, you can import data from a text file, execute SQL queries, synchronize tables between two databases, and export selected tables to other databases or SQL scripts. Heidisql provides a simple and easy-to-use interface for switching SQL queries between database views and labels with syntax highlighting. Other features include Blob and MEMO editing, large SQL script Support, user process management, and more. The software is open to resources.

After the MARIADB is successfully installed, it appears on the desktop with the following label:

Double-click the Execute HEIDISQL Database graphical interface management tool


Create a data connection session

New "Create Session in Root category


To connect to the mariadb you just installed, click on the session name unnamed change to localhost, enter the root user Password,port set to 3308, open


Save your changes and click "Yes"


Create a data table

Right-click on the appropriate database to create a new table


Enter the data table name, stare, the following fields, you need to first click "Join?" button to add? field, first Field "userid", data type set to bigint, click Default Value column, where you can set your own active number


Save data table, prompt for no primary key


Set the primary key, right-click on the UserID field row, create a new index PRIMARY, create the Index management tab


Click Save again to create the data table successfully.

MARIADB Database Management System Learning (ii) graphical interface management tools using the Heidisql database

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.