Remember that if you use option #2 you’ll have to connect to mysql as your system username ( mysql -u YOUR_SYSTEM_USER) ![]() Mysql> GRANT ALL PRIVILEGES ON *.* TO UPDATE user SET plugin='auth_socket' WHERE User='YOUR_SYSTEM_USER' $ sudo mysql -u root # I had to use "sudo" since is new installation Note that disabling TCP forwarding does not improve security unless users are also denied shell access, as they can always install their own forwarders. The available options are yes (the default) or all to allow TCP forwarding, no to prevent all TCP forwarding, local to allow local forwarding only or remote to allow remote forwarding only. Specifies whether TCP forwarding is permitted. Restart SSH sudo service ssh restart Note: What is AllowTcpForwarding in SSH Execute the following code ssh-keygen -Aģ. ![]() Change the value of AllowTcpForwarding to yes in the /etc/ssh/sshd_config file. Configure a Secure Shell setting on the remote server to allow port forwarding. Solution: For the SSH Tunnel to work, allowtcpforwarding must be set to yes in your SSH Server config.ġ. Navicat– 80070007: SSH Tunnel: Server does not support diffie-hellman-group1-sha1 for keyexchange
0 Comments
Leave a Reply. |