hi experts
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
iam facing the above error while connecting the mysql database. i am also
checked the mysql.sock socket file is not in /tmp.
could you please help me to fix this problem. what i have to do
The socket hets created when you start the server
It might be in the mysql home dir, it might be in /var/run.
See if its declared in my.cnf
Sent via BlackBerry from T-Mobile
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi
thanks for your reply.
i found the problem, the problem was due to maintenance activity IT team
rebooted the machine but they didn't start the mysql server after reboot.
i executed mysqld with root credit. i got the below output but still the
cursor not return to prompt
bash-2.03#
in, changed root password, used test database, etc.
Now after reboot I cannot connect. I get this:
[EMAIL PROTECTED]:/usr/local/mysql/bin # ./mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
Please give
# ./mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
Please give options if this involves: manual server start, setting up
autostart, etc.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
.
- 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
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Any ideas ?
-Original Message-
From: Shaun Bramley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 25 April 2002 11:45 PM
To: [EMAIL PROTECTED]
Subject: Upgrade of mySQL on a Red Hat 7.2 - box
Ladies and Gentleman
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
, 2002 2:56 PM
Subject: Re: ERROR 2002: Can't connect to local
MySQL server through socket
'/tmp/mysql.sock' (2)
On Tue, 26 Mar 2002, colin o wrote:
Same thing happens to me,
i just use bin/safe_mysqld --user=root
to start to server so that i can use mysql.
I don't know
PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, March 26, 2002 2:56 PM
Subject: Re: ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
On Tue, 26 Mar 2002, colin o wrote:
Same thing happens to me,
i just use bin/safe_mysqld --user=root
to start to server so
What would cause this error to occur all of a sudden?
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
Server: Mac OS X 10.1.3
-
Before posting, please check:
http://www.mysql.com
2002: Can't connect to local MySQL server
through socket
'/tmp/mysql.sock' (2)
Server: Mac OS X 10.1.3
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
Yrabedra [EMAIL PROTECTED] wrote:
What would cause this error to occur all of a
sudden?
ERROR 2002: Can't connect to local MySQL server
through socket
'/tmp/mysql.sock' (2)
Is the socket? It should show up in a directory listing of /tmp - if it
isn't there then mysqld isn't running
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
,
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
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
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,
[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
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 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
20 matches
Mail list logo