Mysql - Remote connection

[DHL]

Hi,

I see this in CPanel news:-

Mysql Access Hosts Users can not setup their mysql databases to be accessible from any host they choose (4.5.0 build 74 or later only)


I have clients who need to connect to Mysql remotely with the mysql ODBC kit from mysql.com - How can I set them up to connect to Mysql remotely?

Thanks

Steve

 

[bdraco]

[quote:26d071d542][i:26d071d542]Originally posted by DHL[/i:26d071d542]

Hi,

I see this in CPanel news:-

Mysql Access Hosts Users can not setup their mysql databases to be accessible from any host they choose (4.5.0 build 74 or later only)


I have clients who need to connect to Mysql remotely with the mysql ODBC kit from mysql.com - How can I set them up to connect to Mysql remotely?

Thanks

Steve[/quote:26d071d542]

Just add the ip they are connecting from in their cpanel and they should be all set to go.

 

[DHL]

Thanks I would do, but CPanel is inaccessable this morning after then scheduled updates - The login @:2082 gives a blank page :-(

Steve

 

[DHL]

With it!

Updated CPanel manually and can see where to put the IP now,

Cheers, sorry for being dim

Steve

 

[n2nis]

Anyone Get This To Work

I have tried but mysql keeps denying access. I checked my users database and found the new hosts in there. Does anyone know if being behind a firewall could cause my access to be denied? I don't think that is the problem but that is the only solution I can think of.

 

[n2nis]

Skip That

I figured it out, Thanks...

 

[payne]

What was the problem? I am having the same problem... add the ip but still can't get access.

cPanel.net Support Ticket Number:

 

[redbox]

I'm having the same problem. Any solution?

 

[payne]

Well... my problem was that I failed to use the username and password set in the mysql cpanel section... I tried to use the un/pw of my cpanel account... too much coffee or something.

 

[antoshka]

i have the same problem... n2nis, why couldn't you just post your solution??