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?
host 'localhost' is not allowed to connect to this MariaDB server
Does re-installing heidi sql or mariadb fix this? Or do I have to re-install both?
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.