|
Can't make unix_socket work on my machine, something must be missing.
MariaDB [test]> select @@version;
|
+----------------------+
|
| @@version |
|
+----------------------+
|
| 5.5.54-MariaDB-debug |
|
+----------------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [test]> install soname 'auth_socket';
|
Query OK, 0 rows affected (0.05 sec)
|
|
MariaDB [test]> create user elenst identified via 'unix_socket';
|
Query OK, 0 rows affected (0.00 sec)
|
MariaDB [test]> select @@socket;
|
+-----------------------------------+
|
| @@socket |
|
+-----------------------------------+
|
| /data/bld/5.5/data/tmp/mysql.sock |
|
+-----------------------------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [test]> exit
|
Bye
|
elenst@jessie:/data/bld/5.5$ whoami
|
elenst
|
elenst@jessie:/data/bld/5.5$ bin/mysql --socket=/data/bld/5.5/data/tmp/mysql.sock -uelenst
|
ERROR 1698 (28000): Access denied for user 'elenst'@'localhost'
|
The socket itself is okay:
elenst@jessie:/data/bld/5.5$ bin/mysql --socket=/data/bld/5.5/data/tmp/mysql.sock -uroot -p
|
Enter password:
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 7
|
Server version: 5.5.54-MariaDB-debug Source distribution
|
|
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
MariaDB [(none)]>
|
|