[2024-feb-29] Sad news: Eric Layton aka Nocturnal Slacker aka vtel57 passed away on Feb 26th, shortly after hospitalization. He was one of our Wiki's most prominent admins. He will be missed.

Welcome to the Slackware Documentation Project

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
howtos:misc:connect_client_over_ssh_tunnel_to_mariadb [2019/06/26 01:23 (UTC)] – [How to connect mysql client over SSH tunnel to Mariadb server] mahafyihowtos:misc:connect_client_over_ssh_tunnel_to_mariadb [2019/06/26 01:51 (UTC)] (current) – [How to connect mysql client over SSH tunnel to Mariadb server] mahafyi
Line 14: Line 14:
 __**On the client machine**__ __**On the client machine**__
  
-Generate keys for authentication using ssh-keygen without a passphrase as follows. You may use RSA also. The below command will create a private and public key after giving you file name option. Just hit enter to avoid using a passphrase.+Generate keys for authentication using ssh-keygen without a passphrase as follows. You may use RSA also. The below command will create a private and public key after giving you file name option. Just hit enter to avoid using a passphrase. Create and login as a similar tunnel user when doing this.
   ssh-keygen -t ecdsa -b 521 -C my-comments   ssh-keygen -t ecdsa -b 521 -C my-comments
 The public key with filename extension .pub should be installed in the database server user’s authorized_keys. The contents of the .pub file can be copy pasted or you can use a command line utility like ssh-copy-id as shown below. Never copy the private key to other server. The public key with filename extension .pub should be installed in the database server user’s authorized_keys. The contents of the .pub file can be copy pasted or you can use a command line utility like ssh-copy-id as shown below. Never copy the private key to other server.
 howtos:misc:connect_client_over_ssh_tunnel_to_mariadb ()