remote access myswl with software

[upsforum]

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

 

[upsforum]

........................ up!

 

[krava]

Hi,


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

 

[freedog96150]

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]

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.