Check if the User Exists

SELECT user, host FROM mysql.user WHERE user = 'your_username';

If the user doesn’t exist, create them first:

CREATE USER 'your_username'@'%' IDENTIFIED BY 'your_password';

Grant Privileges Before Revoking

GRANT ALL PRIVILEGES ON your_database.* TO 'your_username'@'%';
FLUSH PRIVILEGES;

Then, if needed, revoke specific privileges:

REVOKE CREATE, DROP, GRANT OPTION, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON your_database.* FROM 'your_username'@'%';

If the user is created with ‘your_username’@’localhost’, but you are applying @’%’, adjust your queries:

GRANT ALL PRIVILEGES ON your_database.* TO 'your_username'@'localhost';

If nothing else works, deleting and recreating the user may help:

DROP USER IF EXISTS 'your_username'@'%';
CREATE USER 'your_username'@'%' IDENTIFIED BY 'your_password';
GRANT ALL PRIVILEGES ON your_database.* TO 'your_username'@'%';
FLUSH PRIVILEGES;