PHP - Can't Connect To Mysql Server On 'example.com' (4)

Hi,

When i am trying to run one script on my web server, i get following error

Cannot connect to the database using the info you provided
Access denied for user 'My_Username'@'localhost' (using password: NO)

I filled all info like Host(localhost) Database name(created in cpanel) Username(created in cpanel) Password(i kept blank dont know where to find this)


You help will highly appreciate

Thanks,
Ravindra

Good Day    I have a bit of an issue with my website I loaded on my domain.   I am getting an error:   SQLSTATE[HY000] [1130] Host 'xxx.xxx.xx.xxx' is not allowed to connect to this MySQL server   Can some one please explain to me in detail how do fix this?   It only shows on my Sale and Rent pages    

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=319948.0

hi all, i have a test server (newest xampp) and the code works fine, as soon as i upload to 1and1 (they use apachi, php and mysql) i get this message: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
i have double checked username and passwords, had a look on google, contacted there support with no luck yet.
i am wondering if its a mysql or php version problem, so hoping someone knows when the following code with classes etc was added or if someone knows how to fix it i be really greatful.
heres some of the code i am using

class cyberglide {

var $host;

var $username;

var $password;

var $db;

function connect() {

$con = mysql_connect($this->host, $this->username, $this->password) or die (mysql_error());

mysql_select_db($this->db, $con) or die(mysql_error());

}

function get_top() {

        if (isset($_GET['page']))
 {

 

$page = $_GET['page'];

// Display Page.
                $sql = "SELECT title,body FROM content WHERE page = '$page' AND location = 'left' AND disabled = 'no' ORDER BY id";
                $res = mysql_query($sql) or die (mysql_error());
                while($row = mysql_fetch_assoc($res)){

echo '<h1>' . $row['title'] . '</h1>';

                    echo '<p>' . $row['body'] . '</p>';

}

}

        else
        {
                //Show Home Page
                $sql = "SELECT title,body FROM content WHERE page = 'home' AND location = 'left' AND disabled = 'no' ORDER BY id";
                $res = mysql_query($sql) or die (mysql_error());
                while($row = mysql_fetch_assoc($res)){

echo '<h1>' . $row['title'] . '</h1>';
                    echo '<p>' . $row['body'] . '</p>';  
                }

  }

}

function get_left() {

        if (isset($_GET['page']))
 {

 

$page = $_GET['page'];

// Display Page.
                $sql = "SELECT title,body FROM content WHERE page = '$page' AND location = 'left' AND disabled = 'no' ORDER BY id";
                $res = mysql_query($sql) or die (mysql_error());
                while($row = mysql_fetch_assoc($res)){

echo '<h1>' . $row['title'] . '</h1>';

                    echo '<p>' . $row['body'] . '</p>';

}

}

        else
        {
                //Show Home Page
                $sql = "SELECT title,body FROM content WHERE page = 'home' AND location = 'left' AND disabled = 'no' ORDER BY id";
                $res = mysql_query($sql) or die (mysql_error());
                while($row = mysql_fetch_assoc($res)){

echo '<h1>' . $row['title'] . '</h1>';
                    echo '<p>' . $row['body'] . '</p>';  
                }

}

}
}//Ends Our Class

db file

//Setup Our Connection Vars

$obj->host = 'localhost';

$obj->username = 'root';

$obj->password = '';

$obj->db = 'db361371865';
 
 

//Connect To Our Database

$obj->connect();

many thanks all.