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