Hi, I have a Web app running on a VPS host before and it worked perfectly fine but because of load and memory issues, I upgraded to dedicated hosting plan. However, after the upgrade my app no longer works because it does not let me make any type of DB connections. I keep getting:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'myuser'@'localhost' (using password: NO) in /home/myuser/public_html/sitefolder/test.php on line 2
FALSE
The test.php file is a simple file containing this code:
<?php
$dbhost = 'localhost';
$dbuser = 'databaseusername';
$dbpass = 'databasepassword';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$dbname = 'databasename';
mysql_select_db($dbname);
?>
Does anyone have any clue? I have not changed the files and everything was working fine before the switch to dedicated. I even had support reinstall PHP but still no dice. And we tried changing localhost to IP, etc. It keeps defaulting to 'myuser'@'localhost'
Any ideas?
Thanks, any help is greatly appreciated. 😕