T
T
Timur Mammadov2022-01-30 14:06:43
MySQL
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)
A
Alexander Karabanov, 2022-01-30
@karabanov

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

D
Dmitry Shitskov, 2022-01-30
@Zarom

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

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question