Connect to Your Database Remotely
Posted by ASO Admin on 11 February 2020 07:45 AM
|
|
Let's say you're developing a script on your PC at home, and you need to connect to your database remotely using a MySQL admin program. No problem. This procedure is a little quirky, but here are the steps to grant remote access to your database. database: example_mydb Whitelist Your IP
Notify UsWe take MySQL security very seriously. So, in addition to the standard cPanel procedure, we also need to add the remote IP to the firewall. Please contact Support and notify us of the IP address so that we can make sure it has access to MySQL. Add User to Database
Testing your ConnectionNow, using your PC and remote MySQL client, enter the connection information for your database, database user, and the server name or IP address. If you run into problems with any of this, double-check the steps above or send in a support ticket for assistance. Remove User from Database When No Longer Needed
Next StepsYou've enabled remote access... now what? You will need a third party application to connect to MySQL remotely, like MySQL Workbench, phpMyAdmin (available in your cPanel) or Navicat, or even Dreamweaver and similar.
| |
|