Remote access to mySQL database

Nick Bramwell shared this question 5 years ago
Answered

Hello,


I’m trying to use Navicat so I can sync mySQL databases between my sites and my local development machine. Is this something which I should be able to do using reseller hosting? I don’t want to spend more time trying to get it working if it isn’t supported anyway.


Thanks


Nick

Best Answer
photo

If Navicat connects to the server via the MySQL port (3306), you can use this.


You'd just need to add your IP within cPanel under the MySQL options and then you'll be able to login using your normal database name, username and password.

Comments (2)

photo
1

If Navicat connects to the server via the MySQL port (3306), you can use this.


You'd just need to add your IP within cPanel under the MySQL options and then you'll be able to login using your normal database name, username and password.

photo
1

Thanks Matt,


that works perfectly now I’ve added my IP address.


Have a great evening