Webmaster Forum / PHP / Database Access / September 2008

Hi all.  Can't seem to get PHP to play nice with MySQL.

First I logged into MySQL, created the db, switched to it and then
granted (what I thought were) correct privileges:

----[%begin%]----

Macintosh-7:~ jason$ /usr/local/mysql/bin/mysql -u root

mysql> create database wes;
Query OK, 1 row affected (0.00 sec)

mysql> use wes
Database changed

mysql> grant all privileges on wes.* to user@localhost identified by
'changeme'
   -> ;
Query OK, 0 rows affected (0.08 sec)

----[%end%]----

I then created a bit of PHP to test this...

----[%begin%]----

<?php

$dbhost = 'localhost';
$dbuser = 'user';
$dbpass = 'changeme';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error
connecting to mysql');

?>

----[%end%]----

But when I access that PHP page, I get:

Warning: mysql_connect() [function.mysql-connect]: Can't connect to
local MySQL server through socket '/var/mysql/mysql.sock' (2) in /
Library/WebServer/Documents/wes/mysql_test.php on line 7
Error connecting to mysql

Any thoughts on what I'm doing wrong?  I have checked to make sure
Apache and PHP are running.  I can access scripts through localhost
just fine, the problem is only with MySQL.

Thanks much in advance,
Jason