Greetings all,
I recently upgraded from mysql 3.23 to 4.0 on a Fedora box. I moved
the old installation to a directory called old_mysql in my home
directory. I can start the new installation using mysqld_safe .
Now, when I try to do something like:
/new/install/mysqladmin -u root -p version
The correct way to deal with this is to edit /etc/my.cnf and, in the
mysqld section set the location of the socket.
[mysqld]
socket = /tmp/mysql.sock
if there are other systems expecting it to be at the new location, a
simple end run might be to create a link at /tmp/mysql.sock -
Okay, so what I did to solve this was:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
That seems like a bit of a hack though. The my.cnf file has this line:
socket=/var/lib/mysql/mysql.sock
Anyone know why it's looking in /etc ?
On Jul 14, 2004, at 4:53 PM, Jough P wrote:
Greetings all,
I
: Need Help About mysql.sock ERROR
You have several options, here is, I think, the easiest:
First you need to locate the sock file. The location depends on the
distribution (in my system is in /tmp). Use find / -name mysql.sock. On
some distributions the name can be slightly different, for example
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
I use MDK 8.2 and MySQL 4.0.13
i found this error
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
Can anyone help me to solve this problem ?
a symbolic link in '/var/lib/mysql/' pointing mysql.sock
Ernesto
- Original Message -
From: Pratchaya Chatuphian [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 09, 2003 11:50 PM
Subject: Need Help About mysql.sock ERROR
ERROR 2002: Can't connect to local MySQL server through
Hello.
On Fri 2002-12-06 at 14:32:13 -0600, [EMAIL PROTECTED] wrote:
after trying this it shows mysql as running, but /tmp/mysql.sock as
not being created. i stopped mysql and then started it again, and
the same thing happened...still no mysql.sock? should i just
reinstall? what is the best
, 2002 4:16 PM
Subject: mysql.sock error
at first when trying to run mysql it did this:
[root@shadow mysql]# bin/safe_mysqld --user=mysql
[1] 3124
[root@shadow mysql]# Starting mysqld daemon with databases from
/var/lib/mysql
021121 02:27:42 mysqld ended
[1]+ Done
at first when trying to run mysql it did this:
[root@shadow mysql]# bin/safe_mysqld --user=mysql
[1] 3124
[root@shadow mysql]# Starting mysqld daemon with databases from /var/lib/mysql
021121 02:27:42 mysqld ended
[1]+ Donebin/safe_mysqld --user=mysql
then, i stopped
Check if mysql is started by entering
ps -ax | grep -i mysql
If not started try:
service mysql start
Adolfo
-Original Message-
From: Jeff Hollingshead [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 5:17 PM
To: [EMAIL PROTECTED]
Subject: mysql.sock error
03, 2002 4:16 PM
Subject: mysql.sock error
at first when trying to run mysql it did this:
[root@shadow mysql]# bin/safe_mysqld --user=mysql
[1] 3124
[root@shadow mysql]# Starting mysqld daemon with databases from
/var/lib/mysql
021121 02:27:42 mysqld ended
[1]+ Done
Hi,
Iam back on this list after being diverted by job change - moving house etc.
I've just set up one of my machines with Mandrake 9.0 and went for the
included MySQL install (3.23).
When I try to do anything I get an error saying that the 'mysql.sock' could
not be found.
I remember that this
George,
Tuesday, October 15, 2002, 2:55:14 PM, you wrote:
GP Iam back on this list after being diverted by job change - moving house etc.
GP I've just set up one of my machines with Mandrake 9.0 and went for the
GP included MySQL install (3.23).
GP When I try to do anything I get an error
To: George Pitcher; [EMAIL PROTECTED]
Subject: RE: Getting started - mysql.sock error
When I try to do anything I get an error saying that the
'mysql.sock' could
not be found.
Actually, you probably got a more detailed error message than
this. Try posting the entire error message - I
George,
Tuesday, October 15, 2002, 5:09:47 PM, you wrote:
GP Its slightly difficult doing it exactly as my email is on my W2K laptop -
GP but here goes:
GP error: 'Can't connect to local MySQL server through socket
GP '/var/lib/mysql/mysql.sock' (2)'
GP Check that mysqld is running and that the
Egor,
Run
ps ax | grep mysqld
to see if mysqld is already running.
This returns '11276 pts/1S 0:00 grep mysql'
I have checked and cannot find mysql.sock anywhere.
Cheers
George
-
Before posting, please
Jay Paulson [EMAIL PROTECTED] writes:
I'm running RedHat 7.1 and I'm trying to run mysql. I've gone and run the
mysql_install_db
Not good. If you had just started the script, it would have been done
automatically - as it is, you created a set of files you can't access
(root owns them, the
I'm trying to start my first ever installation of mysql, so I've installed
the tar.gz (3.23.42 on Linux) and I've run ./configure from /mysqlhome when
I try to star the server I get the following message
Can't connect ot local MySQL server through socket '/tmp/mysql.sock'
When I do a find I
13:58
SUBJECT: mysql.sock error
I'm trying to start my first ever installation of mysql, so I've installed
the tar.gz (3.23.42 on Linux) and I've run ./configure from /mysqlhome when
I try to star the server I get the following message
Can't connect ot local MySQL server through socket '/tmp
the sock file is in the /usr/lib/mysql dir i created a symlink of the
file from there to /tmp
On Thu, 2001-09-13 at 14:32, Nick Torenvliet wrote:
I'm trying to start my first ever installation of mysql, so I've installed
the tar.gz (3.23.42 on Linux) and I've run ./configure from
Nick Torenvliet wrote:
...I've run ./configure
Did you run 'make'?
---
Rodney Broom
Programmer: Desert.Net
Keywords: sql, spam-off
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
, September 13, 2001 1:32 PM
To: Mysql (E-mail)
Subject: mysql.sock error
I'm trying to start my first ever installation of mysql, so I've installed
the tar.gz (3.23.42 on Linux) and I've run ./configure from /mysqlhome when
I try to star the server I get the following message
Can't connect ot local
I had the same problem with suse 7.2. I see that the path to mysql.sock
is /var/lib/mysql/mysql.sock. this location of mysql.sock was a leftover
from the mysql that i installed from the distribution. the downloaded
version though stores the mysql.sock in /tmp/mysql.sock - i had to tell
a few of
I am having trouble with mysql... i keep getting
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
I uninstalled and reinstalled MySQL rpm (RH 7.1). I originally I was
able to connect to MySQL server via command line client, but could not
connect
- Original Message -
From: adam [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 8:39 PM
Subject: help with mysql.sock error
I am having trouble with mysql... i keep getting
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2
adam [EMAIL PROTECTED] writes:
I am having trouble with mysql... i keep getting
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
You probably didn't start it the correct way, by using the included
initscript (/etc/init.d/mysqld, also usable by
I'm receiving the following error:
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (111) in
/home/httpd/html/phpadmin2/lib.inc.php on line 119
what could be?
thanks,
Augusto
My database was working fine then the server crashed and now I am getting
this error:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)
I have checked and verified that the file exists:
srwxrwxrwx 1 root root0 Jan 16 23:00
28 matches
Mail list logo