Forums » General Discussion

Thread: TOAD for MySQL and SSH connections


Permlink Replies: 0 - Pages: 1
tony.edkins_656

Posts: 1
Registered: 9/30/11
TOAD for MySQL and SSH connections
Posted: Sep 30, 2011 4:42 AM
  Click to reply to this thread Reply

I spent ages trying to find out why I kept getting 'authentication failure' messages when attempting to make an SSH connection to a MySQL database from TOAD. The answer is really very simple and I would like to share this with you. If you are connecting to a Linux server the answer lies in the ssh daemon configuration on the server. Check the sshd_config file on the server (normally located in /etc/ssh). In that file look for an entry called 'Password Authentication'. If that is set to 'no' change it to 'yes'. Save the file and restart the SSH daemon. Your connection should now work ! It did for me


Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums