diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2019-02-05 16:07:07 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2019-02-12 19:14:37 +0100 |
| commit | b9f3f06857ac6f9105dc65caae19782f09b47fb3 (patch) | |
| tree | 0ead96a1d76672ad42ca3b11d29f2abb390b5773 /mysql-test/main/failed_auth_unixsocket.test | |
| parent | f07b76fcfd68a0ae394764b181c1305b86e8f55d (diff) | |
| download | mariadb-git-b9f3f06857ac6f9105dc65caae19782f09b47fb3.tar.gz | |
MDEV-12484 Enable unix socket authentication by default
Change the default authentication for root@localhost to
IDENTIFIED VIA mysql_native_password USING 'invalid' OR unix_socket
which provides secure passwordless login, while still allowing
SET PASSWORD to work as expected.
Also create a second all-privilege account for the user that owns
datadir (and thus has full access to the data anyway).
Compile unix_socket plugin statically into the server.
Diffstat (limited to 'mysql-test/main/failed_auth_unixsocket.test')
| -rw-r--r-- | mysql-test/main/failed_auth_unixsocket.test | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/failed_auth_unixsocket.test b/mysql-test/main/failed_auth_unixsocket.test index a7ae7d64a6b..01fb09e1c46 100644 --- a/mysql-test/main/failed_auth_unixsocket.test +++ b/mysql-test/main/failed_auth_unixsocket.test @@ -36,7 +36,7 @@ connect (fail,localhost,$USER); --error ER_ACCESS_DENIED_NO_PASSWORD_ERROR change_user $USER; -update mysql.global_priv set priv=json_remove(priv, '$.plugin'); +update mysql.global_priv set priv=json_compact(json_remove(priv, '$.plugin')); flush privileges; uninstall plugin unix_socket; |