Using cPanel as the only way to access the server, is it possible to setup a connect to MySQL so I can administor the MySQL database remotely? i.e using MySQL WorkBench?
closed as off-topic by Jenny D, Bryan, mdpc, Ladadadada, Michael Hampton♦ Jun 28 at 19:43
- This question does not appear to be about professional server, networking, or related infrastructure administration within the scope defined in the help center.
Once logged into cPanel you need to go to the "Remote MySQL" page which you will find in the databases section of cPanel. From here you need to enter the IP which you will be accessing your database from remotely, you can get this by visiting here on the machine: http://www.nethosted.co.uk/check-ip.php
Once you have set this up it will allow you to connect remotely to the MySQL database typically, you would enter the server address as your website url or server IP, remote port would be default 3306, database name, database user and password are all ones that you set through the cPanel MySQL Databases page.
A few things to note, database name and database user will be prefixed with your cPanel username and an underscore, and you need to make sure you have added the user to the database which you can do at the bottom of the MySQL Databases page in cPanel.
There are 2 possible ways: