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/mysql_upgrade-6984.result | |
| 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/mysql_upgrade-6984.result')
| -rw-r--r-- | mysql-test/main/mysql_upgrade-6984.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/mysql_upgrade-6984.result b/mysql-test/main/mysql_upgrade-6984.result index 87f3c1a5359..ad48004a2a3 100644 --- a/mysql-test/main/mysql_upgrade-6984.result +++ b/mysql-test/main/mysql_upgrade-6984.result @@ -63,6 +63,6 @@ test Phase 7/7: Running 'FLUSH PRIVILEGES' OK connect con1,localhost,root,foo,,,; -update mysql.global_priv set priv=json_remove(priv, '$.plugin', '$.authentication_string'); +update mysql.global_priv set priv=json_compact(json_remove(priv, '$.plugin', '$.authentication_string')); flush privileges; set global event_scheduler=OFF; |