php - mysql insert permission table cannot be connected

Question

I inserted host password user into the user table in the mysql server. The insertion was successful. Then I logged in at the specified host and found that the login failed

Answer 1

Insert directly into user? Authorization is not only about inserting data into this table, but also needs to be inserted into several other authorization tables. Use grant

Answer 2

There are many user-related tables, and direct insertion will miss the association. Let’s use create user