Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
T
T
Timur Mammadov2022-01-17 08:23:50
MySQL
Timur Mammadov, 2022-01-17 08:23:50

#1143 - SELECT command denied to user... what to do?

One rainy day, I logged into my PHPMyAdmin via OpenServer and saw that all my databases were gone!
And on the screen there is an infuriating " #1143 - The SELECT command is forbidden for the user 'mysql.infoschema'@'localhost' for the column 'default_collation_id' in the table 'character_sets '"
Before that, I did not change anything!
Help me please!

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
A
Anton Shamanov, 2022-01-17
@SilenceOfWinter

add user rights all in the same PHPMyAdmin
PS switch to heidysql ("sql manager" in OpenServer)

Similar questions
R
Rooly2021-03-23 11:40:40
How to properly organize apiResource Laravel? 2Reply
L
lutokris2021-03-25 14:12:22
Why does memory allocation for a string look out of pattern? 4Reply
V
viktorross2019-11-09 23:29:52
How to make a record in 2 mysql tables? 2Reply
R
ReD2017-06-20 15:59:52
mod_rewrite module is now integrated into Apache? 2Reply
U
Udee Mo2021-05-16 14:36:06
How to call functions in ternary operator? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question