Comments - How to use SQL Workbench to connect to MariaDB?
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Having tried for the first time, I downloaded SQL Workbench, downloaded MariaDB Java Client
Loaded up workbench. Under File -> Manage Drivers, selected New Driver (on top left), selected the MariaDB Java Client just downloaded. I used the same sample URL of jdbc:mariadb:host:port/database as per about-the-mariadb-java-client.
After creating connection using this url I managed to connect.
Attempting a socket URL of jdbc:mariadb:localhost/mysql?localSocket=1&socket=/var/tmp/mysqld.2.sock returned a com/java/jna/LastErrorException so you're probably limited to TCP connections for now.
also tried a correct url of jdbc:mariadb:localhost/mysql?localSocket=/var/tmp/mysqld.2.sock which still returns the same error. Seems to be an error in the MariaDB drivers. I'll write a bug report.
sockets work after downloading jna-4.1.0.jar from https://github.com/twall/jna and adding it to the drivers for MariaDB
unix_socket auth doesn't work however.