Unable to Access phpMyAdmin after change a value in DB mysql > user
Posted by: Arte Vizual
Date: October 07, 2020 12:46PM

Help,

I'm tuning a new bare metal web server with MySQL 8 and did something wrong.
I have the follow setting in /etc/my.cnf:

default_authentication_plugin=mysql_native_password

Through: WHM > SQL Services > phpMyAdmin
I looked into this database: "mysql" table: "user" and found these two rows values not using mysql_native_password in their "plugin" column:

mysql.sys | caching_sha2_password
mysql.infoschema | caching_sha2_password

I changed manually those two values to: mysql_native_password

*** Now phpMyAdmin doesn't open and I can't get those back to their original value. ***

I BEG FOR YOUR HELP to change again those values to "caching_sha2_password" so I can have access again to phpMyAdmin.

¿How can I do it?

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.