Re: Unable to Access phpMyAdmin after change a value in DB mysql > user

[Arturo Viñedo]

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