maria-discuss team mailing list archive

[dE <de.techno@xxxxxxxxx>]

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