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 recentl
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 ->
/var/lib/mysq
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
i
ubject: Re: 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 sli
n create 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
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 ?
Than
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 b
gt; To: <[EMAIL PROTECTED]>
> Sent: Tuesday, December 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
TED]>
Sent: Tuesday, December 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
> 02
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: m
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 mys
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, p
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
EMAIL PROTECTED]]
> Sent: 15 October 2002 1:31 pm
> 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.
>
> A
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 s
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
"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,
I'm running RedHat 7.1 and I'm trying to run mysql. I've gone and run the
mysql_install_db then I try to run the mysqladmin -u root -p password
'new-password' and I get the following error:
error: 'Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)'
Check that m
, 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
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)
http:
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 /my
13/01 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 se
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 can
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 my
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 us
Mike
- 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 My
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 v
1. Start the server.
2. Put the proper socket location in php.ini.
Augusto Cesar Castoldi wrote:
> 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
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 mysql.soc
/to/socket option and
set the environment variable MYSQL_UNIX_PORT to the socket pathname before
starting your MySQL clients."
-Matt
::-Original Message-
::From: Matt Thoene [mailto:[EMAIL PROTECTED]]
::Sent: Friday, January 12, 2001 11:20 AM
::To: mySQL Mailing List
::Subject: can&#x
I know I'll probably get yelled at for something that is probably easy to
fix but I have spent a few days searching the archives, manual, etc and I've
been unable to find answers. When doing any kind of mysql command (e.g.
mysql -D database.sql) I get this error:
ERROR 2002: Can't connect to loc
32 matches
Mail list logo
