← Back to team overview

maria-discuss team mailing list archive

Re: Default privileges for anon. user.

 

Hello!
Running mysql_secure_installation will take care of that and other issues.

-GL

2015-02-26 7:47 GMT+01:00 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 ''.
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>

References