Hi,
I am running PHP 5.0.4 and MySQL 4.1.3a. (+Apache 2.0.54) When I run a
PHP script that attempts to connect to MySQL I get the following
error:
Database ERROR:Can't connect to local MySQL server through socket
'/usr/local/mysql/tmp/mysql.sock' (13)
I have placed my socket file on such
Thank you Robert for the prompt response.
1) Yes, I do have /etc/my.cnf (644 permission)
2) I do have a bind-address directive but it was set to 127.0.0.0 by
default. I even changed it to 127.0.0.1 and restarted MySQL; no
luck.
3) my.cnf's socket file path and name in both [client] and
Comment out the bind-address this allows mysqld to bind to all IPs;
accordingly determine if you only want it local or externally available.
Finally attempt to connect to the mysql server using the
mysql -h127.0.0.1 -uusername -p
mysql -hpublicIP -uusername -p
mysql -hlocalhost -uusername -p
I commented out the bind-address and restarted MySQL. Still refuses to
make connection through Unix socket. And for permissions, they came
back as I was expected; I have created my mysql user to have access to
localhost so:
mysql -h127.0.0.1 -D dbname -uusername -p # Rejected, obviously
mysql
Thanks for your help Bastien.
I have changed the authentication procedure but have come up against another
problem.
This time I am allowing the users to choose their unique usernames and
passwords which
will be stored in a mysql database. However when I check to see if their
details exist
in the
Roger,
Do you mean /etc/hosts? I do have /etc/hosts with the following entries:
127.0.0.1 localhost
127.0.0.1 myhostname.myhostname myhostname
On 8/30/05, Roger Villarreal [EMAIL PROTECTED] wrote:
Evan
Is there an entry in your /etc/host file for localhost?
roger
- Original
Thank you Roger,
Yes, I can ping my localhost, designated LAN IP, and 127.0.0.1 just fine.
No, I do not run any DNS server on the machine that I am having this
problem. The whole point of using locahost Vs. 127.0.0.1 is to avoid
the overhead of TCP by using Unix socket file. A system that I'm
I would like to get text from MS word using COM.
My plat form is Windows 2003 server.
Do suggest me to retrieve text!!
Yui
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php