MYSQL Name change errors

[PeterPan]

Hi,

I only found out about the MYSQL server name changes yesterday - as my scripts stopped working...

- but NO emails from powweb to advise...

One error is :-

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)



Has someone got a working example (replacing usernames etc) thatworks ?

Ive changed it to :-

$host="USERNAME.powwebmysql.com";
mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database - emailin1 - 34 ".mysql_error());

Apparently I can connect to the host - But not the database...
(ive NOT changed my database names in years...)

[PeterPan]

never mind - fixed...

apparently my password changed....
now going....

[dmacminn]

The previous naming scheme and the new naming are currently both available and there is no difference between them -- the username.powwebmysql.com is simply a DNS entry to the mysqlnn.powweb.com form... so there should be no difference whatsoever using either name ...
that will probably change in a month or so, when the old names will disappear...