Thanks, but do you mean change "localhost" to server ip address in my
php script or in the mysql user.host entry or both? (I tried just
changing the script -- that didn't work). The php script sits on the
same server as the mysql database, so using "root" and "localhost"
should be fine, shouldn't it?
from user table:
+------+------------------------+
| user | host |
+------+------------------------+
| root | gromit.fastcompany.com |
| root | localhost |
+------+------------------------+
Would I need to add another root entry with:
mysql> grant all on *.* to root@stripped identified by "my_password";
I also have two entries in the user table with no users or corresponding
passwords... how can I get rid of these?
+--------+------------------------+------------------+
| user | host | password |
+--------+------------------------+------------------+
| | localhost | |
| | gromit.fastcompany.com | |
+--------+------------------------+------------------+
Thanks!
Jarmo Paavilainen wrote:
>
> ...
> > not sure what user runs php. I know the mysql.sock is a common and
> > documented problem, but php is looking for mysql.sock in the right
> > place. I don't see any documentation or posts on the mail list archives
>
> Change your adress from "localhost" to whatever other valid (IP)adress your
> MySQL server is on. That solved it for me.
>
> // Jarmo
