Navicat reports error 1142 when connecting to the MySQL database Solution
Today, with the purpose of learning to create your own project, I plan to Using Mysql database, after creating a new database, a new user is created, and all permissions of the new database are given to the new user in the permission configuration, but an error is prompted when logging in and clicking the link.
The general meaning of the picture should be that there is a lack of permissions for the table name named user, so here we configure the permissions of the user table, that is, the user table, to give newly created users That's it.
Related recommendations: "Navicat for mysql graphic tutorial"
Specific steps
It is also easy to open my Navicat, select the newly created user and click Edit "Edit User" to grant all permissions of the user table to the newly created user.
The above is the detailed content of What to do with navicat error code 1142. For more information, please follow other related articles on the PHP Chinese website!