title: MySQL login error warning
body: <p>I'm getting this login error: <code>Warning: mysqli::mysqli() [mysqli.mysqli]: (28000/1045): Access denied for user 'user'@client-ip' (using password: YES) in</code>.</p>
  
  <p>This happens no matter what I set in Cpanel.  I've reset the passwords, created new users with all privileges.</p>
  
  <p>I'm not that familiar with Cpanel but have created and reset user passwords for db users.</p>
  
  <p>Using Cpanel... Do not have hosting access.  Just FTP Access and access to Cpanel / PhpMyAdmin</p>
  
  <p>I have looked and looked and it only seems that this could be an install problem with the permissions table or something of the sort...  <a href="https://dev.mysql.com/doc/refman/5.1/en/access-denied.html" rel="nofollow">https://dev.mysql.com/doc/refman/5.1/en/access-denied.html</a></p>
  
  <p>Not sure if I can access the console.</p>
  
  <p>Here is my php for reference sake:</p>
  
  <pre><code>// try connect to the MySQL database
  $mysqli = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
  // var to check for duplicate txn - default false
  $exists = false;
  // check connection to database
  if ($mysqli-&gt;connect_errno) { // false - database doesn't exist
      $error = $mysqli-&gt;connect_errno;
  } else { // database exists
          $res = $mysqli-&gt;query("SELECT * FROM paypal_txn_log WHERE txn_id = '$txn_id'");
          $exists = $res-&gt;num_rows;
          // doesn't exist insert transaction number entry
          if (!$exists) {
              $time = date('Y-m-d H:i:s');
              $query = "INSERT INTO paypal_txn_log (txn_id, customer_email, datetime) VALUES ('$txn_id', '$payer_email', '$time')";
              $mysqli-&gt;query($query);
              $mysqli-&gt;close();
          }
  }
  </code></pre>