MySQL Error

[mculpepp]

[FONT=Tahoma, Calibri, Verdana, Geneva, sans-serif]Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'dreamc90_dccREAD'@'localhost' (using password: YES) in/home/dreamc90/public_html/index.php on line 16
Access denied for user 'dreamc90_dccREAD'@'localhost' (using password: YES)

This user has full privileges for testing purposes. database is setup correctly and I'm on the x10.bz domain. Can't seem to figure out the issue here. All variables are host='localhost', user='dreamc90_ReaD', pass='NOTREALPASSESOMG'

session_start();if (!isset($_POST['username'])){      $_SESSION['user'] = 'Welcome, Guest';}else{      // Connects to your Database 
      $host = "localhost";      $user = "dreamc90_dccReaD";      $pass = "NOTREALPASSESOMG";      $db = "dreamc90_dccDB";
      mysql_connect($host, $user, $pass) or die(mysql_error());       mysql_select_db($db) or die(mysql_error());      $data = mysql_query("SELECT username,password FROM User WHERE username={$_POST['username']}") or die(mysql_error());      $info = mysql_fetch_array( $data );      while($info = mysql_fetch_array( $data ))       {              if ($info['username'] == $_POST['username'])              {                     $_SESSION['user'] = 'Welcome, ' + strtoupper($row['USERFIRSTNAME']);              }              else              {                     $_SESSION['user'] = 'Incorrect Username/Password!';              }      }}

Please all help is appreciated.[/FONT]


Edited by Livewire: Please do not post your passwords; there is no larger security hole than that.

 

[iSean]

Why don't you try with mysqli: http://sharefa.st/view/aEKZiyQ8NCu0

 

[descalzo]

$user = "dreamc90_dccReaD";

Access denied for user 'dreamc90_dccREAD'@'localhost'

There seems to be a mismatch.