remote mysql doesn't work again, here it he phpmyadmin error

[WebHostPro]

phpMyAdmin - error

#2005 - Unknown MySQL server host '"12.123.123.123"' (1)

--

Any help is appreciated. Nad it's not the firewall, some servers work some don't.

 

[patchwork]

I'm receiving the same error after setting up remote mysql, if I try to load phpmyadmin from cpanel I get "phpMyAdmin - error 2005 - Unknown MySQL server host '"##.##.##.##"' (1)"


I've also had trouble moving accounts from my old server to this new one, the transfer looks like it works but the databases cannot be accessed from the site afterwards, the only way so far I've found to get the database working is to delete them and create new databases and users from scratch.

The old server is using mysql 4.0.27 and the new server is running 4.1.21, I'm guessing the transfer account code doesn't deal with mysql version differences.


Pete

 

[cPanelKenneth]

Check the PHPMyAdmin configuration file. The hostname might have too many quotes in it. If so, remove the extra quotes. The same if you exerpience this with Horde and remote MySQL

 

[patchwork]

Thanks Kenneth, that was indeed the problem, I looked at the config file a few hours ago and completly failed to notice the additional quotes.

Thanks Again
Pete

 

[mitgib]

Nice to see this answer my question too, thanks Kenneth!

 

[WebHostPro]

Check the PHPMyAdmin configuration file. The hostname might have too many quotes in it. If so, remove the extra quotes. The same if you exerpience this with Horde and remote MySQL

Yep that fixed it, thanks!

 

[astar]

hi,

can you pls. provide me the steps as to how to set this in phpmyAdmin, i'm not familiar with it. i mean how to check if it obtains double quotes.

thanks.