I'm struggling getting either MSSQL-SERVER or POSTGRESQL running through DBEAVER.
I can create a Docker image of the mssql-server and get that running but there are compatability issues with the jdbc driver due to garuda having a higher version of linux than mssql-server is capable of handling.
I don't know what the fix is. I don't want to break anything and I don't know how to go about swicthing java versions just for when I'm working with SQL.
Postgres always fails connection even when downloading the required driver.
I haven't tried mysql but expect it will have similar issues. I will try working on them whilst I await someone who is more experienced to do me the honour of replying to this post.
when running mariadb as an alternative this is the error message received
mariadb
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)
running mysql instead of mariadb give this error message
× mysqladmin -u root -p status
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/run/mysqld/mysqld.sock' exists!
and running any sql version from DBeaver gives a connection refused error when downloading drivers.
Do sudo mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql then start mariadb. Then everything should work.
I was having the same problem and the first command mentioned on the arch wiki page for MariaDB fixed it for me.