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

Heidisql is a graphical interface for simplifying MySQL server and database management. The software allows you 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, run 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.

MARIADB the installation succeeds, it appears on the desktop with the following label:

Double-click the run HEIDISQL Database graphical interface management tool

Create a data connection session

New "Create Session in Root category

To connect to the last mariadb you just installed, click 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 corresponding database to create a new table

Enter the data table name, comments, the following fields, you need to click the "Add" button to increase the field, the first field "UserID", the data type is set to bigint, click the default Value column, here you can set the automatic numbering

Save data table, prompt for no primary key

Set the primary key, right-click on the UserID field row, create new index PRIMARY, create complete before Discovering index management tab

Click Save again to create the data table successfully.