not able to connect remote MySQL : Remote Database Access Hosts

crazyaboutlinux

Well-Known Member
Nov 3, 2007
939
1
66
I am not able to connect remote MySQL

i have added (% wildcard is allowed, My local Static IP is allowed, Allowed a server IP as well) access the tool via cPanel -> Databases -> Remote MySQL:
Remote Database Access Hosts

But still i am getting the same error

MySQL Query Browser Error Number : 1045

Could not connect to the speified instance

MySQL Error Number 1045
Access Denied for user '[email protected]'xx.xx.209.216' (using password : YES) (comment :xx.xx.209.216 is local ISP)

if you want to check the network connetion, Please click the Ping Button.
 

garrettp

Well-Known Member
PartnerNOC
Jun 18, 2004
312
1
166
cPanel Access Level
DataCenter Provider
Have you ruled out the possibility that your credentials are bad by testing them via a localhost connection (e.g. from the server itself)?
 

kloring

Registered
Aug 19, 2011
2
0
51
The "@xx.xx.209.216" is the IP you need to create a host for. if u have cable modem its prob dynamic so it will change alot.
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
Have you ensured that the user has been added to the database in question? Oftentimes, people create the database in cPanel > MySQL Databases area, then create the user there, but do not do the third step to add that MySQL user to the database. That option is toward the bottom of cPanel > MySQL Databases area for the "Add User To Database" section.
 

Elliot Balanza

Registered
Oct 5, 2011
2
0
51
cPanel Access Level
Root Administrator
I'm having the exact same problem, The site is even working via localhost, so yes all is in place, yet i cant connect neither vya MyODBC or to create things with DW.

The GUI of MySQL works fine so I'm lost here.
 

Igor Volanski

Registered
Apr 3, 2015
4
0
1
Brazil
cPanel Access Level
Root Administrator
I have the same problem. Everything is tested. Wildcard added, user created, privileges granted, tested username and password from localhost(inside the box) and it is ok. I have no idea about how to solve this problem. Maybe something firewall related.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,228
463
I have the same problem. Everything is tested. Wildcard added, user created, privileges granted, tested username and password from localhost(inside the box) and it is ok. I have no idea about how to solve this problem. Maybe something firewall related.
Do you have root access to both servers, or are these shared hosting accounts?

Thank you.