egfault occur
> ?
Interesting that you should pick on the length - I think that might be
it. When I switched to using a UDP socket, sendto() did complain about
the length. (error 90, message too long). Hmm, that's probably a UDP
packet-size restriction, whereas no such restriction exist
ous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> From: p...@computer.org
> Subject: RE: UDF writing to unix socket - segfaults?
> Date: Wed, 8 Aug 2012 15:39:09 +0200
> To: mysql@lists.mysql.com
>
> Martin Gainty wrote:
>
> > assuming you worked out t
Martin Gainty wrote:
> assuming you worked out the access to network by your code permissions
When I open the unix socket, I give it 0777.
> that means memory heap or stack is being overrun...you would be well
> advised to download the connect() and sendto() code from the OS vendor
I&
n'aura pas n'importe
quel effet légalement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> From: p...@computer.org
> Subject: UDF writing to unix socket - segfaults?
&g
I am writing a UDF for sending messages to a local daemon. I've been
trying to make it use a UNIX socket, but it keeps segfaulting on
connect() or sendto(). I have double and tripled checked everything,
but I'm not finding anything.
After a day or two, I finally decided to switch
; 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 /etc/mysql/debian.cnf when changing the socket
> > location.
> > >
> 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 /etc/mysql/debian.cnf when changing the socket
> location.
> > socket = /var/run/mysq
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
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
Am 09.10.2011 11:00, schrieb javad bakhshi:
> Hi,
>
> I had the same problem recently restart the server so it can create your
> socket
> again and it should be all right
/tmp/ is a really bad location because tmpwatch is killing old files there
and a mysqld usually runs for
Hi,
I had the same problem recently restart the server so it can create your socket
again and it should be all right.
Best regards,
Javad
From: Andrew Moore
To: Peter Schrock
Cc: mysql@lists.mysql.com
Sent: Sunday, October 9, 2011 10:51 AM
Subject
I just loaded and built three different versions of mysql and all three
versions have given me the same results. When trying to change the password
to root, this is what I get:
./mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server
the my.cnf and
the socket as stated before. The my.cnf could be replaced by installing the
mysql-common package which contain the most common files (and which includes
my.cnf),
#aptitude install mysql-common (try aptitude search with mysql- prefix in
case that doesn't works, i'm not abso
ntrados durante o processamento de:
mysql-server-5.0
E: Sub-process /usr/bin/dpkg returned an error code (1)
r...@midgard:/etc/init.d#
Which makes me believe that my socket file is gone when I went removing
files, and no matter how I try to install it it wont come back. Same goes
for the my.cnf fil
Hi Charles,
the socket is created either in the default location or in the location
specified in the 'my.cnf' configuration file under the [mysqld] section,
you can have different 'my.cnf' files in the system in different default
locations that are read in a cascading styl
Hi Charles,
Try this:
mysql -u -p -h127.0.0.1 -P3306
to force tcp instead of socket
Let me know!
Cheers
Claudio
On Nov 4, 2009 4:34 AM, "Brown, Charles" wrote:
From: Brown, Charles
Sent: Tuesday, November 03, 2009 2:54 PM
To: Rams
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
Socket connections do not use tcp (meaning localhost)
Remote hosts use tcpip
Sent via BlackBerry from T-Mobile
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi All,
Any body can explain the difference between socket connection and tcp/ip
connection.
Thanks,
Krishna
/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
You can easily get around that behaviour by specifying 127.0.0.1, though :-)
On Tue, Aug 11, 2009 at 8:56 PM, Gavin Towey wrote:
> Andrew,
>
> Yes it's true, because when you specify localhost, you're using the local
> socket file. The port only has meaning for TCP co
Andrew,
Yes it's true, because when you specify localhost, you're using the local
socket file. The port only has meaning for TCP connections.
Regards,
Gavin Towey
-Original Message-
From: Andrew Braithwaite [mailto:andrew.braithwa...@lovefilm.com]
Sent: Tuesday, August 11,
..@lovefilm.com]
Sent: 11 August 2009 16:12
To: mysql@lists.mysql.com
Subject: Replication - connecting a slave to a master on the same host
via a port or socket
Hi,
I have 2 mysql instances running on a server on different ports with
different datadirs and different .sock files.
I can connect
use a
socket to connect to a master on localhost?
If not; does anyone know a way to connect to another mysql instance on
the same linux server using a port?
Thanks for your help,
Andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
--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
: socket error
the file mysql.sock does not exist what I have to do?
- Original Message -
From: "bruce" <[EMAIL PROTECTED]>
To:
Sent: Thursday, December 21, 2006 4:35 PM
Subject: RE: socket error
> you might also need to check that the my.cnf file is configured to
> ref
age -
From: "Rolando Edwards" <[EMAIL PROTECTED]>
To: "eng.waleed" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, December 21, 2006 4:08 PM
Subject: Re: socket error
Here is a question:
Were you attempting to login on the localhost machine ??
Can you login to the M
the file mysql.sock does not exist what I have to do?
- Original Message -
From: "bruce" <[EMAIL PROTECTED]>
To:
Sent: Thursday, December 21, 2006 4:35 PM
Subject: RE: socket error
you might also need to check that the my.cnf file is configured to
referenc
y.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_connections=3
#set-variable = log-error=/var/log/mysql_err.log
#set-variable = log=/var/log/mysql_query.log
##set-variable = log-bin=/var/log/mysql_bin.log
#set-variable = log-slow-queries=/var/log/mysql_slow.log
# De
On Thursday 21 December 2006 02:25, eng.waleed wrote:
> hi
> I have this error on mysql engine Could not connect: Can't connect to local
> MySQL server through socket '/var/lib/mysql/mysql.sock' (13) is there any
> suggestion my version is 3.23.58
> BR
I think i
inal Message -
From: eng.waleed <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Wednesday, December 20, 2006 5:25:04 PM GMT-0500 US/Eastern
Subject: socket error
hi
I have this error on mysql engine Could not connect: Can't connect to local
MySQL server through socket '
Waleed,
First, please try to upgrade your mysql.
Try to review in your my.cnf if your configuration socket appear two twice (
in two lines ).
Verify in your environment if your mysql is running using "ps -aux | grep -i
mysql".
$ service mysql stop
$ ps -aux | grep -i mysql
$
hi
I have this error on mysql engine Could not connect: Can't connect to local
MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
is there any suggestion my version is 3.23.58
BR
Russbucket wrote:
I just check my install of mysql (version mysql-4.1.13-3.8 on SUSE 10.0) and
the socket is in /var/lib/mysql and the mysqld log is in /var/lib/mysql.
This is the mysql version that came with my 10.0 DVD. Did you use YAST to
install? I don't know if these locations changed
this possible?
>
> At the moment, I have a /etc/my.cnf file with the following content:
>
> [mysqld]
> socket=/tmp/mysql.sock
>
> [client]
> socket=/tmp/mysql.sock
>
> I added these entries in an attempt to get PHP to use the actual
> location that MySQL is us
ntent:
[mysqld]
socket=/tmp/mysql.sock
[client]
socket=/tmp/mysql.sock
I added these entries in an attempt to get PHP to use the actual
location that MySQL is using, but this doesn't appear to have had any
effect (according to phpinfo()).
Secondly, MySQL appears to be trying to write lo
Thank you for your answer.
Here is what I did
cd
/seqweb/mysqlhome
mercure{mysql}140: more .my.cnf
# The following options will be passed to all MySQL clients
[client]
user= mysql
password=
port= 3306
socket = /tmp/mysql4.sock
# Here follows
/bin/mysqld_safe --defaults-file=/seqweb/mysqldata/my.cnf --port=3306 --socket=/tmp/mysql4.sock --pid-file=/seqweb/mysqldata/mysql4.pid --user=mysql --datadir=/seqweb/mysqldata
7023 pts/4S 0:13 /seqweb/mysql-4.1.7/libexec/mysqld
--defaults-file=/seqweb/mysqldata/my.cnf --basedir=/seqweb
--defaults-file=/seqweb/mysqldata/my.cnf --port=3306 --socket=/tmp/mysql4.sock
--pid-file=/seqweb/mysqldata/mysql4.pid --user=mysql --datadir=/seqweb/mysqldata
7023 pts/4S 0:13 /seqweb/mysql-4.1.7/libexec/mysqld
--defaults-file=/seqweb/mysqldata/my.cnf --basedir=/seqweb/mysql-4.1.7
--datadir
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.
"Jim Douglas" <[EMAIL PROTECTED]> wrote on 03/13/2006 12:24:56 PM:
> I can connect to mysql with
>
> mysql -u dbname -p
>
> When I start MySQL Administrator v 1.1.6 it says
>
> Could not connect to host 'localhost'.
> MySQL Error Nr. 2002
&g
I can connect to mysql with
mysql -u dbname -p
When I start MySQL Administrator v 1.1.6 it says
Could not connect to host 'localhost'.
MySQL Error Nr. 2002
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
...then I Click on Details a
[Sorry] I didn't realize that hitting Reply (using Gmail) sent a
private message. Usually on lists the message ends up on the list.
Will need to observe the header in the future.
tx;
-nat
On 1/27/06, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> Hello.
>
> Please, next time always CC your messages t
Hello.
Please, next time always CC your messages to the list as well. I'm
not a lampp expert and can only point you to:
http://dev.mysql.com/doc/refman/5.0/en/program-options.html
>This advice proved very helpful. This is where its at now:
>I noticed that the .err file belonged to user 'nobod
Hello.
Make several checks that should help.
Be sure that no instances of MySQL are running on your computer and
check if 5.0.18 starts successfully. Specify another location of the
socket file. Temporary disable SELinux. See:
http://dev.mysql.com/doc/refman/5.0/en/starting-server.html
cture, with
the owner now being mysql with full rights.
I do not know at which point this happened but I can't bring up the
thing any longer. This is what I get:
060124 14:15:44 mysqld started
060124 14:15:44 [ERROR] Can't start server : Bind on unix socket:
Permission denied
060124 14:15:44
startup the database through the terminal
> and I've even tried to startup MyPHPAdmin, however I'm getting this
> message:
>
> #2002 - The server is not responding (or the local MySQL server's
> socket is not correctly configured)
>
> Does anybody know w
he terminal
and I've even tried to startup MyPHPAdmin, however I'm getting this
message:
How did you try to start the server? Did it start? Is there anything in
mysql's error log?
#2002 - The server is not responding (or the local MySQL server's
socket is not correctly
learn something and play with it.
I have tried to connect and startup the database through the terminal
and I've even tried to startup MyPHPAdmin, however I'm getting this
message:
#2002 - The server is not responding (or the local MySQL server's
socket is not correctly configured)
At 22:38 -0500 11/8/05, [EMAIL PROTECTED] wrote:
There can also be a [mysql] section that will apply to all applications
that read the my.cnf file. It is sort of the "default" section.
Eh?
The [mysql] section applies to the mysql client program and not
to anything else.
[mysql]
s
There can also be a [mysql] section that will apply to all applications
that read the my.cnf file. It is sort of the "default" section.
[mysql]
socket=/tmp/mysql.sock
[mysqld]
datadir=/var/lib/mysql
socket=/tmp/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
socket=/tmp/
"David Inglis" <[EMAIL PROTECTED]> wrote on 11/08/2005
09:33:27 PM:
> I am having the following problem
>
> with the setting for socket in the my.cnf configuration file set to
> socket=/tmp/mysql.sock I am able to connect through a browser but cannot
> connect
I am having the following problem
with the setting for socket in the my.cnf configuration file set to
socket=/tmp/mysql.sock I am able to connect through a browser but cannot
connect using the mysql client when I change it to
socket=/var/lib/mysql/mysql.sock I can access through mysql client
://localhost/phpMyAdmin
Welcome to phpMyAdmin 2.6.3-pl1
Error
MySQL said: Documentation
#2002 - The server is not responding (or the local MySQL server's socket is
not correctly configured)
I see the socket file in /var/lib/mysql
srwxrwxrwx 1 mysql mysql0 2005-11-02
://localhost/phpMyAdmin
Welcome to phpMyAdmin 2.6.3-pl1
Error
MySQL said: Documentation
#2002 - The server is not responding (or the local MySQL server's socket is
not correctly configured)
I see the socket file in /var/lib/mysql
srwxrwxrwx 1 mysql mysql 0 2005-11-02
AM
To: Barbara Deaton
Cc: Gleb Paharenko; mysql@lists.mysql.com
Subject: RE: SOCKET directory
The "sock" file is not a permanent file. It is a socket descriptor that should
only exist if the MySQL server is running and if the server is configured to
supports socket-type connections. Most
The "sock" file is not a permanent file. It is a socket descriptor that
should only exist if the MySQL server is running and if the server is
configured to supports socket-type connections. Most of the default
installations DO NOT start the server as part of the installation process.
Barbara Deaton wrote:
Thank you for the link.
I understand that I need a mysql.sock file, what I don't understand is that I
used to get one when I installed MySQL. When I look through all my 4.0.x mysql
directories I see a socket directory that contains a mysql.sock file. With my
Thank you for the link.
I understand that I need a mysql.sock file, what I don't understand is that I
used to get one when I installed MySQL. When I look through all my 4.0.x mysql
directories I see a socket directory that contains a mysql.sock file. With my
4.1 install I do not see
UNIX_PORT environment variable to point to =
> the location of my socket file. Looking through my 4.1.9 install I no =
> longer see a mysql/socket directory. =20
>
> However, when I try to connect I get the error:
>
> ERROR: Error trying to establish connection: Can'
With MySQL 4.0 when I wanted to run my application on any of the unix boxes I
had to set the MYSQL_UNIX_PORT environment variable to point to the location of
my socket file. Looking through my 4.1.9 install I no longer see a
mysql/socket directory.
However, when I try to connect I get the
Add the following entry in the my.cnf to create the socket file in the
desired location.
socket=/var/lib/mysql/mysql.sock (Any desired path can be given here)
sujay
-Original Message-
From: Octavian Rasnita [mailto:[EMAIL PROTECTED]
Sent: Monday, October 10, 2005 3:50 PM
To: Sujay
ujay
>
I have discovered that mysql creates the socket in /tmp/mysql.sock instead
of /var/lib/mysql/mysql.sock.
I have created a link from /tmp/mysql.sock to /var/lib/mysql/mysql.sock and
now MySQL works fine.
However, I think I should change somewhere in the file my.ini the location
of the so
ECTED]
Sent: Monday, October 10, 2005 2:44 PM
To: mysql@lists.mysql.com
Subject: creating socket
Hi,
I have installed mysql and loaded mysqld, but I cannot connect to it with
mysql because it gives an error telling that "it cannot connect using socket
/var/lib/mysql/mysql.sock".
I have c
Hey,
you need to tun mysql SERVERom
what is the output of the command
ps aux |grep mysql
Peter
Octavian Rasnita wrote:
Hi,
I have installed mysql and loaded mysqld, but I cannot connect to it with
mysql because it gives an error telling that "it cannot connect using socket
/var/lib/
Hi,
I have installed mysql and loaded mysqld, but I cannot connect to it with
mysql because it gives an error telling that "it cannot connect using socket
/var/lib/mysql/mysql.sock".
I have checked that dir, but I don't have that socket file there.
Please tell me how to create i
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
I have already test and it doesn't work, my stunnel doesn't work properly. I
have asked my question on stunnel-users mailing list but i d'ont have answer
for the moment...
Thanks for your help!
Original Message
Subject: Re: Re-2: Socket Problem (20-juil.-2
port=3306 --protocol=TCP -u user --password=xxx it works!
>>
>> The real problem is when using stunnel, i have to do as if i will connect to
>> a local server... On windows it works but not on linux... :(
>>
>> ---- Original Message
>> Subjec
--- Original Message ----
> Subject: Re: Socket Problem (20-juil.-2005 13:10)
> From:[EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
>
>
>>Hello.
>>
>>First check if you are able to establish TCP connection to port
>>which is linked by stunnel. T
When i try
mysql -h server --port=3306 --protocol=TCP -u user --password=xxx it works!
The real problem is when using stunnel, i have to do as if i will connect to a
local server... On windows it works but not on linux... :(
Original Message
Subject: Re: Socket Problem (20
the same as on my windows box
> but i've got this message :
>
> Can't connect to local MySQL server through socket
> '/var/run/mysqld/mysqld.sock'
>
> It is normal since i don't have a mysql server on my linux box so this socket
> doesn't exists..
> mysql is trying to connect to localhost by default.
Yes, i know that, but with stunnel, when i connect to localhost, it is suppose
to connect to the remote server.
LinuxBox -> 3306 -> stunnel -> 3307 <> 3307 <- stunnel <- 3306 <- Server
On my linux box, i try to connect to local port 330
mmand :
mysql -u user --password=xxx
and with stunnel, i'm connected to the remote server and communications are
encrypted.
but on my linux box, my stunnel config file is the same as on my windows box
but i've got this message :
Can't connect to local MySQL server through soc
sword=xxx
and with stunnel, i'm connected to the remote server and communications are
encrypted.
but on my linux box, my stunnel config file is the same as on my windows box
but i've got this message :
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.
Hello.
> I see default unix socket file is /tmp/mysql.sock
> which could be removed by someone accidently.
> Is it normal to keep it that way or keep in a
> protected directory ?
See:
http://dev.mysql.com/doc/mysql/en/problems-with-mysql-sock.html
"V. Agarwal&q
Which cnf file (small,medium,large,huge) has params
that are closer to mysql defaults for starting up
server?
I see default unix socket file is /tmp/mysql.sock
which could be removed by someone accidently.
Is it normal to keep it that way or keep in a
protected directory ?
Thanks
Hi
according to Dr Google I'm not the first one to encounter this error
below.
SpamAssassin: invoked with 'spamd -D -q -u filter'
failed to load user (filter) scores from SQL database: SQL Error:
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.s
> 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.
On 13 Jan 2005 at 10:47, Sid Lane wrote:
> hope this isn't considered too off-topic but...
>
> I have been working on standardizing the directory trees on our MySQL
> servers (a la OFA for those who speak Oracle) but when I repoint the
> socket parameter in my.cnf all my
hope this isn't considered too off-topic but...
I have been working on standardizing the directory trees on our MySQL
servers (a la OFA for those who speak Oracle) but when I repoint the
socket parameter in my.cnf all my perl scripts barf w/:
"Can't connect to local MySQL server
r and find the
mysqld
is running and functional, because I can connect to it via unix socket!!!
Things not changed event restart the mysql service, so I have to reboot the
server :(
Anybody here has the same experience, and how this happened?
Oscar Yen.
Hello Mukund,
Remove the /etc/my.cnf file and start the mysqld daemon again. It will
work
Thanks,
Mathan
- Original Message -
From: "Mukund N Rathi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 26, 2004 11:31 AM
Subject: Socket Error While
Hi All,
I am facing some problems with installation of MySQL on Mac.
I have installed MySQL on mac 10.3.5. but now whenever I try to run and
start MySQL,
it gives me following error
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
Hello,
The mysql sock file is used for Unix Domain Sockets communication.
In essence, it is used for interconnection between processes running
on the same system. They function just like ordinary-over-the-net
sockets. They are just faster for interprocess communication.
I am not sure I understan
Is the MySQL server running and you can not connect? Or are you not able
to start the MySQL server?
Morris, Andrew wrote:
../var/lib/mysql/mysql.sock.
I've been round the houses with this following the thread but I can't
get past this error despite all the chmod and chown modifications,
insta
../var/lib/mysql/mysql.sock.
I've been round the houses with this following the thread but I can't
get past this error despite all the chmod and chown modifications,
installed MySQL admin and it still won't start.
Am I best to chuck it in the bin or uninstall the lot and start again?
This is
1 - 100 of 403 matches
Mail list logo