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
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.