Re: [Maria-discuss] Default privileges for anon. user.

On 02/26/15 09:46, dE wrote:

Hi!

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?

Ok, got it. Add user ''.