My user table crashed and I had to fix it. Now the error is displayed:
ERROR 1130 (HY000): The host & # 39; localhost & # 39; must not connect to this MariaDB server
No matter how I try to connect
mysql -u root
mysql -u root –host = 127.0.0.1
mysql –host = 127.0.0.1 –user = root -p
mysql -h 127.0.0.1 -u root -p
Now I can only open the database
However, if I gain access through this method, I cannot return the original permissions
grant all on *.* to root@localhost with grant option; FLUSH PRIVILEGES;
ERROR 1290 (HY000): The MariaDB server is running with the –skip-grant-tables option so that this statement cannot be executed
Is there a solution to escape this hook 22? Or am I meant to use –skip-grant-tables forever?
I really don't want to export and import 30GB worth of data into a new database.