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

[expired user #10988]'s profile image [expired user #10988] posted 6 years ago in General Permalink

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
[expired user #10988]'s profile image [expired user #10988] posted 6 years ago Permalink

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

ansgar's profile image ansgar posted 6 years ago Permalink

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.