Timur Mammadov2022-01-30 14:06:43
Timur Mammadov, 2022-01-30 14:06:43

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

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 the question

In order to leave comments, you need to log in

2 answer(s)
Alexander Karabanov, 2022-01-30

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

Dmitry Shitskov, 2022-01-30


Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question