views:

53

answers:

1
+1  Q: 

mysql_connect()

I am trying to connect to mysql and am getting an error. I put my servers ip address in and used port 3306 whihch post should be used?

<?php

$connection = mysql_connect("serer.ip:port", "user", "pass")
 or die(mysql_error());

 if ($connection) {$msg = "success";}
?>

<html>
<head>
</head>
<body>

<? echo "$msg"; ?>

</body>
</html>

Here is the error its producing

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'user'@'localhost' (using password: YES) in /home/admin/domains/domain.com.au/public_html/db_connect.php on line 3
Access denied for user 'user'@'localhost' (using password: YES)
+6  A: 

Use

$conn = mysql_connect($db_host,$db_user, $db_pass) or die("Error connecting to database");

The port is automatically selected as 3306.

Also double check to make sure your username and password for connecting are correct and allowed access.

Josh K
I was using my cpanel user and password not MYSQL, me = idiot!, thanks @Josh K
Jacksta