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:,690459,690466#msg-690466

Thank you in advance

Options: ReplyQuote

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.