PHP connection problem to MySQL using hostname

Question

when I try to connect to a MySql database using the actual hostname of the server I receive the following message:

mysql_connect(): Access denied for user 'user'@'ip-...-.internal' (using password: YES) in /home/[username]/sendtitles.php on line 8

Namely,

$conn = mysql_connect("localhost",$user,$password); //WORKS!

$conn = mysql_connect($actual_hostname ,$user,$password); //Doesn't work :(

I would appreciate your help on understanding why that happens.

Where do you set $actual_hostname and what's its value? Change this code $conn = mysql_connect($actual_hostname ,$user,$password); to this var_dump($actual_hostname); //$conn = mysql_connect($actual_hostname ,$user,$password); and tell us what's the output? — Shef
– Shef, Commented Jul 17, 2011 at 18:08

BlueDog · Accepted Answer · 2011-07-17 18:08:34Z

7

Your MySQL user can only connect from localhost. To change this, have a look the GRANT command. On a side note I would suggest using a dedicated user for the database instead of root for this.

answered Jul 17, 2011 at 18:08

BlueDog

9768 silver badges15 bronze badges

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

1 Comment

Vasilis Over a year ago

Thanks for the answer, it's the correct but I accepted the oldest. The funny thing is that both attempts where from the same machine that hosts the db, and the acl permitted: username - localhost When I used the hostname the user was perceived as external while when I used localhost I had no problem.

Jules · Accepted Answer · 2011-07-17 18:09:03Z

1

You should (almost) always use "localhost" as your hostname.

Your actual host name might be referring to something else. For example... Your website is being hosted on some (shared) server. But when your "actual hostname" is "www.website.com", this URL is redirected to your webserver through its DNS. But obviously, this is not the exact address where your website is hosted. That might be something like "http://www.hosting.com/web/data/yourwebsite".

So either you use "localhost" or you should use the exact direct URL as given to you by your webhost.

answered Jul 17, 2011 at 18:09

Jules

7,2236 gold badges28 silver badges51 bronze badges

Comments

Aleksey Korzun · Accepted Answer · 2011-07-17 18:08:37Z

0

Your root is setup with ACL's to allow authentication requests from a specific IP/host.

Review: http://dev.mysql.com/doc/refman/5.1/en/adding-users.html

answered Jul 17, 2011 at 18:08

Aleksey Korzun

6904 silver badges7 bronze badges

Comments

user756245 · Accepted Answer · 2011-07-17 18:09:13Z

0

I think the problem comes either from $actual_hostname, which can contain a mistake, or from $user and $password, those aren't maybe the same as on your local db.
Log these values, and check them.

answered Jul 17, 2011 at 18:09

user756245

Comments

Inactive · Accepted Answer · 2011-07-17 18:14:10Z

-1

perhaps $actual_hostname is not string ..check ... properly .. output it . One more recommendation is to define such variables as CONSTANT . like

define ("DB_SERVER","localhost");
define ("DB_USER","root");
define ("DB_PASS","password");

answered Jul 17, 2011 at 18:14

Inactive

7110 bronze badges

Collectives™ on Stack Overflow

PHP connection problem to MySQL using hostname

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related