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 revision Previous revision
howtos:misc:connect_client_over_ssh_tunnel_to_mariadb [2019/06/26 01:23 (UTC)]
mahafyi [How to connect mysql client over SSH tunnel to Mariadb server]
howtos:misc:connect_client_over_ssh_tunnel_to_mariadb [2019/06/26 01:51 (UTC)] (current)
mahafyi [How to connect mysql client over SSH tunnel to Mariadb server]
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.

In Other Languages
QR Code
QR Code howtos:misc:connect_client_over_ssh_tunnel_to_mariadb (generated for current page)