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

host-localhost-is-not-allowed-to-connect-to-this-mariadb-server

I've accidentally deleted my users table (removed all users) now whenever I try to access my database it says: "host localhost is not allowed to connect to this MYSQL Server". I've tried connecting directly, same error. I'm using apache xampp for this.

Solution

C:\xampp71\mysql\bin\my.ini file.

[mysql]
skip-grant-tables