MySQL SSH Tunnel on LAMP 1-Click

use mysql;
UPDATE user SET plugin='mysql_native_password' WHERE User='root';
FLUSH PRIVILEGES;
exit;

Hi @j2adbd54a1f67ab82ceb67bd02,

There are a few things that need to be done prior to being able to perform an SSH tunnel.

Please try to do the following things :

• Allow your IP on your droplet
• If this doesn’t work, allow your IP to access port 3306 for MySQL
• Make sure, you are accessing the proper port

If this doesn’t help, you’ll need to start looking into the logs of the server to see why the connection has been refused. The mentioned information, can be seen in the log file

• /var/log/secure
• /var/log/messages

Regards, KDSys