Where did the bases go?

Question

PHP

Updated mysql from 5.7 to 8.0, at first couldn't get into phpmyadmin with error:

mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client

Solved this with:

[mysqld]
default_authentication_plugin=mysql_native_password

I was able to log in, but immediately upon entering:

SELECT `CHARACTER_SET_NAME` AS `Charset`, `DESCRIPTION` AS `Description` FROM `information_schema`.`CHARACTER_SETS`
Ответ MySQL: Документация

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

Actually, I don’t see the list of databases and everything that was connected to the database has fallen, please tell me.

Answer 1

Try to runmysql_upgrade -u root