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 aim.prab...@gmail.com
did you check permission of
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
On Wed, Apr 11, 2012 at 2:51 AM, Ganesh Kumar bugcy...@gmail.com 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
#
did you check permission of file /var/run/mysqld/mysqld.sock
On Wed, Apr 11, 2012 at 9:48 AM, Larry Martell larry.mart...@gmail.comwrote:
On Wed, Apr 11, 2012 at 2:51 AM, Ganesh Kumar bugcy...@gmail.com wrote:
Hi Guys,
I am using debian squeeze it's working good, I am trying to install
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
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 file to connect to the server
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. The mysql server itself is still functioning .. you can specify
--host=localhost instead
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 '/tmp/mysql.sock' (2)
Hi Charles,
Try
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 Here ...
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 please help me
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
Here
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:
/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 this. is it correct.
thanks
-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'I have tried:1
--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 socket
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
#
# FGIN shell
16
04:18:52 UTC 2008 [EMAIL PROTECTED] mailto:
[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]
port = 3306
socket = /tmp/mysql.sock
[MYSQLD]
port
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 should be
ECONNREFUSED (Connection
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
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 fgrep
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 = 500
=/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 --basedir=/usr/local
--datadir=/var/db/mysql --user=mysql
--pid-file=/var/db/mysql/hostname.pid
--port=3306 --socket=/tmp/mysql.sock
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
.
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 mysql
and
restart it causing db corruptions
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 thought
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
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
,
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
/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
We could try that, but why would it behave differently to the current sh
script?
Thanks
Ian
On Thu, Feb 28, 2008 at 7:43 PM
/mysql/hostname.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
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
/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
We could try that, but why would it behave differently to the current sh
script?
Thanks
Ian
On Thu, Feb 28, 2008
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 question
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
Здравствуйте, 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
thanks
MySQL server will create
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
How I can create mysql socket.
How I can start mysql
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/mysqld/mysqld.pid
socket = /var/run/mysqld/mysql.sock
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.sock' port:
3306 MySQL
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 mysqld_safe:
[EMAIL PROTECTED] mysql]# bin/mysqld_safe
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_DATA_DIR
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 (SST
to it, it 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]
: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
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
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 but error is still the
same
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 but error is still the
same
:
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
replicate.
i dont know what's wrong.
i tried many things in different forums but all
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 things from
'/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 from
: problem with mysql.sock
Hello,
I have recently installed FC3 and now I have
PHP(4.4.9) and MYSQL(3.23) which got installed along
with FC3.
I'm able to connect to MYSQL from command prompt.
But the problem fires when I do the same from a PHP
script. The error 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 from the
last 3 days but ended with nothing.
I have changed php.ini to include
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 update mysql has not be available.
I have
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 isn't running.
Everything has run
.
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 at var/lib/mysql.
owner=mysql, permissions=777
So again
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 created at var/lib/mysql.
owner=mysql, permissions=777
So
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 to override the default location of the socket
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,
Thanks
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
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
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=/tmp
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 starting mysqld
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 still
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 archives
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
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.
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.mysql.com
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. Try /var/lib
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 in /tmp any
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's probably
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
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
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 either
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
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 in
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
Any ideas about what to do? I've reinstalled the mySQL package
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
'/tmp/mysql.sock' (2)
Are you sure mysqld is running? You got a shutdown message
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
050119 14:48:43
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 2005 17:42:34
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
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 ?
050119 14:48:43
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
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
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 restarting mysql daemon
: 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 daemon would fix
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
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.
Can someone helps ?
Thanks
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 really
: '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/mysqld_safe --d
mysql 767 725 0 Oct29
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/mysql.sock
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't
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 i have
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 happened to me when I make changes to my data directory
for MySQL and the new
'/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 or wherever it said that the
socket should
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)
RedHat
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
[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
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?
Original Message
Subject: Re: mysql.sock
From:Jonathan Villa [EMAIL PROTECTED]
Date:Sat, July 24, 2004 1:42 pm
To: Levi Campbell [EMAIL PROTECTED]
--
Levi
1 - 100 of 482 matches
Mail list logo