Keywords: LAMP/MAMP/WAMP - AWS - Technical issue - Other
bnsupport ID: c99a90ef-249a-7325-32d8-0057115f7f6e
Hello MySQL community
Today I tried to change privileges for "mysql.infoschema" user and it ended badly.
Honestly, I changed them by mistake and did not know that this should not be done.
and now there are errors saying that I can’t change the rights and offer me to fulfill sql query again.
What should I do to get everything back?
What's sql query should I make to return back the SELECT rights for mysql.infoschema@'localhost' user
Also I try to do this SQL suery
GRANT SELECT ON . TO 'mysql.infoschema
But I got an error:
1410 - You are not allowed to create a user with GRANT
Please help me
I'm sorry if I created the topic in the wrong place
I use bitnami LAMP / MySQL version 5.6