![]() ![]() Should you need any further assistance, please do not hesitate to contact us. If all of the provided details are correct, you should be able to connect: HeidiSQL may ask you to cache the server's host key in the registry. Local Port: enter 3307 or another unused port on your computerĬlick on Save, then Open to test the settings. SSH host + port: your server hostname and SSH port Plink.exe location: Download the application and link it's location. How to setup a secure remote MySQL connection using HeidiSQL:ġ) Open HeidiSQL and click on the New button (bottom left) to setup a new connection: You will be able to connect to the database by clicking on it's shortcut and then Connect: Password: click on Store in Vault … and type in your database passwordĬlick on Test Connection and if all of the details are correct, you should see the successful connection message: ![]() SSH Password: click on Store in Vault … and type in your cPanel password ![]() SSH Hostname: your server hostname and SSH port (e.g., :22) How to setup a secure remote MySQL connection using MySQL Workbench:ġ) Open MySQL Workbench and click on the + icon to setup a new connection:Ĭonnection Method: Standard TCP/IP over SSH Shell Access (SSH) is required, so contact us to enable it for your account, if not enabled already. Click the plus button beside MySQL Connection. And for SSH Username, we enter the default SSH user name to connect to the EC2 instance. You can easily set up a secure connection between your computer and the server using SSH tunneling by using free open source programs like MySQL Workbench and HeidiSQL. So you just configure mysql-workbench to connect to localhost:3307. In order to provide full PCI compliance and improved security, direct remote MySQL connections are disabled on our newest shared servers. How to setup a secure remote MySQL connection ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |