remote access myswl with software

upsforum

Well-Known Member
Jul 27, 2005
473
0
166
I have a problem:

I must allow my customers the remote access to theirs mysql db from software windows (navicat and similar).

I have configure Additional access host in WHM and add an example host (my IP provider of connection) from cpanel/mysql but using navicat it not go, I get an permission denied in answer.

Thank you

Alex
 

krava

Well-Known Member
Sep 23, 2003
149
0
166
cPanel Access Level
Root Administrator
Hi,


Do your clients use db_user, db_user_pass to connect to MySQL server remotely ? Can you show the exact error message ?
 

freedog96150

Well-Known Member
Mar 25, 2005
68
0
156
Nevada, USA
This quote is from WHM Main >> SQL Services >> Additional MySQL Access Hosts page:
Important: Users must login to their cPanel and enter the MySQL manager before these additional hosts will become active! If you would like to activate them on all users account's after you have made the changes, Click Here!
I have found that clicking on the force changes link (the click here link above) does NOT activate the additional hosts on my setup. My users still have to enter their MySQL Managers in their own cPanel and then the additional hosts are added.

We have had no problems accessing MySQL databases with SqlYog or MySQL Administrator from the Mysql.com website. If you are still experiencing problems with Navicat, try one of the above.
 

freedog96150

Well-Known Member
Mar 25, 2005
68
0
156
Nevada, USA
Oops! Forgot an important point. Make sure that port 3306 is opened on your servers firewall. I would also check to see if any of your clients are using any of the "Internet Security Suites" as there have been many posts lately about NOT being able to access various cPanel ports with these security suites installed on their computers.