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 locatio
1) Do you have a /etc/my.cnf ?
2) In this do you have the bind-address directive set?
i.e. [ bind-address = 127.0.0.1] this is the default for debian
packages versions.
3) Also confirm the my.cnf reflects the mysql.sock path properly as
well.
Robert Allen, zce
Operations, FIO Labs LLC
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 [mys
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 -u -p
mysql -h -u -p
mysql -hlocalhost -u -p
you may find the user permissions
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 -u -p # Rejected, obviously
mysql -h -D dbna
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 d
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
> - O
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
run
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