Seting Koneksi Mysql Workbench ke Mysql sever Via SSH yang menggunakan Private Key

30.6.19 ilham.sp 0 Comments

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
You will see a screen similar to this appear:
mysqlb-setup
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)
Click the Advanced tab and make sure Use the old authentication protocol is checked.
mysqlb-advanced
Press Test Connection to see if it works. You should see a similar message:
success
If so, click OK and then double-click the entry to connect.

0 komentar: