Once we have your SSH key on our server, configure MySQL Workbench to connect. First, open MySQL Workbench and click the + icon next to MySQL Connections.
![mysqlb1](https://i0.wp.com/wavemotiondigital.com/wp-content/uploads/2016/05/mysqlb1.png?zoom=2&resize=343%2C280&ssl=1)
You will see a screen similar to this appear:
![mysqlb-setup](https://i0.wp.com/wavemotiondigital.com/wp-content/uploads/2016/05/mysqlb-setup.png?zoom=2&resize=914%2C636&ssl=1)
For Connection Method, select Standard TCP/IP over SSH
Set the name to whatever you want, preferably an easily recognizable label.
Under the Parameters Tab, enter the following information:
SSH Hostname: Your server IP address or URL
SSH Username: {your SSH username}
SSH Password: leave blank/click “Clear” to be safe
SSH Keyfile: ~/.ssh/id_rsa (or if using Windows the keyfile generated by PuTTy)
MySQL Hostname: 127.0.0.1
MySQL Port: 3306
Username: (We will provide this – your database username)
Password: (We will provide this – your database password)
SSH Username: {your SSH username}
SSH Password: leave blank/click “Clear” to be safe
SSH Keyfile: ~/.ssh/id_rsa (or if using Windows the keyfile generated by PuTTy)
MySQL Hostname: 127.0.0.1
MySQL Port: 3306
Username: (We will provide this – your database username)
Password: (We will provide this – your database password)
Click the Advanced tab and make sure Use the old authentication protocol is checked.
![mysqlb-advanced](https://i2.wp.com/wavemotiondigital.com/wp-content/uploads/2016/05/mysqlb-advanced.png?zoom=2&resize=914%2C636&ssl=1)
Press Test Connection to see if it works. You should see a similar message:
![success](https://i0.wp.com/wavemotiondigital.com/wp-content/uploads/2016/05/success.png?zoom=2&resize=534%2C276&ssl=1)
If so, click OK and then double-click the entry to connect.
Seting Koneksi Mysql Workbench ke Mysql sever Via SSH yang menggunakan Private Key
Reviewed by ilham.sp
on
June 30, 2019
Rating:
No comments: