Re: Unable to Access phpMyAdmin after change a value in DB mysql > user
Posted by: Arturo Viñedo
Date: October 07, 2020 07:54PM

Thank you Peter, My SQL knowledge is very low and I'm sorry if this is a silly question:

(MySQL 8.0.21) Is this the right query to change it back to what it was?

UPDATE mysql.user SET plugin = 'caching_sha2_password' WHERE User = 'mysql.infoschema';

To change the "plugin" row to "caching_sha2_password" for user "mysql.infoschema" in the "user" table of "mysql" database


Here is my extended explanation: https://forums.mysql.com/read.php?35,690459,690466#msg-690466


Thank you in advance

Options: ReplyQuote




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.