title: problens whit phpmyadmin permissions
body: <p>I'm starting with database and I am probably doing wrong things in the programs.
  I have a database that I developed in php MyAdmin, then I opened it in MySQL and the console. So I changed user authorizations in phpMyadmin and created a lot of problems for my life. Now when I open this one and it doesn't find my database informing me of the following: # 1143 - 'SELECT' command denied for user 'mysql.infoschema'@' localhost 'in column' default_collation_id ', in the table' character_sets'.</p>
  <p>In the console I try to see my databases (mysql&gt; show databases;) and I get the answer: ERROR 1356 (HY000): View 'information_schema.SCHEMATA' references invalid table (s) or column (s) or function (s) or definer / invoker of view lack rights to use them</p>
  <p>MySQL Workbench also disappeared with my bank (I was able to recreate it through the script) and now I have problems making dumps (mysqldum.exe is version 8.0.20, but the MwSQL Server to be dumped has version 10.4.10).
  Help!
  Well, I don't know if the problems are related, I've been trying to solve all this for a few days and I can't.</p>
  <p>I appreciate any help!</p>