← Back to team overview

maria-discuss team mailing list archive

Re: Default privileges for anon. user.


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

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

Follow ups