List:General Discussion« Previous MessageNext Message »
From:kfarmer Date:March 18 1999 7:55pm
Subject:ERROR 2002: Can't connect to local MySQL server (2)
View as plain text  
>Description:

This is the second time I setup MySql.  I had a hard drive crash and re-installed.  I lost
all of /usr/local.  I'm using the binary version for Solaris 2.6.  I've read thru all the
docs related to this error.  mysqld.sock does exist and mysqld is running as seen below. 
I have done nothing special beyond install instructions. One thing that is strange is it
stating domain name when doing mysqladmin -h widow version, is that normal?

Am at a stand-still. Any help would be appreciated.

>How-To-Repeat:

widow# mysql test
ERROR 2002: Can't connect to local MySQL server (2)

widow# mysqladmin -h localhost version
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

widow# mysqladmin -h widow version
mysqladmin: connect to server at 'widow' failed
error: 'Host 'widow.farmer.org' is not allowed to connect to this MySQL server'

widow# ls -l /tmp
total 536
srwxrwxrwx   1 root     other          0 Mar 18 13:54 mysqld.sock

widow# ps -ef | grep mysql
root  1634  1246  0 13:54:42 pts/6    0:00 /bin/sh /usr/local/mysql/bin/safe_mysqld
root  1638  1634  0 13:54:42 pts/6    0:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/usr/local/mys

>Fix:
unknown

>Submitter-Id:	<submitter ID>
>Originator:	Super-User
>Organization:
 
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:	
>Severity:	
>Priority:	
>Category:	mysql
>Class:		
>Release:	mysql-3.22.20a (TCX binary)

>Environment:
	
System: SunOS widow 5.6 Generic_105181-12 sun4m sparc SUNW,SPARCstation-5
Architecture: sun4

Some paths:  /usr/local/bin/perl /usr/ccs/bin/make /usr/local/bin/gcc /usr/ucb/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.8.1/specs
gcc version 2.8.1
Compilation info: CC='gcc'  CFLAGS='-O3 -fomit-frame-pointer'  CXX='gcc'  CXXFLAGS='-O3
-fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'  LDFLAGS=''
Configure command: ./configure  --prefix=/usr/local/mysql '--with-comment=TCX binary'
--with-low-memory --disable-shared
Perl: This is perl, version 5.004_04 built for sun4-solaris
Thread
ERROR 2002: Can't connect to local MySQL server (2)kfarmer18 Mar
  • ERROR 2002: Can't connect to local MySQL server (2)Michael Widenius19 Mar