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

kape1 posted 3 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 3 months ago

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

ansgar posted 3 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: https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html

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