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

patchwork

Well-Known Member
Nov 2, 2001
95
0
316
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

cPanel Development
Staff member
Apr 7, 2006
4,608
77
308
cPanel Access Level
Root Administrator
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

Well-Known Member
Nov 2, 2001
95
0
316
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

Well-Known Member
Apr 9, 2006
59
0
156
Nice to see this answer my question too, thanks Kenneth!
 

astar

Member
Jun 15, 2006
7
0
151
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.