MySQL Forums
Forum List  »  Install & Repo

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

Options: ReplyQuote


Subject
Written By
Posted
how to repair mysql.infoschema
May 03, 2020 09:04AM


Sorry, only registered users may post in this forum.

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.