#1143 - SELECT command not allowed for user 'mysql.infoschema'@'localhost'?

Question

MySQL

At one point, all users simply lost their rights ... Do not go to root at all:

mysqli::real_connect(): (HY000/1045): Access denied for user 'mysql'@'localhost' (using password: YES)

And in mysql from the threshold they write:

#1143 - Команда SELECT запрещена пользователю 'mysql.infoschema'@'localhost' для столбца 'default_collation_id' в таблице 'character_sets'

What to do? Give me some advice!!!
I have been trying to solve the problem for two weeks, but they did not give an answer!

Answer 1

Yes, your base is broken. Kill it and do it again - it makes no sense to repair it.

Answer 2

https://ruvds.com/ru/helpcenter/root-mysql-mariadb...