php mysql database connection issue

Question

When i upload db.php page to the server it's say

Warning: mysql_connect() [function.mysql-connect]: Access denied for user     
'somename'@'somenumber' (using password: YES) in /home/somename/public_html/db/db.php on 
line 2 Could not connect to Server: Access denied for user 'somename'@'somenumber' 
(using password: YES)

Why it's say ?

db.php code:

<?php   
$db = mysql_connect('www.mysite.com', 'somename', 'password'); 
if (!$db)         
{
die('Could not connect to Server: ' . mysql_error());
}
if (!mysql_select_db("datbasename",$db))
{
die('Could not connect to DataBase : ' . mysql_error());
}
?>

@OliCharlesworth But i can access cpanel with that username and password. — user1161867
– user1161867, Commented Jan 22, 2012 at 18:34
I don't know PHP much, but can you see how here connection is made... stackoverflow.com/a/8951736/1066828 — Fahim Parkar
– Fahim Parkar, Commented Jan 22, 2012 at 18:37

dev-null-dweller · Accepted Answer · 2012-01-22 18:39:22Z

1

In mysql it' not only username and password, but also host that matters while connecting.

Your username and password may work for localhost but to connect from host1.someserver.com you will need different credentials.

In your case @'somenumber' may be IP address that you are connecting from, ensure that username you are using is allowed to connect from this IP.

answered Jan 22, 2012 at 18:39

dev-null-dweller

29.5k3 gold badges68 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user1161867 Over a year ago

well, @dev-null-dweller, But i can access with that username and password. so that i use in db.php code: Host= www.mysite.com, Username= myusername and password= password. But Error..!!

dev-null-dweller Over a year ago

You can acces your database from one host, but as i said this credentials may not work when connecting from other hosts. Instead of blindly trying to connect, contact your hosting provider to get more help.

Wouter J · Accepted Answer · 2012-01-22 18:33:52Z

0

You cannot access to the database because your usename + password aren't correct.

answered Jan 22, 2012 at 18:33

Wouter J

42k15 gold badges113 silver badges114 bronze badges

1 Comment

user1161867 Over a year ago

But i can access cpanel with that username and password.

Fahim Parkar · Accepted Answer · 2012-01-22 18:34:41Z

0

line 2 Could not connect to Server: Access denied for user 'somename'@'somenumber' says CLEARLY, access is denied for the user somename. Get privileges to get connected first...

Good Luck!!!

answered Jan 22, 2012 at 18:34

Fahim Parkar

31.8k46 gold badges169 silver badges285 bronze badges

Comments

Shankar Narayana Damodaran · Accepted Answer · 2012-01-22 18:39:03Z

0

Either the password is wrong or you don't have enough privileges for the user.

Try with username as "root" and password as "" and see if it works, otherwise you are doing it wrong.

answered Jan 22, 2012 at 18:39

Shankar Narayana Damodaran

68.6k43 gold badges102 silver badges129 bronze badges

2 Comments

user1161867 Over a year ago

Well, @sh4nx0r i'm trying this.

user1161867 Over a year ago

it's say access denied for user 'root'

Pruthvi Raj Nadimpalli · Accepted Answer · 2013-05-13 09:53:20Z

0

In mysql_connect('www.mysite.com', 'somename', 'password');

you will need to give your database hostname, not your site hostname.

Check with your hosting provider for database hostname.

It is localhost if database is on same server/machine.

answered May 13, 2013 at 9:53

Pruthvi Raj Nadimpalli

1,3731 gold badge16 silver badges31 bronze badges

Collectives™ on Stack Overflow

php mysql database connection issue

5 Answers 5

2 Comments

1 Comment

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

1 Comment

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related