CODEWITHSUNDEEP
mysqllinuxdebian
Firav
Firav

Reputation: 73

GRANT command not working on MySQL 8.0.25

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

I'm executing the following:

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.

Screenshot

Upvotes: 0

Views: 1396

Answers (1)

Firav
Firav

Reputation: 73

Conflicting authentication settings on users were preventing the user from registering properly. Deleted all affected users and created them again.

Upvotes: 1

Related Questions