Error after updating DB_SERVER

[yalan1220]

I recently upgraded my database from mySQL 4.1 to 5.0. I kept the database name, username and password all the same. Only change is the server name. I updated this information in the includes/configure.php file

/*

OLD DB INFO

define('DB_SERVER', 'p41mysql127.secureserver.net');

define('DB_SERVER_USERNAME', 'ucsadmin');

define('DB_SERVER_PASSWORD', *****');

define('DB_DATABASE', 'ucsadmin');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', 'mysql');

*/

define('DB_SERVER', 'p50mysql117.secureserver.net');

define('DB_SERVER_USERNAME', 'ucsadmin');

define('DB_SERVER_PASSWORD', '*****');

define('DB_DATABASE', 'ucsadmin');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', 'mysql');

 

Now I am getting this error when accessing my admin page (http://segllc.net/UCSTest/catalog/admin/'>http://segllc.net/UCSTest/catalog/admin/):

 

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/s/e/g/segweb/html/UCSTest/catalog/admin/includes/functions/database.php on line 19

Unable to connect to database server!

 

And this error when accessing my online store (http://segllc.net/UCSTest/catalog/):

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ucsadmin'@'208.109.181.225' (using password: YES) in /home/content/s/e/g/segweb/html/UCSTest/catalog/includes/functions/database.php on line 19

Unable to connect to database server!

 

Please help!

[web-project]

incorrect password to database

[Guest]

incorrect password to database

Did you change both configure.php files (or all 4 if you also have them in includes/local directory).

 

Does the new db on the new server have ucsadmin as a user with all priveliges?

[yalan1220]

Did you change both configure.php files (or all 4 if you also have them in includes/local directory).

A: Sorry, I did not realize that there were two configure.php file. Are these the two files?

#1 admin/includes/configure.php (just found)

#2 includes/configure.php (already updated)

 

I noticed that the several of the fields in file #1 are different from file #2. I could use some guidance on how to populate the fields because what I currently have in there is incorrect.

 

I was also informed that the ip address (208.109.181.225) in the error message correlates to the web server address, not the database address of (p50mysql117.secureserver.net), so it is most likely a configuration setting that I have missed.

 

Does the new db on the new server have ucsadmin as a user with all privileges?

A: I spoke to my hosting technical support and they informed me that all database users have read/write permission.

 

Thank you so much for your help.