MySQL Forums
Forum List  »  Newbie

GRANT User Permission to Database
Posted by: Derrick Kearney
Date: December 13, 2018 01:38PM

There is obviously something odd with GRANT in version 8, I used this command with MySQL 5.6 and it worked perfectly. It is simply not working as expected in MySQL 8.0. There are 2 questions on StackOverflow with a wall of guesses. Why would, GRANT ALL ON simple_db.* TO 'app_user'@'localhost'; return "ERROR 1410 (42000): You are not allowed to create a user with GRANT"
I am not trying to create a user, the user already exists. I read the documentation but it is just not working, Can someone please tell me how to correctly grant privileges to user X for database Y?

Options: ReplyQuote


Subject
Written By
Posted
GRANT User Permission to Database
December 13, 2018 01:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.