MySQL Advanced permissions Check principle

There are two steps for a user to perform a database operation:

1 whether there is permission to connect, according to Host,name,password;

2 whether there is permission to curd;

Illustrated explanation:

Where are the user rights stored?

Look like this:

There is a user table in the MySQL database:

Just like normal curd, this can be logged in control!

Note that permissions in the user table are global in nature,

What if you want to control a table? Remember the DB table, right here,

I will not dwell on the following:

MySQL Advanced permissions Check principle