Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

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/

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

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

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

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

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

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

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Hi thanks for your reply. i found the problem, the problem was due to maintenance activity IT team rebooted the machine but they didn't start the mysql server after reboot. i executed mysqld with root credit. i got the below output but still the cursor not return to prompt bash-2.03# /usr/local

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

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/

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

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 > # >

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

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

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

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

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

Hi Vidal, all ! Vidal Garza wrote: Hi... I need test mysql connections but i have a problem... freebsd# uname -a FreeBSD freebsd.aduanet.net 6.3-RELEASE FreeBSD 6.3-RELEASE #0: Wed Jan 16 04:18:52 UTC 2008 [EMAIL PROTECTED] :/usr/obj/usr/src/sys/GENERIC i386 freebs

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

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-RELEASE FreeBSD 6.3-RELEASE #0: Wed

Re: ERROR 2002 (HY000): Can't connect to local MySQL server

AIL PROTECTED] > Sent: Tuesday, June 19, 2007 12:48 PM > To: John Mancuso > Subject: RE: ERROR 2002 (HY000): Can't connect to local MySQL server > > mysqld_safe > Starting mysqld daemon with databases from /var/lib/mysql STOPPING > server from pid file /var/run/mysqld/m

RE: ERROR 2002 (HY000): Can't connect to local MySQL server

:48 PM To: John Mancuso Subject: RE: ERROR 2002 (HY000): Can't connect to local MySQL server mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 070619 17:40:10 mysqld ended --- John Mancuso <[EMAIL PROTECTED]>

RE: ERROR 2002 (HY000): Can't connect to local MySQL server

jn [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 12:25 PM To: John Mancuso Subject: RE: ERROR 2002 (HY000): Can't connect to local MySQL server Hiya, I could not find .err file anywhere. and my mysql.sock file is showing 0 bytes in it. - ash# --- John Mancuso <[EMAIL PROTECTED

RE: ERROR 2002 (HY000): Can't connect to local MySQL server

Have you looked in your mysql error log in your data directory? Check //.err FYI- the locate command needs to be updated. It can show old info if you don't run updatedb frequently John Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475

Re: error 2002:

John Trammell wrote: Is the mysqld daemon running? (It should be.) What does the command ps aux | grep mysqld say? -Original Message- From: Mark Sargent [mailto:[EMAIL PROTECTED] Sent: Friday, March 11, 2005 8:52 AM To: mysql@lists.mysql.com Subject: error 2002: Hi All, I get the

RE: error 2002:

Is the mysqld daemon running? (It should be.) What does the command ps aux | grep mysqld say? > -Original Message- > From: Mark Sargent [mailto:[EMAIL PROTECTED] > Sent: Friday, March 11, 2005 8:52 AM > To: mysql@lists.mysql.com > Subject: error 2002: > > Hi All, > > I get the f

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Hello. See: http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html Billy Pilgrim <[EMAIL PROTECTED]> wrote: > Hello, I installed MySQL 4.1.10 on Debian Ubuntu based following these > directions: > http://dev.mysql.com/doc/mysql/en/installing-binary.html > I then logged

RE: Error 2002

let it put the .sock and .pid files in the default locations and all is working fine now. Michael -Original Message- From: Nestor Florez [mailto:[EMAIL PROTECTED] Sent: Thursday, 10 February, 2005 12:14 To: Dean,Michael L USAATC Subject: Re: Error 2002 I was getting that on my Mac OSX an

Re: ERROR 2002: Can't connect to local MySQL server through socket var/lib/mysql/mysql.sock' (2)

On Monday 19 July 2004 12:12, charitha wrote: > Hi, You just check the entry in your /etc/my.cnf file where your .sock > file is configured my.conf says for server and client configuration: socket = /var/lib/mysql/mysql.sock So the path is correct > if it is not this path then change it and res

Re: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Take a look at this http://dev.mysql.com/doc/mysql/en/Can_not_connect_to_server.html Best Regards, Cemal Dalar a.k.a Jimmy System Administrator & Web Developer http://www.dalar.net - Original Message - From: "Laurent" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 19, 20

RE: ERROR 2002: Can't connect to local MySQL server through socket

You have to run the 'mysqld_safe &' command before you run 'mysql'. That creates the socket for you. J.R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 2002

jeepcreep <[EMAIL PROTECTED]> wrote: > > I did and it is not running. Look into error log file. You can find causes why MySQL server doesn't start. > > Victoria Reznichenko <[EMAIL PROTECTED]> wrote:jeepcreep wrote: >> >> That is what I did. > > Check with > > ps ax | grep mysqld > > if MyS

Re: Error 2002 egroka

I did and it is not running. Victoria Reznichenko <[EMAIL PROTECTED]> wrote:jeepcreep wrote: > > That is what I did. Check with ps ax | grep mysqld if MySQL server is really running. > That's when I get the error 2002 message. Maybe my problem is not with the > mysql.sock file but something

Re: Error 2002 egroka

jeepcreep <[EMAIL PROTECTED]> wrote: > > That is what I did. Check with ps ax | grep mysqld if MySQL server is really running. > That's when I get the error 2002 message. Maybe my problem is not with the > mysql.sock file but something else. > > Daniel Kasak <[EMAIL PROTECTED]> wrot

Re: Error 2002

That is what I did. That's when I get the error 2002 message. Maybe my problem is not with the mysql.sock file but something else. Daniel Kasak <[EMAIL PROTECTED]> wrote:jeepcreep wrote: >Just loaded mySQL v4 to LINUX Mandrake v9.2 via RPM. The error 2002 talks >of a mysql.sock file. I can't fi

Re: Error 2002

jeepcreep wrote: Just loaded mySQL v4 to LINUX Mandrake v9.2 via RPM. The error 2002 talks of a mysql.sock file. I can't find this file anywhere on my box. Can't figure out why I can't find it as I'm preety sure the install was completed successfully. If I want to rebuild it, though, what's in it?

Re: ERROR 2002: Can't connect to local MySQL server through socket

Mark Depenbrock <[EMAIL PROTECTED]> wrote: > I have installed a Mac OS X 'PKG' binary package on my OS version > 10.2.6 Mac. > > I have been instructed that after the installation I can start up MySQL > by running the following command lines: > > [Computer:/usr/local/mysql] mark% sudo ./bin/mys

RE: ERROR 2002: Can't connect to local MySQL server through socke t '/var/lib/mysql/mysql.sock' (2)

Sent: Monday, June 09, 2003 2:31 AM To: 'Pratchaya Chatuphian'; '[EMAIL PROTECTED]' Subject: RE: ERROR 2002: Can't connect to local MySQL server through socke t '/var/lib/mysql/mysql.sock' (2) Is your server daemon running? -Original Message- From: Pratc

RE: ERROR 2002: Can't connect to local MySQL server through socke t '/var/lib/mysql/mysql.sock' (2)

Is your server daemon running? -Original Message- From: Pratchaya Chatuphian [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 2:25 AM To: [EMAIL PROTECTED] Subject: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) ERROR 2002: Can't conn

RE: ERROR 2002

AIL PROTECTED]>, [EMAIL PROTECTED] > Subject: RE: ERROR 2002 > > Locate the mysql.sock file and create a symbolic link to the > /var/lib/mysql/mysql.sock file. :) > > - Brian J. > > -Original Message- > From: Tomasz Krasiel [mailto:[EMAIL PROTECTED]] > Sent: Tu

RE: ERROR 2002

Locate the mysql.sock file and create a symbolic link to the /var/lib/mysql/mysql.sock file. :) - Brian J. -Original Message- From: Tomasz Krasiel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 6:56 AM To: [EMAIL PROTECTED] Subject: ERROR 2002 I installed MySQL 3.23.54 on

Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

Vince LaMonica wrote: On Fri, 15 Nov 2002, Edwin Raj wrote: } [root@edwinraj bin]# /usr/local/mysql/bin/mysqladmin -u root password } 'simple' } /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed } error: 'Can't connect to local MySQL server through socket } '/tmp/mysql

Re: ERROR 2002: Can't connect to local MySQL server through socket'/tmp/mysql.sock' (111)

On Fri, 15 Nov 2002, Edwin Raj wrote: } [root@edwinraj bin]# /usr/local/mysql/bin/mysqladmin -u root password } 'simple' } /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed } error: 'Can't connect to local MySQL server through socket } '/tmp/mysql.sock' (111)' } Check that

Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

If this could help to analyse the problem, when I try to create a password this is the message I get [root@edwinraj bin]# /usr/local/mysql/bin/mysqladmin -u root password 'simple' /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server

Re: ERROR 2002: Can't connect to local MySQL server through socket'/var/lib/mysql/mysql.sock' (111)

mysql.sock file doesn't exist in the /var/lib/mysql directory. Stop and restart mysql server. Regards, Bhavin. - Original Message - From: "samratsam" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, August 10, 2002 4:28 AM Subject: ERROR 2002: Can't connect to local MySQL serve

Re: ERROR 2002

Chai, Tuesday, July 30, 2002, 8:25:13 AM, you wrote: CW> Very sorry for my childish question, I'm just starting to learn about MySQL CW> Following is my procedure in fixing the problem of installation on Intel PC, CW> and Linux RH7.3. CW> 1. RPM installation CW> 2. When execute mysql, there is a

Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

;[EMAIL PROTECTED]> > Cc: "Mike Yrabedra" <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Tuesday, March 26, 2002 2:56 PM > Subject: Re: ERROR 2002: Can't connect to local > MySQL server through socket > '/tmp/mysql.sock' (2) > > >

Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

ROTECTED]> Cc: "Mike Yrabedra" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, March 26, 2002 2:56 PM Subject: Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) > > > On Tue, 26 Mar 2002, colin o wrote:

Re: Error 2002:

Hey Andy, mysql is the client connection program. mysqld is the actual mysql database daemon that runs. You might want to take a look at the error logs to see what it's actually complaining about. That, or go peek at the Mysql documentation first and read up on the actual install so you can ge

Re: ERROR 2002: Can't connect to local MySQL server through socket'/tmp/mysql.sock' (2)

On Tue, 26 Mar 2002, colin o wrote: > Same thing happens to me, > > i just use bin/safe_mysqld --user=root & > to start to server so that i can use mysql. > I don't know exactly why it happens though. > Possibly permissions?? It is better to run mysqld as a non-root user, such as mysql. > ---

Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Same thing happens to me, i just use bin/safe_mysqld --user=root & to start to server so that i can use mysql. I don't know exactly why it happens though. Possibly permissions?? Colin --- Mike Yrabedra <[EMAIL PROTECTED]> wrote: > > What would cause this error to occur all of a > sudden? >

Re: Error 2002 can't connect to MySQL server through socket /var/lib...

Hello, I work with Suse 7.1 and mysql 3.23.30 gamma. I have killed the mysql settings and so I remove the mysql-RPMs and install mysql 3.23.41 with yast1. Perhaps a mistake, I didn´t reboot the system after removing the RPMs. Then I have same Problems, like: I> Funny I still have the same exact

Re: Error 2002 can't connect to MySQL server through socket /var/lib...

Intrex, Tuesday, March 05, 2002, 6:09:01 PM, you wrote: I> Funny I still have the same exact problem Egor does. I start mysql with I> safe_mysqld, same only server just ends. I do safe_mysqld & nothing, I use I> mysqld -r root -p I> Nothing I do, that is listed helps. I still have no mysql.s

Re: Error 2002 can't connect to MySQL server through socket /var/lib...

Funny I still have the same exact problem Egor does. I start mysql with safe_mysqld, same only server just ends. I do safe_mysqld & nothing, I use mysqld -r root -p Nothing I do, that is listed helps. I still have no mysql.sock, and the server never starts. Mark - Original Message

RE: ERROR 2002

Seems like MySQL is not running. Check to make sure it's running by executing: ps -eaf | grep mysql (on a Unix platform). If no processes are running then start MySQL. Hope this helps you, -Teresa -Original Message- From: Pablo Javier Gonzalez Mateos [mailto:[EMAIL PROTECTED]] Sent

Re: ERROR 2002:

I had the same error - but the socket didn't appear to exist.. (I'm using RH7 with the defualt setup) <<< "Moax Tech List" <[EMAIL PROTECTED]> 5/26 6:08a >>> You most likely don't have your permissions set right on your socket, make sure it is readable / writeable by the php user (nobody?) an

Re: ERROR 2002:

You most likely don't have your permissions set right on your socket, make sure it is readable / writeable by the php user (nobody?) and apache i had that same prob. -derick - Original Message - From: "Jeff Pace" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 25, 2001 5:39

RE: ERROR 2002:

Scratch the Red Hat RPM and get the latest build from www.mysql.com This is a FAQ here. Cheers Mike -Original Message- From: Jeff Pace [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 4:40 PM To: [EMAIL PROTECTED] Subject: ERROR 2002: Can't connect to local MySQL server through s

Re: ERROR 2002

This is an FAQ and usually means that the mysql server hasn't been started yet. Please search the archives at http://lists.mysql.com for further details. - Original Message - From: "albany" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 15, 2001 9:34 Subject: ERROR 2002

Re: Error 2002

Check to see if the socket file exists in the right place with the right permissions. - Original Message - From: "Gordon Stewart" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, May 06, 2001 0:08 Subject: Error 2002 > Hi > > I have installed Mysql from the latest tar file and

Re: ERROR 2002 question

Thank you very much. This did the trick! The /var/lib/mysql directory needed to be readable and executable. I don't know why the Kernel upgrade changed this but it's good now. -Craig On Thu, 22 Mar 2001, Gerald Clark wrote: > The full path to the mysql.sock file must be readable, and searcha

Re: ERROR 2002 question

The full path to the mysql.sock file must be readable, and searchable for the client to find and open the socket. Craig Cummings wrote: > > Hi there, > > I recently upgraded my Linux kernel to 2.4.2 and my perl DBI/DBD > and now MySQL is behaving strangely. If I'm logged into my system

Re: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

Hi Gerald, > In order for andreaso to open mysql.sock, he needs search permission on > /var/lib/mysql. > chmod 775 /var/lib/mysql That was it! Thanks for helping me out ;-) Cheers, Andreas -- andreas otto london (uk) - B

Re: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

andreas otto wrote: > > Hi, > > Since SuSE 7.1 I experience the following problem using MySQL: > > andreaso@php4win:~ > mysql -u root -p > Enter password: > ERROR 2002: Can't connect to local MySQL server through socket >'/var/lib/mysql/mysql.sock' (13) > > Looks like I don't get a connection

RE: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

I had the same problem. Ensure that /var has these permissions: drwxr-xr-x Ensure /lib is drwxr-xr-x Ensure /mysql is drwxr-xr-x That fixed it for me rick -Original Message- From: andreas otto [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 6:11 AM To: [EMAIL PROTECTED

Re: Error 2002: can't connect to mysql.sock (Got it!)

/ Then /etc/rc.d/init.d/mysqld restart Everything should be fine after that. Mike > > >> From: "John Jensen" <[EMAIL PROTECTED]> >> Reply-To: [EMAIL PROTECTED] >> Date: Fri, 26 Jan 2001 17:29:10 -0800 >> To: [EMAIL PROTECTED] >> Subject: Re: Error

Re: Error 2002: can't connect to mysql.sock

> Date: Fri, 26 Jan 2001 17:29:10 -0800 > To: [EMAIL PROTECTED] > Subject: Re: Error 2002: can't connect to mysql.sock > > Redhat is funny. I have 7 and had tried everything in the books to > get mysql back up and running after a shutdown. Fortunately, I had an > exper

Re: Error 2002: can't connect to mysql.sock

I've heard that redhat 7 is not that good. They implant many beta version code inside. Sam - Original Message - From: "Mike Tuller" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 27, 2001 9:10 AM Subject: Error 2002: can't connect to mysql.sock > I recently upgrade

Re: Error 2002: can't connect to mysql.sock

Redhat is funny. I have 7 and had tried everything in the books to get mysql back up and running after a shutdown. Fortunately, I had an experienced programmer who had helped me set it up. I queried him and set back this command: /etc/rc.d/init.d/mysqld restart That did the tric