GRANT User Permission to Database
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?
Subject
Written By
Posted
GRANT User Permission to Database
December 13, 2018 01:38PM
December 13, 2018 04:25PM
December 13, 2018 06:54PM
December 13, 2018 09:58PM
December 14, 2018 09:38AM
December 14, 2018 10:09AM
December 14, 2018 10:44AM
December 13, 2018 10:07PM
December 14, 2018 09:20AM
December 14, 2018 10:43AM
December 13, 2018 08: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.