How to get PHP and MySQL to play nice

[ericdesouza]

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

[dulitha]

Hi,

Try to run this query for database..
GRANT USAGE ON * . * TO 'user'@'localhost' IDENTIFIED BY 'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

Regards,
Dulitha