HostingRails.com

That is correct - did you add your public IP address to the list of allowed hosts ? -- check in your cPanel MySQL section.  

Yes, I did that actually...

The message I am getting is "1045: Access denied for user hruser_dbuser@<hostip>".

I have set this up both with password and with private key at the SSH login level. In both cases, I get the same message. I have also tried the normal Windows hack of restarting Navicat :-) Still doesnt work!

Rajesh

Ahh - ok - please login remotely via your cPanel username and password.  I believe that is your issue.  If that still doesn't work please contact support and we'll take a look at your settings.  

Cheers,

~William

umm... the username and password that I gave for the SSH component was the cPanel username and password... and that didnt work. cPanel works fine with that username password combo though. Also, NaviCat attempts to connect through port 3306.

What other info can I give you to help resolve this?

Regards,
Rajesh

Ok... when I set the access permitted to % in cPanel. I am able to connect. According to my local router, my IP 210.18.x.x. When I set access permitted to 210.%.%.% I am unable to access... As I understand it, I will need to check the 'user' table in the master 'mysql' database to figure out what IP I am connecting with. Obviously I don't have access to this db/table. Right now, the access on my db for remote hosts is set to %, obviously it is not acceptable to continue that when I open this app out to the world.

Need your support in figuring out with what IP I am hitting MySQL.

Please advise.

Regards,
Rajesh

OK - cPanel can be picky with this - go to http://www.whatsmyipaddress.com and enter the IP you see exactly.  Don't use any %  -- we've seen that work.  

Let me know how it goes.

~William

Nix on that... when i remove the % and put in the IP that I find at whatsmyipaddress.com it stops working :-(

Rajesh

Hi Rajesh,

It seems that your ISP is providing a dynamic IP address. Can you please try with 210.18.% in your Remote Database Access Hosts ? It should work fine.

Kumar,

In one of my earlier posts, I mentioned that I did try 210.%.%.% and it didn't work... Anyway, I did try again with 210.18.%.% and the result is the same... cant access unless I know the IP with which I am hitting you or unless I set access to %.

Regards,
Rajesh

Hi Rajesh,

Did you try with 210.18.%  (not with multiple % signs ? )

Tried that now... same result! And yeah, I tried 210.% too with same results :-)