host 'localhost' is not allowed to connect to this MariaDB server

kape1 posted 10 months ago in General

So I deleted all the users from my heidisql by accident. Get the error message on screen when trying to open heidisqil. How do I connect back to it?

1 attachment(s):
  • heidi
kape1 posted 10 months ago

Does re-installing heidi sql or mariadb fix this? Or do I have to re-install both?

ansgar posted 10 months ago

You could start the server with mysqld.exe --skip-grant-tables, so you can temporarily log on with root + empty password, then set up some user + password in the users table and restart the server normally.

Additional help is here to find:

Please login to leave a reply, or register at first.