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

phpMyAdmin does not display any Data Base, it shows this error:

#1449 - The user specified as a definer ('mysql.infoschema'@'localhost') does not exist

Because I edited manually the "plugin" column value using phpMyAdmin (when It was working), I thought that running a simple query to UPDATE that row for each User will reverse the change I made, but I'm not sure if It'll work and that's why I'm asking for your help.

phpMyAdmin do let run queries in the "SQL" section and this is the query I'm thinking to run:

To check the current value:
------------------------------
select user,plugin from mysql.user where user='mysql.infoschema';

Result:
--------
user | plugin
mysql.infoschema | mysql_native_password

select user,plugin from mysql.user where user='mysql.sys';

Result:
--------
user | plugin
mysql.sys | mysql_native_password


To change the "plugin" value to "caching_sha2_password"
-----------------------------------------------------------------
UPDATE mysql.user SET plugin = 'caching_sha2_password' WHERE User = 'mysql.infoschema';

Repeating this update for "mysql.sys"

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

I don't know if I should run at the end: FLUSH PRIVILEGES;


Clearly I'm not MySQL expert and I really hope you can help me,

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.