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:
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
mysql> grant all privileges on wes.* to user@localhost identified by
Query OK, 0 rows affected (0.08 sec)
I then created a bit of PHP to test this...
$dbhost = 'localhost';
$dbuser = 'user';
$dbpass = 'changeme';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error
connecting to mysql');
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,