mySQL on mac (10.6.6) -- simple question

[maya90]

I just installed mySQL server on my mac (10.6.6); to set up followed instructions here:
Installing MySQL on Mac OS X « Thoughts by Techxplorer

am trying to connect with PHP, connection is failing, and have a feeling I have wrong server/host param..

$dbhost = "localhost:3306";
$dbuser = "root";
$dbpass = "<pswd>";
$dbname = "mydb";
$dbconn = mysql_connect($dbhost,$dbuser,$dbpass) or die("Could not connect");
print "Connected successfully<br>";


tried with and without port.. is 'localhost' correct for host? (in windows it would be, not sure about on the mac/unix..)

thank you..

[maya90]

tried to edit, didn't work.. now don't see 'edit' link...

url I meant to post was:
Installing MySQL on Mac OS X « Thoughts by Techxplorer

[maya90]

SOLVED -- it's 127.0.0.1, instead of localhost (connected from JSP/Tomcat now too.. in there can be either localhost or 127.0.0.1; but in PHP it has to be the IP addresss...)

(and, funny, don't need port (localhost:3306) like you do in windows... )

[guelphdad]

Doesn't need to be the IP address, it can be simply localhost you likely don't need the port number.

I've always used localhost in all the scripts I've written in PHP.

[maya90]

Doesn't need to be the IP address, it can be simply localhost you likely don't need the port number.

I've always used localhost in all the scripts I've written in PHP.

weird... I tried again with 'localhost' in PHP before posting my last response.. it didn't work... only works with the IP address...

thank you..

[guelphdad]

In mysql client run the following:

USE mysql;
SELECT user, host FROM user;

does it show 127.0.0.1 or localhost under the host column for the user you've logged in with?

Just realizing your setup may have the former rather than latter. haven't set up a mac in a while.

[maya90]

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select user, host from user;
+------+------------------------------------+
| user | host                               |
+------+------------------------------------+
| root | 127.0.0.1                          |
| root | ::1                                |
|      | <myName>s-MacBook-Pro.local        |
| root | <myName>s-MacBook-Pro.local        |
| root | localhost                          |
+------+------------------------------------+
5 rows in set (0.00 sec)

[guelphdad]

you see that you have both 127.0.0.1 and localhost for root user so both of them should work.

[maya90]

yes for some reason in PHP it only works with IP address.. I tried many times... (in JSP it works with both the IP add and 'localhost'....)

go figure...