← Back to team overview

maria-discuss team mailing list archive

Default privileges for anon. user.



I've realized that by default MariaDB allow full access to a database for anon. users.

$ mysql --user asdfasdf test

MariaDB [test]> insert into test (sr) values (1);
Query OK, 1 row affected (0.12 sec)

I tried to revoke but --
Revoke all on test.test from ''@'';
ERROR 1141 (42000): There is no such grant defined for user '' on host '%'

Is there anyway to disallow all types of access to anon. users?

Follow ups