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]

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]

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??