I am trying to connect to remote MySQL server, which runs on CentOS 6.6 cPanel server.I am creating tunnel this way:ssh -L 3306:xxx.xxx.xxx.xxx:3306 user@xxx.xxx.xxx.xxx -p PPPPPWhere xxx.xxx.xxx.xxx is remote server IP address, 3306 ic configured MySQL port, and user is my user name on remote machine, and xxx.xxx.xxx.xxx is IP address of machine which runs MySQL server respectively and PPPPP is non-default SSH port.I have created id_rsa file with -r-------- permissions, and copied private key generated in cPanel into that file.As the public/private key pair is created with passphrasse, when trying to connect, shell asks me for passphrase, and output with error:Permission denied (publickey,gssapi-keyex,gssapi-with-mic).What am I doing wrong? My local machine is Debian 8.1 OS.
How to use SSH tunnel to connect to remote MySQL server?
debian;ssh;mysql;remote;ssh tunneling