I’m attempting to connect to my MySQL Database using the Connection Method “Standard TCP/IP over SSH”. I filled out all the SSH and MySQL connection details correctly, however I get the message: “Authentication error.” because I’m protecting SSH with Two Form Factor Authenticator (libpam-google-authenticator). Is there another way to connect and resolve this issue?
You can still use Google Authenticator with mysql workbench, but you will need to change how SSH and Google Authenticator work together. When you login via SSH, you probably enter your password and then you are prompted for your Two-Factor pin. You want to change this so that you enter your password and pin, one directly after the other, on one line as the password:
This will work with MySQL Workbench TCP/IP over SSH. I modify /etc/pam.d/sshd to use the forward_pass option for the Google Authenticator module. You will need to put a line like this at the top of /etc/pam.d/sshd:
auth required pam_google_authenticator.so nullok forward_pass
Google Authenticator will authenticate the pin, strip it from the password, and pass the password along to the other PAM modules.
Answered by Adam on December 12, 2020
1 Asked on October 27, 2021 by erwin-zangwill
3 Asked on October 27, 2021 by patrickdavey
0 Asked on October 27, 2021 by akhilesh-kedarisetty
1 Asked on October 27, 2021 by d4bbi
1 Asked on March 2, 2021
1 Asked on March 1, 2021 by mikhail-aksenov
0 Asked on February 27, 2021 by plisken
2 Asked on February 25, 2021 by develjoe
1 Asked on February 23, 2021 by rameez
4 Asked on February 23, 2021 by user1870400
1 Asked on February 22, 2021 by ramy-khalifa
0 Asked on February 20, 2021 by gfbaggio
0 Asked on February 19, 2021 by immobiluser
3 Asked on February 19, 2021 by ammar-faizi
1 Asked on February 19, 2021 by radu-dumbrveanu
2 Asked on February 18, 2021 by gandalf-stormcrow
1 Asked on February 17, 2021 by caltor
Get help from others!