[Maria-discuss] Default privileges for anon. user.
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?
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 ''.
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@gmail.com>:
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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (2)
-
dE -
Guillaume Lefranc