Having connection problems related to password
When going through your How To on updating the database connection file (localhost.php), I set the username and password equivalent to what I have on my server. When I hit Test, it says there is an error connecting to the file. The only way I eliminate the test error is if I enter "root" and "[nothing]" in the u/p fields. But then if I upload this connection file and try to connect to a page (in this case, users_Confirm.php), I get the following error message:
Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'root'@'localhost' (using password: NO) in /home/gcssepm/www/Connections/localhost.php on line 9
Fatal error: Access denied for user 'root'@'localhost' (using password: NO) in /home/gcssepm/www/Connections/localhost.php on line 9
This has plagued me since Day 1 of following your instructions - If I set a username and password, I cannot connect to the database or mysqladmin. If I set it to nothing, I get a successful connection from within DW CS4 but then cannot connect on the Internet. If you could help me straighten this out it would be greatly appreciated.