Issue
I'm attempting to grant a user privileges within a database, and I'm receiving the error
#1410 - You are not allowed to create a user with GRANT
GRANT ALL PRIVILEGES ON `database`.* TO 'user'@'localhost';
The user is already created, but I cannot grant privileges to it.
Below is a screenshot of a specific user Im attempting to edit.
Solution
Conflicting authentication settings on users were preventing the user from registering properly. Deleted all affected users and created them again.
Answered By - Firav Answer Checked By - Gilberto Lyons (WPSolving Admin)