how to repair mysql.infoschema
Posted by:
Dima Din
Date: May 03, 2020 09:04AM
Hello MySQL community
Today I tried to change privileges for mysql.infoschema 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`@`localhost'
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
Subject
Written By
Posted
how to repair mysql.infoschema
May 03, 2020 09:04AM
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.