I need to connect to a Mysql database on a server that is only accessible over ssh with a Kerberos ticket. In a console this is easy, I only do:

kinit (then enter password)
ssh username@server (without entering password)
sudo su - (without entering password)
mysql (without user or password)

Now I want to view the content of the database with a gui like Mysql Workbench or PHPStorm but I don't know how to setup the connection.

I clicked (in PHPStorm) "Use SSH Tunnel", added the server in "Proxy host" and my username in "Proxy user".

Now I have to choose between Auth Type "password" or "key pair", but neither seems to be right for kerberos and whatever I try I just can't connect.

I tried with PHPStorm, MySQL Workbench and DBeaver which basically all offer the same options to setup an SSH-Tunnel.

There is a question about a SSH-Tunnel with MySQL Workbench here: SSH tunnel via MySQL Workbench, but it doesn't involve kerberos.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.