Re: problem with mysql.sock
I could be wrong but this may have something to do with ownership and permissions of the socket file. I recently upgraded my MySQL version and had basically the same problem. I can't remember though if I had to change the ownership to root.root or mysql.mysql. HTH, Ed On Mon, 26 Sep 2005, Sandhya Reddy wrote: > Hello, > I have recently installed FC3 and now I have > PHP(4.4.9) and MYSQL(3.23) which got installed along > with FC3. > I'm able to connect to MYSQL from command prompt. > But the problem fires when I do the same from a PHP > script. The error I get is "Can't connect to local > MySQL server through socket > '/var/lib/mysql/mysql.sock' (13)". > And I'm sure that MYSQL server is running and able tp > connect from command prompt. > > > > I have been searching on the net for the same from the > last 3 days but ended with nothing. > > > > I have changed php.ini to include the > mysql_default_socket=/var/lib/mysql/mysql.sock. > > > > even then it doen't work. > > Earlier I had FC1 and everthing was working fine! > > > > Could please suggest me a solution to tackle this > problem. > > Thanks in Advance > Sandhya > > > > > __ > Yahoo! Mail - PC Magazine Editors' Choice 2005 > http://mail.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: problem with mysql.sock
Hi Sandhya, Have you checked the permissions? The error message is System error: 13 = Permission denied. Is your PHP/Apache user able to connect via the socket? Try connecting as $ su -c "mysql -u -p" and see what happens. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Sandhya Reddy [mailto:[EMAIL PROTECTED] Sent: Tuesday, 27 September 2005 4:03 PM To: mysql@lists.mysql.com Subject: problem with mysql.sock Hello, I have recently installed FC3 and now I have PHP(4.4.9) and MYSQL(3.23) which got installed along with FC3. I'm able to connect to MYSQL from command prompt. But the problem fires when I do the same from a PHP script. The error I get is "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)". And I'm sure that MYSQL server is running and able tp connect from command prompt. I have been searching on the net for the same from the last 3 days but ended with nothing. I have changed php.ini to include the mysql_default_socket=/var/lib/mysql/mysql.sock. even then it doen't work. Earlier I had FC1 and everthing was working fine! Could please suggest me a solution to tackle this problem. Thanks in Advance Sandhya __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem with mysql.sock
Hello, I have recently installed FC3 and now I have PHP(4.4.9) and MYSQL(3.23) which got installed along with FC3. I'm able to connect to MYSQL from command prompt. But the problem fires when I do the same from a PHP script. The error I get is "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)". And I'm sure that MYSQL server is running and able tp connect from command prompt. I have been searching on the net for the same from the last 3 days but ended with nothing. I have changed php.ini to include the mysql_default_socket=/var/lib/mysql/mysql.sock. even then it doen't work. Earlier I had FC1 and everthing was working fine! Could please suggest me a solution to tackle this problem. Thanks in Advance Sandhya __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with mysql.sock
Hi I need to know how and where to tell mysql to look for mysql.sock. I am using mysql version 3.23.55 and SUSE Linux 8.2. My problem is that i have a mysql daemon working very well and using /var/lib/mysql/mysql.sock as the correct socket. No problems. My problems come when I try and install the perl msql-mysql modules. It asks for my mysql directory, which is /usr/local/mysql/. I can only assume that it then tries to execute /usr/local/mysql/bin/mysql, and guess what? For some reason it tries to connect through the default /tmp/mysql.sock, which doesn't exist and everything fails. SO whats going on? Why, when i execute /usr/bin/mysql does mysql look to /var/lib/mysql/mysql.sock and when I execute /usr/local/mysql/bin/mysql, does it look to /tmp/mysql.sock? How can I set BOTH to look at /var/lib/mysql/mysql.sock? I tried mysql_config --socket /var/lib/mysql/mysql.sock, but all that does is repeat the usage message for mysql_config. Help me, I am confused! Thanks Mick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]