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

[Arturo Viñedo]

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,