Hi
you have to see the reason in the mysql log file,
that is a file either in the datadir with .err extension or in the /var/log
directory.
tail the last 30 lines you will see the reason why it failed to start.
Claudio
2012/4/11 Prabhat Kumar
> did you check permission of file /var/run/mysqld/
did you check permission of file /var/run/mysqld/mysqld.sock
On Wed, Apr 11, 2012 at 9:48 AM, Larry Martell wrote:
> On Wed, Apr 11, 2012 at 2:51 AM, Ganesh Kumar wrote:
> > Hi Guys,
> >
> > I am using debian squeeze it's working good, I am trying to install
> > mysql-server. mysql-server instal
On Wed, Apr 11, 2012 at 2:51 AM, Ganesh Kumar wrote:
> Hi Guys,
>
> I am using debian squeeze it's working good, I am trying to install
> mysql-server. mysql-server installation successfully but didn't start
> service
> root@devel:/var/run# more /etc/mysql/my.cnf |grep socket
> # Remember to edit
Il 11/04/2012 10:51, Ganesh Kumar ha scritto:
Hi Guys,
I am using debian squeeze it's working good, I am trying to install
mysql-server. mysql-server installation successfully but didn't start
root@devel:~# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL databa
7. It has
>> been
>> up and running under load for quite some time. I am using xtrabackup for
>> backups and suddenly three or four days ago backup stop running.
>>
>> Investigation shows that the socket file '/tmp/mysql.sock' is no longer
>> there. T
ago backup stop running.
>
> Investigation shows that the socket file '/tmp/mysql.sock' is no longer
> there. The mysql server itself is still functioning .. you can specify
> --host=localhost instead of --socket=/tmp/mysql.sock so the mysql client
> uses tcp/ip instead of the socket fil
Take one perfectly functional production server running 5.0.77. It has been
up and running under load for quite some time. I am using xtrabackup for
backups and suddenly three or four days ago backup stop running.
Investigation shows that the socket file '/tmp/mysql.sock' is no longer
ircumvention or permanent fix. Why is it pointing to a
/tmp/Mysql.sock when one socket exists in /var/lib/Mysql
*From:* Claudio Nanni [mailto:claudio.na...@gmail.com]
*Sent:* Wednesday, November 04, 2009 2:54 AM
*To:* Brown, Charles
*Cc:* mysql@lists.mysql.com
*Subject:* Re: RE: socket '/t
ey, Robert L; mysql@lists.mysql.com
Subject: socket '/tmp/mysql.sock' (2)
Hello All, I desperately need your help. I migrated from version 5.0.27 To
version 5.0.77 Here ...
From: Brown, Charles
Sent: Tuesday, November 03, 2009 2:54 PM
To: Ramsey, Robert L; mysql@lists.mysql.com
Subject: socket '/tmp/mysql.sock' (2)
Hello All, I desperately need your help.
I migrated from version 5.0.27
To version 5.0.77
H
these messages:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
My question is, is it possible that I have destroyed ( clobbered) the MYSQL
catalog via my migration process?
Can someone
/usr/local/mysql/libexec/mysqld -u root
091027 15:35:09 InnoDB: Started; log sequence number 0 625687
091027 15:35:10 [Note] /usr/local/mysql/libexec/mysqld: ready for
connections.
Version: '5.0.51-log' socket: '/tmp/mysql.sock' port: 3306 Source
distribution
can you verify thi
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:http://lists.mysql.com/
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. wh
--prefix=/home/qsys/mysql-5.1.32 \
--with-unix-socket-path=/home/qsys/mysql-5.1.32/tmp/mysql.sock
make
make install
mkdir /home/qsys/mysql-5.1.32/var
/home/qsys/mysql-5.1.32/bin/mysql_upgrade
at this point I get mysqlcheck: Got error 202: Can't connect to local MySQL
server through s
-socket-path=/home/qsys/mysql-5.1.32/tmp/mysql.sock
make
make install
mkdir /home/qsys/mysql-5.1.32/var
/home/qsys/mysql-5.1.32/bin/mysql_upgradeat this point I get mysqlcheck: Got
error 202: Can't connect to local MySQL server through socket
'/home/qsys/mysql-5.1.32/temp/mysql.sock'
Make sure your mysqld is running
On Fri, Apr 4, 2008 at 3:24 AM, Joerg Bruehe <[EMAIL PROTECTED]> wrote:
> Hi,
>
>
> Vidal Garza wrote:
>
> > [[...]]
> >
> > I have a cuestion, where do you find the system header files error
> > number (61)?
> >
>
> I do that brute-force:
>
> #! /bin/sh
> #
>
Hi,
Vidal Garza wrote:
[[...]]
I have a cuestion, where do you find the system header files error
number (61)?
I do that brute-force:
#! /bin/sh
#
# FGIN shell script to use "fgrep" on all
"/usr/include/h" files
#
# $1, $2, ... options and arguments given to "fgr
Krishna Chandra Prajapati escribió:
Just try mysqladmin ping that whether mysql is working or not
Krishna
On Thu, Apr 3, 2008 at 5:45 AM, Vidal Garza <[EMAIL PROTECTED]> wrote:
Hi...
I need test mysql connections but i have a problem...
freebsd# uname -a
FreeBSD freebsd.aduanet.net 6.3-RE
ySQL server through socket '/tmp/mysql.sock' (61)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
[[...]]
That 61 is not for decorative purposes, it has a significance.
Search your system header files for the error number 61, it
reeBSD 6.3-RELEASE #0: Wed Jan 16
> 04:18:52 UTC 2008 [EMAIL PROTECTED] [EMAIL PROTECTED]>:/usr/obj/usr/src/sys/GENERIC i386
> freebsd# mysql --version
> mysql Ver 14.12 Distrib 5.0.51a, for portbld-freebsd6.3 (i386) using 5.2
> freebsd# more /var/db/mysql/my.cnf
> [CLIENT]
&
14.12 Distrib 5.0.51a, for portbld-freebsd6.3 (i386) using 5.2
freebsd# more /var/db/mysql/my.cnf
[CLIENT]
port = 3306
socket = /tmp/mysql.sock
[MYSQLD]
port = 3306
ndbcluster
socket = /tmp/mysql.sock
query_cache_type = 1
query_cache_size = 26214400
ndb-connectstring=192.168.6.1
max_user_connections
gs >/dev/null
> >>> [ $? -eq 0 ] && chown -R ${mysql_user}:${mysql_user}
> >>>
> >> ${mysql_dbdir}
> >>
> >>> }
> >>>
> >>> mysql_prestart()
> >>> {
> >>> if [ ! -d "
Hi,
I dont know about network, but I know using php we cant access anything in
MySQL once the file is gone. When it happens again, ill be sure to check
network.
Cheers
Ian
On Fri, Feb 29, 2008 at 12:54 PM, Sebastian Mendel <[EMAIL PROTECTED]>
wrote:
> Ian schrieb:
> > Hi,
> >
> > I wouldnt have
Ian schrieb:
Hi,
I wouldnt have thought so but whenever that file is missing and try the
stop/restart it just sits at the waiting for pids part of the stop loop
(where it lists the pids), and it never stops the server - i have left it
for over an hour and it never stops - just keeps on in the st
.
Cheers
Ian
On Fri, Feb 29, 2008 at 12:43 PM, Sebastian Mendel <[EMAIL PROTECTED]>
wrote:
> Ian schrieb:
> > Hi,
> >
> > I am running mysql 5.0.45 on freebsd 4.11 and for some strange reason
> > /tmp/mysql.sock keeps on disappearing and we are forced to kill -9 mysq
Ian schrieb:
Hi,
I am running mysql 5.0.45 on freebsd 4.11 and for some strange reason
/tmp/mysql.sock keeps on disappearing and we are forced to kill -9 mysql and
restart it causing db corruptions as there is no other way of telling it to
stop once that file has gone. I have tried to find any
return 0
> > fi
> > }
> >
> > run_rc_command "$1"
> >
> > In rc.conf we have:
> > mysql_enable="YES"
> > mysql_args="--myisam-recover=BACKUP,FORCE"
> >
> > Here is the ps of it running:
> > # ps
Hi,
No, there is nothing in there cleaning /tmp. Mind you, further investigating
there are still some temp files in there from last year - so the directory
isnt getting wiped clean.
Thanks :)
On Fri, Feb 29, 2008 at 3:36 AM, Steve Bernacki <[EMAIL PROTECTED]>
wrote:
> Does the system in questio
Does the system in question have some type of "/tmp" cleaner script that
might be removing the socket file? Check /etc/crontab and root's crontab
(crontab -l)
Steve
name.pid
--myisam-recover=BACKUP,FORCE
78548 p0- S180:27.77 /usr/local/libexec/mysqld
--defaults-extra-file=/var/db/mysql/my.cnf --basedir=/usr/local
--datadir=/var/db/mysql --user=mysql --pid-file=/var/db/mysql/hostname.pid
--port=3306 --socket=/tmp/mysql.sock --myisam-recover=BACKUP,FORCE
W
9 p0- I 0:00.01 /bin/sh /usr/local/bin/mysqld_safe
--defaults-extra-file=/var/db/mysql/my.cnf --user=mysql
--datadir=/var/db/mysql --pid-file=/var/db/mysql/hostname.pid
--myisam-recover=BACKUP,FORCE
78548 p0- S180:27.77 /usr/local/libexec/mysqld
--defaults-extra-file=/var/db/mysql/my.cnf --
--bind-address=$ip --port=$port --sock=$sockfile &
Ian escribió:
Hi,
I am running mysql 5.0.45 on freebsd 4.11 and for some strange reason
/tmp/mysql.sock keeps on disappearing and we are forced to kill -9 mysql and
restart it causing db corruptions as there is no other way of telling it
Hi,
I am running mysql 5.0.45 on freebsd 4.11 and for some strange reason
/tmp/mysql.sock keeps on disappearing and we are forced to kill -9 mysql and
restart it causing db corruptions as there is no other way of telling it to
stop once that file has gone. I have tried to find any reason why this
On 20 Jul 2006 at 16:56, Vitaliy Okulov wrote:
> , Deniss.
>
> 20 2006 ., 15:59:10:
>
> > Hi All
>
> > While I am doing portupgrade -vr mysql on freebsd server
>
> > than mysql socket"/tmp/mysql.sock" is invisible on, so mysql cant be start
Здравствуйте, Deniss.
Вы писали 20 июля 2006 г., 15:59:10:
> Hi All
> While I am doing portupgrade -vr mysql on freebsd server
> than mysql socket"/tmp/mysql.sock" is invisible on, so mysql cant be start
> How I can create mysql socket.
> How I can start mysql
&g
Hi All
While I am doing portupgrade -vr mysql on freebsd server
than mysql socket"/tmp/mysql.sock" is invisible on, so mysql cant be start
How I can create mysql socket.
How I can start mysql
thanks
d go with the MySQL default. I have tried specifying
"mysql.default_socket = /var/run/mysqld/mysql.sock" and
"mysql.default_socket = /tmp/mysql.sock", but that hasn't helped.
As for /etc/mysql/my.cnf, it says:
- - - - - - - - -
[mysqld]
pid-file= /var/run/my
On Tue, 28 Mar 2006, Áquila Chaves wrote:
> To: mysql@lists.mysql.com
> From: Áquila Chaves <[EMAIL PROTECTED]>
> Subject: error: 'Can't connect to local MySQL server through socket
> '/tmp/mysql.sock'
>
> - When I execute the command "m
press } */
[EMAIL PROTECTED] mysql]#
- The log message is:
060323 16:51:11 mysqld started
060323 16:51:11 InnoDB: Started; log sequence number 0 43655
060323 16:51:11 [Note] /usr/local/mysql/bin/mysqld: ready for
connections.
Version: '5.0.19-standard' socket: '/var/lib/mysql/mysql.
No errrs on the error log.. This is very weird...
|-Original Message-
|From: ? ??? [mailto:[EMAIL PROTECTED]
|Sent: Wednesday, March 15, 2006 6:12 AM
|To: Anton Krall; mysql@lists.mysql.com
|Subject: Re: mysql.sock gone
|
|Look at mysql's error log ($MYSQL_DAT
Look at mysql's error log ($MYSQL_DATA_DIR/$HOSTNAME.err). Do you see
anything strange there?
Anton Krall wrote:
No crons that would delete the tmp directory.. In fact, all the other files
stay there... Just mysql.sock goes away...
|-Original Message-
|From: Logan, David
No crons that would delete the tmp directory.. In fact, all the other files
stay there... Just mysql.sock goes away...
|-Original Message-
|From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
|Sent: Tuesday, March 14, 2006 3:15 PM
|To: Anton Krall; mysql@lists.mysql.com
:38 AM
To: mysql@lists.mysql.com
Subject: mysql.sock gone
Guys.
I just started having a problem, Im running
mysql-standard-4.1.12-pc-linux-gnu-i686 binaries under Fedora Core 3 and
Ive
been having problem where during some parts of the day, /tmp/mysql.oskc
goes
away, I can still see mysql running
says it cant connect thru mysql.sock
What could be the cause that would make mysql.sock dissapear?
Thx for any help you can provide
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
exist
>
> service configuration says:
> mysqld dead but subsys locked.
>
> i can't find any mysql.sock in /var/lib/mysql
>
> i reinstalled MySQL through yum but error is still the
> same.
>
> i was able to run MySQL before. i was even able to
> replicat
i cant start mysql.
error in the log says:
Fatal error: Can't open and lock privilege tables:
Table 'mysql.host' doesn't exist
service configuration says:
mysqld dead but subsys locked.
i can't find any mysql.sock in /var/lib/mysql
i reinstalled MySQL through yum bu
i cant start mysql.
error in the log says:
Fatal error: Can't open and lock privilege tables:
Table 'mysql.host' doesn't exist
service configuration says:
mysqld dead but subsys locked.
i can't find any mysql.sock in /var/lib/mysql
i reinstalled MySQL through yum bu
Hello all
I've installed MySQL Server 5.0.16 and MySQL Client 5.0.16 (from the RPMs on
the MySQL site) on a server running Fedora Core 4. Every time I try to start
the service, I get the Unable to connect to the MySQL server through the
/tmp/mysql.sock error. I've tried several thing
rror I get is "Can't connect to local
> MySQL server through socket
> '/var/lib/mysql/mysql.sock' (13)".
> And I'm sure that MYSQL server is running and able tp
> connect from command prompt.
>
>
>
> I have been searching on the net for the same fro
d Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Sandhya Reddy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 27 September 2005 4:03 PM
To: mysql@lists.mysql.com
Subject: problem with mysql.sock
through socket
'/var/lib/mysql/mysql.sock' (13)".
And I'm sure that MYSQL server is running and able tp
connect from command prompt.
I have been searchi
Ed Collins wrote:
Description:
I get the following message "error: 'Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (61)'"
This is the error the client gives when it cannot connect to the server,
usually because the server i
>Description:
I get the following message "error: 'Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (61)'" Everything has run
fine for along time. This is running on OS X server 10.3 and ever
since the ran the last software upda
> > hmm! mysql.sock was created at var/lib/mysql.
> > owner=mysql, permissions=777
> > So again, is there paths/permissions problems?
> >
> >
> Since this is where your my.cnf says to put it, it would be a problem if
> it was not there.
> If you are going
oup to mysql as per my redhat setup.
More problems tho:
==
When invoking mysql, I get the following error message:
"""
Can't connect to local MySQL server through socket at
'var/lib/run/mysql/mysql.sock'
"""
hmm! mysql.sock was creat
s per my redhat setup.
More problems tho:
==
When invoking mysql, I get the following error message:
"""
Can't connect to local MySQL server through socket at
'var/lib/run/mysql/mysql.sock'
"""
hmm! mysql.sock was created
Paul Mitchell wrote:
On Tue, 14 Jun 2005, Danny Stolle wrote:
if i start my mysqld it creates a mysql.sock because of an option in
my.cnf: socket="/tmp/mysql.sock"
when i `mysqladmin -u root shutdown` the database, the mysql.sock is
removed.
does your system errors when start
You need to run the script that creates MySql tables (user, hosts, ...)
mysql_install_db in scripts dir.
Santino
At 15:20 -0400 16-06-2005, Paul Mitchell wrote:
On Tue, 14 Jun 2005, Danny Stolle wrote:
if i start my mysqld it creates a mysql.sock because of an option
in my.cnf: socket="
On Thu, 16 Jun 2005, Spenser wrote:
Try it with an absolute file path instead of a relative one. For
instance,
/usr/local/mysql/bin/mysqld_safe --user=mysql --datadir
= /usr/local/mysql/tmp
same old...
/usr/local/mysql/bin/mysqld_safe --user=mysql
--datadir=/usr/local/mysql/tmp &
cat ../
Try it with an absolute file path instead of a relative one. For
instance,
/usr/local/mysql/bin/mysqld_safe --user=mysql --datadir
= /usr/local/mysql/tmp
On Thu, 2005-06-16 at 15:20 -0400, Paul Mitchell wrote:
>
> ./mysqld_safe --user=mysql --datadir=/usr/local/mysql/tmp
--
MySQL General Ma
On Tue, 14 Jun 2005, Danny Stolle wrote:
if i start my mysqld it creates a mysql.sock because of an option in my.cnf:
socket="/tmp/mysql.sock"
when i `mysqladmin -u root shutdown` the database, the mysql.sock is removed.
does your system errors when starting mysqld?
Hello Danny,
Paul Mitchell wrote:
Hello All,
I'm trying to get mediawiki working on a solaris 9 domain (this is on
a Sun 15k, FWIW). I had mysql installed and in a fit of stupidity,
managed to remove /tmp/mysql.sock. After scouring the Usenet via
google, and searching through the archiv
Hello All,
I'm trying to get mediawiki working on a solaris 9 domain (this is on a
Sun 15k, FWIW). I had mysql installed and in a fit of stupidity, managed
to remove /tmp/mysql.sock. After scouring the Usenet via google, and
searching through the archives at lists.mysql.com, I'm
Hassan Schroeder wrote:
Mark Sargent wrote:
... but, my real query, now, is, why the configs/my.cnf were different,
Because there isn't any /etc/my.cnf created on your system by
default; you are responsible for creating one if needed, using
the examples in the ./support-files subdirectory.
Obviou
Mark Sargent wrote:
... but, my real query, now, is, why the configs/my.cnf were
different,
Because there isn't any /etc/my.cnf created on your system by
default; you are responsible for creating one if needed, using
the examples in the ./support-files subdirectory.
Obviously the /etc/my.cnf on y
Simon Garner wrote:
On 6/05/2005 4:18 p.m., Mark Sargent wrote:
Ok, I just took a punt, and changed the setting in my.cnf to reflect
the config settings, to /tmp/mysql.sock, and all is well. What I
don't un, is, why the default settings were like this, I certainly
made no changes to eithe
On 6/05/2005 4:18 p.m., Mark Sargent wrote:
Ok, I just took a punt, and changed the setting in my.cnf to reflect the
config settings, to /tmp/mysql.sock, and all is well. What I don't un,
is, why the default settings were like this, I certainly made no changes
to either the configs o
Mark Sargent wrote:
Mark Sargent wrote:
Simon Garner wrote:
Mark Sargent wrote:
Hi All,
mysql is running, but, there seems to be no /tmp/mysql.sock file.
How is this file generated..? I can't connect, keep getting errors.
What about via a port..? What is the argument for that..? Cheers.
Mark Sargent wrote:
Simon Garner wrote:
Mark Sargent wrote:
Hi All,
mysql is running, but, there seems to be no /tmp/mysql.sock file.
How is this file generated..? I can't connect, keep getting errors.
What about via a port..? What is the argument for that..? Cheers.
Mark Sargent.
It'
Simon Garner wrote:
Mark Sargent wrote:
Hi All,
mysql is running, but, there seems to be no /tmp/mysql.sock file. How
is this file generated..? I can't connect, keep getting errors. What
about via a port..? What is the argument for that..? Cheers.
Mark Sargent.
It's probably not i
Mark Sargent wrote:
Hi All,
mysql is running, but, there seems to be no /tmp/mysql.sock file. How is
this file generated..? I can't connect, keep getting errors. What about
via a port..? What is the argument for that..? Cheers.
Mark Sargent.
It's probably not in /tmp any more. Tr
Hi All,
mysql is running, but, there seems to be no /tmp/mysql.sock file. How is
this file generated..? I can't connect, keep getting errors. What about
via a port..? What is the argument for that..? Cheers.
Mark Sargent.
--
MySQL General Mailing List
For list archives: http://lists.mysq
> I then logged 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 serv
# ./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.
Okay, with the good help I was getting, and looking at the all clues MySQL
was giving me, like "Table 'mysql.host' doesn't exist" and "Can't find file:
'./mysql/host.frm'", I concluded that the 4.1.9 installation conflicts with
the default 4.0.18 installation. For instance, 4.0.18 expects files
On Wednesday, January 19, 2005 9:14 PM Michael Stassen wrote:
Details should be in the .err file in the data directory
Here's the contents of the file:
050119 17:30:02 mysqld started
050119 17:30:02 [Warning] Setting lower_case_table_names=2 because file
system
for /usr/local/m
Details should be in the .err file in the data directory
(/usr/local/mysql/data/whitestar.alpha.net.err, in your case).
Michael
Alex Majora wrote:
Additionally, this is what I get when I try to launch mysqld manually:
$ sudo ./bin/mysqld_safe &
[1] 2058
Starting mysqld daemon with databases from
no mysqld process running in
the ps -aux listing.
However, if I try to start mysqld up again, I get:
050119 14:48:43 Can't start server : Bind on unix socket: Address
already in use
050119 14:48:43 Do you already have another mysqld server running on
socket: /tmp/mysql.sock ?
Additionally, this is what I get when I try to launch mysqld manually:
$ sudo ./bin/mysqld_safe &
[1] 2058
Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file
/usr/local/mysql/data/whitestar.alpha.net.pid
050119 17:13:12 mysqld ended
Is there a way t
The postmaster is a Postgres daemon, and pg_shadow is the user table for
postgres.
Clint
From: Michael Stassen <[EMAIL PROTECTED]>
To: Alex Majora <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: mysql.sock file exists, but still cannot connect to server
Date: Wed, 19 Jan 2
running in the
ps -aux listing.
However, if I try to start mysqld up again, I get:
050119 14:48:43 Can't start server : Bind on unix socket: Address already
in use
050119 14:48:43 Do you already have another mysqld server running on
socket: /tmp/mysql.sock ?
050119 14:48:43 Aborting
e a message (syntax error) from mysql.
050119 12:37:34 Aborting
050119 12:37:34 /usr/libexec/mysqld: Shutdown Complete
Not sure why, but mysqld just shut down.
When I type "mysql" at the command line, I get:
ERROR 2002: Can't connect to local MySQL server through socket
&#x
ng
050119 12:37:34 /usr/libexec/mysqld: Shutdown Complete
When I type "mysql" at the command line, I get:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
...yet the file exists:
srwxrwxrwx 1 mysql wheel0 19 Jan 12:35 mysql.sock
An
Two possibilities:
1) mysqld could not create /tmp/mysql.sock because it is already there,
which would mean mysqld is already running. It appears you've ruled this out.
2) User mysql does not have permission to write to /tmp. In Mac OS X, /tmp
is a symlink to /private/tmp, so this r
t: Permission denied
041110 20:33:42 Do you already have another mysqld server running on socket:
/tmp/
mysql.sock ?
041110 20:33:42 Aborting
041110 20:33:42 /usr/local/mysql/bin/mysqld: Shutdown Complete
041110 20:33:42 mysqld ended
Though i can't find any mysqld running on my computer.
C
Hello.
Check if another copy of mysqld process is running
(may be it runs with lost mysql.sock file?).
Check also permissions for .err file. And be sure you are starting MySQL as
root, because it will suid to the user you have specified.
See:
http://dev.mysql.com/doc/mysql/en
,
OS : macos X 10.3
mysql version 4.0.21, for apple-darwin6.8 (powerpc)
it's seems that after my last crash,
the socket of mysql '/tmp/mysql.sock' has
been deleted
(and i have read afterwards that it should have
been protected with a sticky bit)
i thought that restarting mysql da
Hello,
OS : macos X 10.3
mysql version 4.0.21, for apple-darwin6.8 (powerpc)
it's seems that after my last crash,
the socket of mysql '/tmp/mysql.sock' has
been deleted
(and i have read afterwards that it should have
been protected with a sticky bit)
i thought that restarti
In my experience, RedHat in their 'wisdom' put mysql.sock in /tmp/ yet
ships their mysql-server.rpm with a my.cnf pointing at
/var/lib/mysql/mysql.sock
Make the necessary change to /etc/my.cnf to point to /tmp/mysql.sock, or
change /etc/rc.d/init.d/mysql to point to /var/lib/mysql/
iled
error: 'Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket:
'/var/lib/mysql/mysql.sock' exists!
ps -ef | grep mysql
root 725 1 0 Oct29 ?00:00:00 /bin/sh
/usr/bin/
[EMAIL PROTECTED] root]# ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
[mysqld]
port= 3306
socket = /var/lib/mysql/mysql.sock
Which is fine ... you neglected to say whether or not that fixed your
problem?
-id
--
MySQL General Mailing List
For list archives: http
ian,
[EMAIL PROTECTED] root]# ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
[EMAIL PROTECTED] root]#
this my script of my.cnf
[client]
port= 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port= 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
ib_logfile1
drwx--x--x 2 mysql mysql 4096 Feb 23 2004 mysql/
-rw-rw 1 mysql root 7509 Nov 2 07:39 server6.cma-cgm.com.err
drwxr-xr-x 2 mysql mysql 4096 Feb 23 2004 test/
Therein lies your problem: you can't connect to
/var/lib/mysql/mysql.sock if it doesn't exist :o)
ough
socket'/var/lib/mysql/mysql.sock'
Date: Mon, 01 Nov 2004 19:06:43 -0600
>
> Well, this definitely indicates that the server's not running. Of
> course, maybe that's what you were saying in your original posting. Try
> checking the permissions of /var/lib/mysql o
connect to local MySQL server through
socket'/var/lib/mysql/mysql.sock'
Date: Mon, 01 Nov 2004 18:51:09 -0600
>
> I've had this happen when the server was down. If you're using Linux
> check the processes:
>
> ps -e | grep mysql
>
> This has also happ
It can has many reason:
1.Your Socket file doesn't exist!
2.If it does exist,Please kill your mysql & instead of
running its daemon,run its file in bg mode. (with &
sign)
--- Cecep Rosuludin <[EMAIL PROTECTED]> wrote:
> Dear AlL,
>
> my former question is "how to run mysql service".
> but now
Dear AlL,
my former question is "how to run mysql service". but now i have run mysql service
[EMAIL PROTECTED] root]# service mysql start
Starting MySQL Server [ OK ]
but i still cannot connect to mysql
[EMAIL PROTECTED] root]# mysql
ERROR 2002: Can'
mysql.sock is created when mysqld starts and exists only while it runs.
B.
> -Oorspronkelijk bericht-
> Van: Levi Campbell [mailto:[EMAIL PROTECTED]
> Verzonden: zaterdag 24 juli 2004 20:53
> Aan: [EMAIL PROTECTED]; mysql
> Onderwerp: Re: mysql.sock
>
>
> it
PM
Subject: Re: mysql.sock
Levi Campbell said:
> Hi, I managed to install MySQL on Linux but now I can't find mysql.sock
> either on my machine or on the CD. how do I create or find mysql.sock?
Is MySQL running? check in /tmp or if it was an RPM install, check in
/var/lib/mysq
1 - 100 of 512 matches
Mail list logo
