Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Is the socket file just a location for mySQL to place the socket information? i.e. the file doesn't have to be there, as Mysql will create it when it runs. Am I understanding this correctly? [EMAIL PROTECTED] --- "Life must be lived as play." - Plato (427 - 347 BC) - Original Message - From: "Erik Price" <[EMAIL PROTECTED]> To: "Andrew Rich" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, April 25, 2002 10:01 PM Subject: Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) > > On Thursday, April 25, 2002, at 04:17 PM, Andrew Rich wrote: > > > > > Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) > > > > > > Any ideas ? > > You might need to specify the path to your socket file when you start > MySQL... did you specify a specific socket location at compile time? If > so, use that. > > It would look something like: > > /usr/local/mysql/bin/safe_mysqld --socket=/path/to/socket > > > Good luck > > > > > Erik Price > Web Developer Temp > Media Lab, H.H. Brown > [EMAIL PROTECTED] > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
On Thursday, April 25, 2002, at 04:17 PM, Andrew Rich wrote: > > Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) > > > Any ideas ? You might need to specify the path to your socket file when you start MySQL... did you specify a specific socket location at compile time? If so, use that. It would look something like: /usr/local/mysql/bin/safe_mysqld --socket=/path/to/socket Good luck Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)
George Pitcher ([EMAIL PROTECTED]) writes: > Similar for me. Except that I can do all the usual SQL stuff as root but if > I try and access via PHP I get the '/tmp/mysql.sock' missing message. > > Is a complete re-install of MySQL the only solution or is there something > else that can be done to solve this problem, which, from scanning archives, > is not an uncommon one. > > When charley enters "mysql", > > "Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)" > > message appears. > > > > Of course root can connect to mysql server with above command. That is > > there was no problem. Does /tmp/mysql.sock really exist? If not, the simplest solution is to "ln -s /var/lib/mysql/mysql.sock /tmp" or wherever mysql.sock is living. You can find this out by doing a "mysqladmin variables|grep socket". -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)
Similar for me. Except that I can do all the usual SQL stuff as root but if I try and access via PHP I get the '/tmp/mysql.sock' missing message. Is a complete re-install of MySQL the only solution or is there something else that can be done to solve this problem, which, from scanning archives, is not an uncommon one. George P, Edinburgh www.pingu.napier.ac.uk - Original Message - From: ½ÉÃ溸 <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 05, 2001 5:24 AM Subject: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2) > I installed linux and mysql 3.23.40. > Root installed and started mysql and user (charley) wants to connect mysql. > When charley enters "mysql", > "Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)" > message appears. > > Of course root can connect to mysql server with above command. That is > there was no problem. > > What's wrong with charley? > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)
Thank you for all your suggestions,
I got it.
the problem was in our web server because of security $ENV{HOME} doesnt
point to my home directory so my .my.cnf file was unreachable.
That's it.
may be It can be helpful for other people as well.
> my %attr = (
> PrintError =>0,
> RaiseError =>0
> );
>
> $dbh = DBI->connect(
> "DBI:mysql:array;mysql_read_default_file=$ENV{HOME}/.my.cnf",
> "root",
> "",
>\%attr);
> if (defined($dbh)){
> print "\n Connected successfully", $DBI::errstr;
> $rc = STATUS_OK;
> $dbh->disconnect;
> }
> else {
> print "\n $DBI::errstr\n";
> $rc = undef;
>
> }
>
--
Mohammadreza Shojatalab
European Bioinformatics InstituteTel: +44 (0)1223 494 669
EMBL Outstation Fax: +44 (0)1223 494 468
Wellcome Trust Genome Campus E-Mail: [EMAIL PROTECTED]
Hinxton, Cambridge URL: http://www.ebi.ac.uk/~shoja
CB10 1SD, UK
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)
I don't know for sure... perhaps, the apache+php binary just treats it differently than when interacting with it directly from the shell... I am a newbie and I just had the same problem 2 minutes ago... hope it works out... thanks, shawn On Tue, 29 May 2001, Mohammad Shoja wrote: > Thanks for your reply > The question is why in command line there is no problem? > > > It is looking for /tmp/mysql.sock and the one that exists is > > /tmp/mysql.sock.shoja > > > > Two different files.. It can't find what it is looking for. Try: > > > > safe_mysqld --socket=/tmp/mysql.sock > > > > and it should work > > > > I just had the same problem. > > > > thanks, > > shawn > > > > > > -- > Mohammadreza Shojatalab > European Bioinformatics InstituteTel: +44 (0)1223 494 669 > EMBL Outstation Fax: +44 (0)1223 494 468 > Wellcome Trust Genome Campus E-Mail: [EMAIL PROTECTED] > Hinxton, Cambridge URL: http://www.ebi.ac.uk/~shoja > CB10 1SD, UK > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)
Thanks for your reply The question is why in command line there is no problem? > It is looking for /tmp/mysql.sock and the one that exists is > /tmp/mysql.sock.shoja > > Two different files.. It can't find what it is looking for. Try: > > safe_mysqld --socket=/tmp/mysql.sock > > and it should work > > I just had the same problem. > > thanks, > shawn > > -- Mohammadreza Shojatalab European Bioinformatics InstituteTel: +44 (0)1223 494 669 EMBL Outstation Fax: +44 (0)1223 494 468 Wellcome Trust Genome Campus E-Mail: [EMAIL PROTECTED] Hinxton, Cambridge URL: http://www.ebi.ac.uk/~shoja CB10 1SD, UK - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)
> > [client] > port=3309 > socket=/tmp/mysql.sock.shoja > > Now the problem is when I'm trying to run my cgi from command prompt there > is no error and it connect successfully. > > But when I'm trying to run it through web browser I get this error > message: > > Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) > > and this is wondering because anyway my socket file is > '/tmp/mysql.sock.shoja' > It is looking for /tmp/mysql.sock and the one that exists is /tmp/mysql.sock.shoja Two different files.. It can't find what it is looking for. Try: safe_mysqld --socket=/tmp/mysql.sock and it should work I just had the same problem. thanks, shawn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
