Heidis QL usage (MySQL database management tool)

Time:2021-9-14

Heidis QL is a free and open source graphical interface for simplified MySQL server management and database management. The efficiency is no worse than the charged MySQL management software. Compared with phpMyAdmin, it does not need PHP support. The import and export of large files will not fake death, and it is also very lightweight!

Here is a brief introduction to how to use heidis QL to create a database, create new users and grant permissions.

1、 Download and install

To http://www.heidisql.com/download.php , download the latest32+64bit installerAnd install. The installation is simple without any complications.

Software name:
Heidisql v9.5.0.5196 green version simplifies the graphical interface of MySQL server and database management
Software size:
4.53MB
Update time:
2019-04-03Download now

Software name:
Heidisql (MySQL graphical interface tool) v11.0.0.6081 32 + 64 installation
Software size:
18.6MB
Update time:
2020-08-11Download now

In fact, when installing MariaDB, you can also choose to install a third-party management tool at the same time, that is, heidis QL.

2、 Connect to database

1. Clicknewly build
请输入图片描述
2. After naming the session, set the host IP (127.0.0.1 if it is local, or enter the external IP if it is external); Fill in the account secret; The default port is3306。 Then clickpreservationThat is, save the connection information and account secret. clickopenIs to open this session.
请输入图片描述
3. This is the case after logging in.
请输入图片描述

3、 Create a new database

staySession name: unnamed——Right click——Create a new —— database
请输入图片描述

Enter the database name. The sorting rule is half the default. It is determined according to the requirements of your web software program
请输入图片描述

4、 Add a new account

It is very dangerous to use root as the account of the website database. Here we create an account that only has permissions on the corresponding database.

1. Click on the menuTwo person Icon —— add to——Enter the user name and password of the new user——Add object

请输入图片描述

2. Select the corresponding database

请输入图片描述

3. Tick this database and give control permission to this database.

请输入图片描述

4. Then you can go back to step 1 and log in with the new account to see ~ ~