Mysql advanced permission check principle and mysql permission Principle

Mysql advanced permission check principle and mysql permission Principle

You can perform database operations in two steps:

1. Whether the connection is permitted. The connection is based on host, name, and password;

2. Are you authorized to perform CURD;

Illustration:

Where can I store user permissions?

As shown in the following figure:

There is a user table in the mysql database:

Just like normal CURD, you can log on to the console!

Note that the permissions in the User table are global,

What if I want to control a table? Remember the db table. This is where it is,

I will not elaborate on it: