RE: MySQL Error#: 2002
Assuming you copied and pasted the error, it looks like the host made a typo in the config file: '/var/lib/myswl/mysql.sock' Should probably be mysql, not myswl. -Original Message- From: Rick James [mailto:rja...@yahoo-inc.com] Sent: Monday, March 18, 2013 3:32 PM To: Patrice Olivier-Wilson; mysql@lists.mysql.com Subject: RE: MySQL Error#: 2002 Check directory permissions, and check out the 'answers' in here: http://forums.mysql.com/read.php?10,284776,284936 -Original Message- From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com] Sent: Monday, March 18, 2013 12:05 PM To: mysql@lists.mysql.com Subject: MySQL Error#: 2002 I have about 60 websites based on mysql and php. Suddenly they have all gone blank, just white pages. The files are still on the server and I can see the tables in all the databases via myphpadmin interfact. I'm not getting any response from hosting gods yet. When I try to connect to server via Dreamweaver, the error message is: MySQL Error#: 2002 Can't connect to local MySQL server through socket '/var/lib/myswl/mysql.sock'(111). I have one site that uses a different IP number that that site is ok. My static sites, ie, no database inclusion, are ok. Any ideas what to look for, most appreciated. Regards, Patrice Olivier-Wilson 828-628-0500 http://Biz-comm.com b...@biz-comm.com Everything will be alright in the end, so if it is not alright, it is not yet the end. - Quote from movie: The Best Exotic Marigold Hotel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql Notice: This communication may contain privileged and/or confidential information. If you are not the intended recipient, please notify the sender by email, and immediately delete the message and any attachments without copying or disclosing them. LBI may, for any reason, intercept, access, use, and disclose any information that is communicated by or through, or which is stored on, its networks, applications, services, and devices. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: MySQL Error#: 2002
Check directory permissions, and check out the 'answers' in here: http://forums.mysql.com/read.php?10,284776,284936 -Original Message- From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com] Sent: Monday, March 18, 2013 12:05 PM To: mysql@lists.mysql.com Subject: MySQL Error#: 2002 I have about 60 websites based on mysql and php. Suddenly they have all gone blank, just white pages. The files are still on the server and I can see the tables in all the databases via myphpadmin interfact. I'm not getting any response from hosting gods yet. When I try to connect to server via Dreamweaver, the error message is: MySQL Error#: 2002 Can't connect to local MySQL server through socket '/var/lib/myswl/mysql.sock'(111). I have one site that uses a different IP number that that site is ok. My static sites, ie, no database inclusion, are ok. Any ideas what to look for, most appreciated. Regards, Patrice Olivier-Wilson 828-628-0500 http://Biz-comm.com b...@biz-comm.com Everything will be alright in the end, so if it is not alright, it is not yet the end. - Quote from movie: The Best Exotic Marigold Hotel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
MySQL Error#: 2002
I have about 60 websites based on mysql and php. Suddenly they have all gone blank, just white pages. The files are still on the server and I can see the tables in all the databases via myphpadmin interfact. I'm not getting any response from hosting gods yet. When I try to connect to server via Dreamweaver, the error message is: MySQL Error#: 2002 Can't connect to local MySQL server through socket '/var/lib/myswl/mysql.sock'(111). I have one site that uses a different IP number that that site is ok. My static sites, ie, no database inclusion, are ok. Any ideas what to look for, most appreciated. Regards, Patrice Olivier-Wilson 828-628-0500 http://Biz-comm.com b...@biz-comm.com Everything will be alright in the end, so if it is not alright, it is not yet the end. - Quote from movie: The Best Exotic Marigold Hotel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
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 aim.prab...@gmail.com 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.com wrote: 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 # Remember to edit /etc/mysql/debian.cnf when changing the socket location. socket = /var/run/mysqld/mysqld.sock socket = /var/run/mysqld/mysqld.sock socket = /var/run/mysqld/mysqld.sock root@devel:~# /etc/init.d/mysql restart Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! root@devel:~# mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) root@devel:~# cd /var/run/mysqld/ root@devel:/var/run/mysqld# ls root@devel:/var/run/mysqld# Is selinux enabled? If so, check the logs for that. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Best Regards, Prabhat Kumar MySQL DBA My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat -- Claudio
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 database server: mysqld . . . . . . . . . . . . . . failed! Hi, look at /var/log/daemon.log, here you will find the reason. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
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 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 # Remember to edit /etc/mysql/debian.cnf when changing the socket location. socket = /var/run/mysqld/mysqld.sock socket = /var/run/mysqld/mysqld.sock socket = /var/run/mysqld/mysqld.sock root@devel:~# /etc/init.d/mysql restart Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! root@devel:~# mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) root@devel:~# cd /var/run/mysqld/ root@devel:/var/run/mysqld# ls root@devel:/var/run/mysqld# Is selinux enabled? If so, check the logs for that. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
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 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 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/mysqld/mysqld.sock socket = /var/run/mysqld/mysqld.sock socket = /var/run/mysqld/mysqld.sock root@devel:~# /etc/init.d/mysql restart Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! root@devel:~# mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) root@devel:~# cd /var/run/mysqld/ root@devel:/var/run/mysqld# ls root@devel:/var/run/mysqld# Is selinux enabled? If so, check the logs for that. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Best Regards, Prabhat Kumar MySQL DBA My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat
MySQL when running on LiveDVD (GnackTrack - ubuntu based distro) - Error 2002
The following occurs when running the Live version of GnackTrack, if you install from the LiveDVD this issue is no longer present. LiveDVD can be downloaded from www.gnacktrack.co.uk - this can be used to demonstrate issue but i think it's likely somethign simple root@root:~# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) root@root:~# updatedb root@root:~# locate mysqld.sock /rofs/var/run/mysqld/mysqld.sock root@root:~# Snip of /etc/mysql/my.cnf (shortened to show sock location.) [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp skip-external-locking Are there any work arounds for this? What could i do to ensure that mysql can be connected to when running the LiveDVD? more output: root@root:~# mysql -h127.0.0.1 ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111) root@root:~# mysql -S /rofs/var/run/mysqld/mysqld.sock ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/rofs/var/run/mysqld/mysqld.sock' (111) root@root:~#
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
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 now.. is there any way to replace the socket file from another mysql server or i have to reinstall mysql software in this server. if re-installation from the scratch mean what are the steps i have follow before and after installation to safeguard the existing databases.. please provide you assistance to fix this issue.. many thanks in advance.. Best Regards Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com
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/mysql?unsub=arch...@jab.org
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/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 in advance.. Best Regards Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com On Tue, Oct 27, 2009 at 12:03 PM, li...@up-south.com wrote: 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
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 # # FGIN shell script to use fgrep on all /usr/include/h files # # $1, $2, ... options and arguments given to fgrep # # Simple example: #FGIN seteuid return the line(s) in system header files where # 'seteuid()' is defined or otherwise mentioned. # # 2004-09-13 Joerg Bruehe Initial published version find /usr/include -follow -name '*.h' -print | xargs fgrep -n $* This should work regardless of nested includes. It is meant for any system definition, not just for error numbers, that's why I do not restrict the list of file names. If you are looking for an error number (as opposed to an identifier), you may want to filter the output a bit, depending on your system's conventions (example from LinuX): The line you target for is #define ECONNREFUSED111 /* Connection refused */ but all you have is the 111 (the number). 1) grep -n in the script makes it write the line number, so you can filter for : # define (tab or blank, any number) E FGIN 111 | grep ':#define[]*E' (the square bracket contains a blank and a tab). On my system, this brings the output down from 926 lines (the 111 matches a postal code in the GPL comment !) to 9 lines. 2) If you are searching for error numbers, it is highly likely that the file name contains err: FGIN 111 | grep '^[^:]*err' (string err before the first colon). This returns 11 lines for me. 3) Combine the two, and it is only one hit (for me): FGIN 111 | grep ':#define[ ]*E' | grep '^[^:]*err' Try on your system, using 61. HTH, Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
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 Jan 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 = 3306
ndbcluster
socket = /tmp/mysql.sock
query_cache_type = 1
query_cache_size = 26214400
ndb-connectstring=192.168.6.1
max_user_connections = 500
max_connections = 3000
max_connect_errors = 10
table_cache = 2048
thread_cache_size = 500
# log-bin=/usr/local/etc/mysql/log-binario.txt
[MYSQL_CLUSTER]
ndb-connectstring=192.168.6.1
freebsd#
on the script i have...
cnt=0
while true; do
query=insert into Mytable values('99','`date +%d-%H:%M`','$cnt');
/usr/local/bin/mysql -u root -ppasswd -e $query MYDB /dev/null
if [ $cnt -eq 99 ];then
break
else
cnt=`expr $cnt + 1`
fi
done
but it return error on the screen like and this its my PROBLEM! I would
like that all connections finish ok. The errors not apear on mysql_error
file.
: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(61)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
ERRORERROR 2002 (HY000) 2002 (HY000): Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (61)
: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(61)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
ERRORERROR 2002 (HY000) 2002 (HY000): Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (61)
: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(61)
ERRORERROR 2002 (HY000) 2002 (HY000): Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (61)
: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(61)
ERROR 2002 (HY000)ERROR: Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (61)
The file mysql.sock exist...
freebsd# ll /tmp
total 10
drwxrwxrwt 2 root wheel 512 Mar 13 04:00 .ICE-unix
drwxrwxrwt 2 root wheel 512 Mar 13 04:00 .X11-unix
drwxrwxrwt 2 root wheel 512 Mar 13 04:00 .XIM-unix
drwxrwxrwt 2 root wheel 512 Mar 13 04:00 .font-unix
drwxrwxr-x 2 root operator 512 Mar 10 06:44 .snap
srwxrwxrwx 1 mysql wheel 0 Apr 2 16:04 mysql.sock
freebsd#
i change the owner but nothing
freebsd# ll /tmp/mysql.sock
srwxrwxrwx 1 mysql mysql 0 Apr 2 16:04 /tmp/mysql.sock
freebsd#
the Mysql its up
freebsd# ps awx | grep mysqld
25121 p2 S 1:21.87 [mysqld]
freebsd#
When i connect to mysql it show me error
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
but i try again and i in
mysql show status like 'Thre%';
+---+---+
| Variable_name | Value |
+---+---+
| Threads_cached | 94 |
| Threads_connected | 26 |
| Threads_created | 120 |
| Threads_running | 3 |
+---+---+
4 rows in set (0.14 sec)
mysql
--
Ing. Vidal Garza Tirado
Depto. Sistemas
Aduanet S.A. de C.V.
Tel. (867)711-5850 ext. 4346, Fax (867)711-5855.
Ave. César López de Lara No. 3603 Int. B Col Jardín.
Nuevo Laredo, Tamaulipas, México.
--
Este mensaje ha sido analizado por MailScanner
en busca de virus y otros contenidos peligrosos,
y se considera que está limpio.
For all your IT requirements visit: http://www.aduanet.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
Krishna Chandra Prajapati
MySQL DBA,
Email-id: [EMAIL PROTECTED]
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] 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 [[...]] but it return error on the screen like and this its my PROBLEM! I would like that all connections finish ok. The errors not apear on mysql_error file. : Can't connect to local MySQL 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 should be ECONNREFUSED (Connection refused). Then, check your FreeBSD documentation for the possible reasons of this error number. This might give you a hint. On the machine I can access (FreeBSD 6.0), man connect contains this: ERRORS The connect() system call fails if: [[...]] [ECONNREFUSED] The attempt to connect was forcefully rejected. I did not check other calls whether they might return ECONNREFUSED. At the moment, I am at a loss what might cause this reply. Sadly, Stevens (Advanced Programming in the Unix Environment) does not describe it, rather refers to his Unix Network Programming (which I do not have). I propose you consult Google or some other search engine. Your attempt to change the socket owner was bound to fail, IMO, because a permission problem would have produced a different error number (typically, EACCESS). HTH, Jörg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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-RELEASE FreeBSD 6.3-RELEASE #0: Wed Jan 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 I read, the connect information, but i dont find the answer... I change the connection metod script. I set #!/bin/sh ... /usr/local/bin/mysql -h 127.0.0.1 -u root -pmypassword MYDB -e $query ... the -h option but i have a another message error... ... ... ERRORERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (60) ERROR 2003 (HY000) 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (60) ERROR: Can't connect to MySQL server on '127.0.0.1' (60) 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (60) ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (60) ERRORERRORERRORERROR 2003 (HY000) 2003 (HY000) 2003 (HY000) 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (60) : Can't connect to MySQL server on '127.0.0.1' (60) ... There arent message on the systems logs and mysql logs... With a shell i test mysql with ping ... [ Thu Apr 3 11:11:53 CST 2008 ] mysqld is alive [ Thu Apr 3 11:12:35 CST 2008 ] mysqld is alive ... I have a cuestion, where do you find the system header files error number (61)? -- Ing. Vidal Garza Tirado Depto. Sistemas Aduanet S.A. de C.V. Tel. (867)711-5850 ext. 4346, Fax (867)711-5855. Ave. César López de Lara No. 3603 Int. B Col Jardín. Nuevo Laredo, Tamaulipas, México. -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que está limpio. For all your IT requirements visit: http://www.aduanet.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 fgrep # # Simple example: #FGIN seteuid return the line(s) in system header files where # 'seteuid()' is defined or otherwise mentioned. # # 2004-09-13 Joerg Bruehe Initial published version find /usr/include -follow -name '*.h' -print | xargs fgrep -n $* This should work regardless of nested includes. It is meant for any system definition, not just for error numbers, that's why I do not restrict the list of file names. If you are looking for an error number (as opposed to an identifier), you may want to filter the output a bit, depending on your system's conventions (example from LinuX): The line you target for is #define ECONNREFUSED111 /* Connection refused */ but all you have is the 111 (the number). 1) grep -n in the script makes it write the line number, so you can filter for : # define (tab or blank, any number) E FGIN 111 | grep ':#define[]*E' (the square bracket contains a blank and a tab). On my system, this brings the output down from 926 lines (the 111 matches a postal code in the GPL comment !) to 9 lines. 2) If you are searching for error numbers, it is highly likely that the file name contains err: FGIN 111 | grep '^[^:]*err' (string err before the first colon). This returns 11 lines for me. 3) Combine the two, and it is only one hit (for me): FGIN 111 | grep ':#define[ ]*E' | grep '^[^:]*err' Try on your system, using 61. HTH, Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
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]
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 = 3306
ndbcluster
socket = /tmp/mysql.sock
query_cache_type = 1
query_cache_size = 26214400
ndb-connectstring=192.168.6.1
max_user_connections = 500
max_connections = 3000
max_connect_errors = 10
table_cache = 2048
thread_cache_size = 500
# log-bin=/usr/local/etc/mysql/log-binario.txt
[MYSQL_CLUSTER]
ndb-connectstring=192.168.6.1
freebsd#
on the script i have...
cnt=0
while true; do
query=insert into Mytable values('99','`date +%d-%H:%M`','$cnt');
/usr/local/bin/mysql -u root -ppasswd -e $query MYDB /dev/null
if [ $cnt -eq 99 ];then
break
else
cnt=`expr $cnt + 1`
fi
done
but it return error on the screen like and this its my PROBLEM! I would
like that all connections finish ok. The errors not apear on mysql_error
file.
: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
ERRORERROR 2002 (HY000) 2002 (HY000): Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (61)
: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
ERRORERROR 2002 (HY000) 2002 (HY000): Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (61)
: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
ERRORERROR 2002 (HY000) 2002 (HY000): Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (61)
: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
ERROR 2002 (HY000)ERROR: Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (61)
The file mysql.sock exist...
freebsd# ll /tmp
total 10
drwxrwxrwt 2 root wheel 512 Mar 13 04:00 .ICE-unix
drwxrwxrwt 2 root wheel 512 Mar 13 04:00 .X11-unix
drwxrwxrwt 2 root wheel 512 Mar 13 04:00 .XIM-unix
drwxrwxrwt 2 root wheel 512 Mar 13 04:00 .font-unix
drwxrwxr-x 2 root operator 512 Mar 10 06:44 .snap
srwxrwxrwx 1 mysql wheel 0 Apr 2 16:04 mysql.sock
freebsd#
i change the owner but nothing
freebsd# ll /tmp/mysql.sock
srwxrwxrwx 1 mysql mysql 0 Apr 2 16:04 /tmp/mysql.sock
freebsd#
the Mysql its up
freebsd# ps awx | grep mysqld
25121 p2 S 1:21.87 [mysqld]
freebsd#
When i connect to mysql it show me error
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
but i try again and i in
mysql show status like 'Thre%';
+---+---+
| Variable_name | Value |
+---+---+
| Threads_cached | 94 |
| Threads_connected | 26 |
| Threads_created | 120 |
| Threads_running | 3 |
+---+---+
4 rows in set (0.14 sec)
mysql
--
Ing. Vidal Garza Tirado
Depto. Sistemas
Aduanet S.A. de C.V.
Tel. (867)711-5850 ext. 4346, Fax (867)711-5855.
Ave. César López de Lara No. 3603 Int. B Col Jardín.
Nuevo Laredo, Tamaulipas, México.
--
Este mensaje ha sido analizado por MailScanner
en busca de virus y otros contenidos peligrosos,
y se considera que está limpio.
For all your IT requirements visit: http://www.aduanet.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 2002 (HY000): Can't connect to local MySQL server
Try to look under the directory /var/lib/mysql/ You will need to be root or mysql user. the other option is to use locate and type the file name locate mysql.sock If it does not find it try to update the db it uses. updatedb On Wednesday 20 June 2007 00:55:15 John Mancuso wrote: I would try my best to find a way to login as root or maybe user mysql. John Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475 -Original Message- From: Ahamarshan jn [mailto:[EMAIL 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/mysqld.pid 070619 17:40:10 mysqld ended --- John Mancuso [EMAIL PROTECTED] wrote: Hiya, These are the outputs i get when using mysqld_safe --console as root mysqld_safe --console Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 070619 17:45:48 mysqld ended as user [EMAIL PROTECTED] mysql]$ mysqld_safe --console Starting mysqld daemon with databases from /var/lib/mysql /usr/bin/mysqld_safe: line 363: /var/log/mysqld/mysqld.log: Permission denied rm: cannot remove `: Permission denied /usr/bin/mysqld_safe: line 371: /var/log/mysqld/mysqld.log: Permission denied STOPPING server from pid file /var/run/mysqld/mysqld.pid tee: /var/log/mysqld/mysqld.log: Permission denied 070619 17:46:52 mysqld ended tee: /var/log/mysqld/mysqld.log: Permission denied I could not locate the logdirectory, any pointers to this please? - ash# Start mysqld_safe with --console OR --error-log=/logdirectory/errlog.err --console will print your errors to the screen ./mysqld_safe --console John Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475 -Original Message- From: Ahamarshan 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] wrote: Have you looked in your mysql error log in your data directory? Check /datadir/hostname.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 -Original Message- From: Ahamarshan jn [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 11:54 AM To: mysql@lists.mysql.com Subject: ERROR 2002 (HY000): Can't connect to local MySQL server Hi, I was appending Grant previledges to some databases in mysql; either i typed something wrong or there is a bug which I am uncertain about, but what happened was I could not login as su anymore. I then solved this problem by changing grp (chgrp) permission in /bin/su and it works fine. However I could not connect to mysql again When I start mysql I get the following error $ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I could not start nor stop any running mysql I tried to reboot my system hoping that the process will terminate and restart fresh but during shutdown I see the message that mysql shutdown failed. Upon booting again I could not start mysql Even though it shows the file here [EMAIL PROTECTED] locate mysql.sock /var/lib/mysql/mysql.sock the cat of my.cnf is $ cat my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with old and # shorter password hash. # Reference: http://dev.mysql.com/doc/mysql/en/Password_hashing.html old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Also I tried to kill mysql by using PID ie kill -9 'PID' but each time the PID changes when i do ps -ax|grep mysql and it fails to kill mysql. Can some Mysql messiah help me solve this problem. Thank you in advance - ash# PS: I guessed it was quite a common error but when searched through the list it retrived me null post, hence I am posting this. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing
ERROR 2002 (HY000): Can't connect to local MySQL server
Hi, I was appending Grant previledges to some databases in mysql; either i typed something wrong or there is a bug which I am uncertain about, but what happened was I could not login as su anymore. I then solved this problem by changing grp (chgrp) permission in /bin/su and it works fine. However I could not connect to mysql again When I start mysql I get the following error $ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I could not start nor stop any running mysql I tried to reboot my system hoping that the process will terminate and restart fresh but during shutdown I see the message that mysql shutdown failed. Upon booting again I could not start mysql Even though it shows the file here [EMAIL PROTECTED] locate mysql.sock /var/lib/mysql/mysql.sock the cat of my.cnf is $ cat my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with old and # shorter password hash. # Reference: http://dev.mysql.com/doc/mysql/en/Password_hashing.html old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Also I tried to kill mysql by using PID ie kill -9 'PID' but each time the PID changes when i do ps -ax|grep mysql and it fails to kill mysql. Can some Mysql messiah help me solve this problem. Thank you in advance - ash# PS: I guessed it was quite a common error but when searched through the list it retrived me null post, hence I am posting this. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[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 /datadir/hostname.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 -Original Message- From: Ahamarshan jn [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 11:54 AM To: mysql@lists.mysql.com Subject: ERROR 2002 (HY000): Can't connect to local MySQL server Hi, I was appending Grant previledges to some databases in mysql; either i typed something wrong or there is a bug which I am uncertain about, but what happened was I could not login as su anymore. I then solved this problem by changing grp (chgrp) permission in /bin/su and it works fine. However I could not connect to mysql again When I start mysql I get the following error $ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I could not start nor stop any running mysql I tried to reboot my system hoping that the process will terminate and restart fresh but during shutdown I see the message that mysql shutdown failed. Upon booting again I could not start mysql Even though it shows the file here [EMAIL PROTECTED] locate mysql.sock /var/lib/mysql/mysql.sock the cat of my.cnf is $ cat my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with old and # shorter password hash. # Reference: http://dev.mysql.com/doc/mysql/en/Password_hashing.html old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Also I tried to kill mysql by using PID ie kill -9 'PID' but each time the PID changes when i do ps -ax|grep mysql and it fails to kill mysql. Can some Mysql messiah help me solve this problem. Thank you in advance - ash# PS: I guessed it was quite a common error but when searched through the list it retrived me null post, hence I am posting this. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ERROR 2002 (HY000): Can't connect to local MySQL server
Start mysqld_safe with --console OR --error-log=/logdirectory/errlog.err --console will print your errors to the screen ./mysqld_safe --console John Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475 -Original Message- From: Ahamarshan 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] wrote: Have you looked in your mysql error log in your data directory? Check /datadir/hostname.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 -Original Message- From: Ahamarshan jn [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 11:54 AM To: mysql@lists.mysql.com Subject: ERROR 2002 (HY000): Can't connect to local MySQL server Hi, I was appending Grant previledges to some databases in mysql; either i typed something wrong or there is a bug which I am uncertain about, but what happened was I could not login as su anymore. I then solved this problem by changing grp (chgrp) permission in /bin/su and it works fine. However I could not connect to mysql again When I start mysql I get the following error $ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I could not start nor stop any running mysql I tried to reboot my system hoping that the process will terminate and restart fresh but during shutdown I see the message that mysql shutdown failed. Upon booting again I could not start mysql Even though it shows the file here [EMAIL PROTECTED] locate mysql.sock /var/lib/mysql/mysql.sock the cat of my.cnf is $ cat my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with old and # shorter password hash. # Reference: http://dev.mysql.com/doc/mysql/en/Password_hashing.html old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Also I tried to kill mysql by using PID ie kill -9 'PID' but each time the PID changes when i do ps -ax|grep mysql and it fails to kill mysql. Can some Mysql messiah help me solve this problem. Thank you in advance - ash# PS: I guessed it was quite a common error but when searched through the list it retrived me null post, hence I am posting this. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ERROR 2002 (HY000): Can't connect to local MySQL server
I would try my best to find a way to login as root or maybe user mysql. John Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475 -Original Message- From: Ahamarshan jn [mailto:[EMAIL 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/mysqld.pid 070619 17:40:10 mysqld ended --- John Mancuso [EMAIL PROTECTED] wrote: Hiya, These are the outputs i get when using mysqld_safe --console as root mysqld_safe --console Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 070619 17:45:48 mysqld ended as user [EMAIL PROTECTED] mysql]$ mysqld_safe --console Starting mysqld daemon with databases from /var/lib/mysql /usr/bin/mysqld_safe: line 363: /var/log/mysqld/mysqld.log: Permission denied rm: cannot remove `/var/lib/mysql/mysql.sock': Permission denied /usr/bin/mysqld_safe: line 371: /var/log/mysqld/mysqld.log: Permission denied STOPPING server from pid file /var/run/mysqld/mysqld.pid tee: /var/log/mysqld/mysqld.log: Permission denied 070619 17:46:52 mysqld ended tee: /var/log/mysqld/mysqld.log: Permission denied I could not locate the logdirectory, any pointers to this please? - ash# Start mysqld_safe with --console OR --error-log=/logdirectory/errlog.err --console will print your errors to the screen ./mysqld_safe --console John Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475 -Original Message- From: Ahamarshan 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] wrote: Have you looked in your mysql error log in your data directory? Check /datadir/hostname.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 -Original Message- From: Ahamarshan jn [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 11:54 AM To: mysql@lists.mysql.com Subject: ERROR 2002 (HY000): Can't connect to local MySQL server Hi, I was appending Grant previledges to some databases in mysql; either i typed something wrong or there is a bug which I am uncertain about, but what happened was I could not login as su anymore. I then solved this problem by changing grp (chgrp) permission in /bin/su and it works fine. However I could not connect to mysql again When I start mysql I get the following error $ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I could not start nor stop any running mysql I tried to reboot my system hoping that the process will terminate and restart fresh but during shutdown I see the message that mysql shutdown failed. Upon booting again I could not start mysql Even though it shows the file here [EMAIL PROTECTED] locate mysql.sock /var/lib/mysql/mysql.sock the cat of my.cnf is $ cat my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with old and # shorter password hash. # Reference: http://dev.mysql.com/doc/mysql/en/Password_hashing.html old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Also I tried to kill mysql by using PID ie kill -9 'PID' but each time the PID changes when i do ps -ax|grep mysql and it fails to kill mysql. Can some Mysql messiah help me solve this problem. Thank you in advance - ash# PS: I guessed it was quite a common error but when searched through the list it retrived me null post, hence I am posting this. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help ERROR 2002
I don't know what happened. I was doing a very big query and now I'm not Able to access mysql. This is the error I get when I try to use command: Mysql -u root -p ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) How do I fix this? This is affecting my websites as it cannot locate my databases. Thanks, Ngim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Help ERROR 2002
Okay all seems to be fine now. All I did was restart the server for the 2nd time And now it seems to connect to mysql. Whew! I was starting to panic there. -Original Message- From: nngau [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 03, 2006 3:42 PM To: mysql@lists.mysql.com Subject: Help ERROR 2002 I don't know what happened. I was doing a very big query and now I'm not Able to access mysql. This is the error I get when I try to use command: Mysql -u root -p ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) How do I fix this? This is affecting my websites as it cannot locate my databases. Thanks, Ngim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Post-Installation Setup Problems: error[2002 1604]
Hello. MySQL 3.xx is almost out of support now. Even no bugs fixed in 3.23 (only very critical ones). General reasons about old software and it's problems can be used in your dialog with hosting provider. Usually providers leave servers with MySQL 3.xx in use and provide a new one with MySQL 4.1. Clients port their applications to the new server by themselves (if they want it, of course). grin it get worse . most of my commercial work is running on servers with ver 3.23.X (sun and RH servers). I enjoy a great relationship with my domain hoster (who is also a programmer who uses mysql a lot), but he has been very cautious about upgrading any of his servers, being concerned about code breaking, etc. What argument might be provided to him to upgrade and what caveats might be cited? Thanks very much for the pointer to the docs. regards tim -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Post-Installation Setup Problems: error[2002 1604]
Tim Johnson wrote: grin it get worse . most of my commercial work is running on servers with ver 3.23.X (sun and RH servers). I enjoy a great relationship with my domain hoster (who is also a programmer who uses mysql a lot), but he has been very cautious about upgrading any of his servers, being concerned about code breaking, etc. What argument might be provided to him to upgrade and what caveats might be cited? Details on how to upgrade are available at: http://dev.mysql.com/doc/mysql/en/upgrade.html It seems that the 4.0.x branche will not live very long anymore, so upgrading to 4.1.x (via 4.0) might be a good idea if he wants to upgrade. http://dev.mysql.com/doc/mysql/en/news.html Lists all the changes in each version. The major features can be found in the D.2 and D.3 documents (for 4.1 and 4.0). As a hoster he will probably also need to support PHP, etc. There is also a nice book by Adam Trachtenberg: Upgrading to PHP5 (O'Reilly, July, 2004, 352 p., ISBN 0596006365) which also contains information on how to migrate to PHP5/MySQL4.1 in several steps. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Post-Installation Setup Problems: error[2002 1604]
Hello.
I'm getting the following problems:
Login Problem:
See:
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
Problems unencrypting password:
OLD_PASSWORD() is available as of MySQL 4.1. 4.0.20 is a very old
version. I strongly recommend you to upgrade to the latest release
(4.1.13 now).
Tim Johnson [EMAIL PROTECTED] wrote:
Hello:
OS: Linux Slackware 10.0
Ver: 4.0.20
Network Status: Closed to outside world
After installation:
I'm getting the following problems:
Login Problem:
mysql --host=localhost --user=root --password=**
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13)
What works:
mysql -u tim -p
Enter password: * # works
---
Problems unencrypting password:
SET PASSWORD FOR 'tim'@'localhost' = OLD_PASSWORD('**')
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near
'OLD_PASSWORD('marion')' at line 1
## Note: am unclear what is wrong with syntax
## Host table dump below:
SELECT Host, User FROM mysql.user;
+---+--+
| Host | User |
+---+--+
| linus | |
| linus | root |
| linus | tim |
| linus.johnson.com | tim |
| localhost | |
| localhost | root |
| localhost | tim |
+---+--+
Any advice is appreciated:
Am working from the installed docs.
Thanks
tj
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Post-Installation Setup Problems: error[2002 1604]
* Gleb Paharenko [EMAIL PROTECTED] [050815 10:59]: Hello. I'm getting the following problems: Login Problem: See: http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html That's going to be really helpful. Thanks. Problems unencrypting password: OLD_PASSWORD() is available as of MySQL 4.1. 4.0.20 is a very old version. I strongly recommend you to upgrade to the latest release (4.1.13 now). grin it get worse . most of my commercial work is running on servers with ver 3.23.X (sun and RH servers). I enjoy a great relationship with my domain hoster (who is also a programmer who uses mysql a lot), but he has been very cautious about upgrading any of his servers, being concerned about code breaking, etc. What argument might be provided to him to upgrade and what caveats might be cited? Thanks very much for the pointer to the docs. regards tim -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Post-Installation Setup Problems: error[2002 1604]
Hello:
OS: Linux Slackware 10.0
Ver: 4.0.20
Network Status: Closed to outside world
After installation:
I'm getting the following problems:
Login Problem:
mysql --host=localhost --user=root --password=**
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13)
What works:
mysql -u tim -p
Enter password: * # works
---
Problems unencrypting password:
SET PASSWORD FOR 'tim'@'localhost' = OLD_PASSWORD('**')
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near
'OLD_PASSWORD('marion')' at line 1
## Note: am unclear what is wrong with syntax
## Host table dump below:
SELECT Host, User FROM mysql.user;
+---+--+
| Host | User |
+---+--+
| linus | |
| linus | root |
| linus | tim |
| linus.johnson.com | tim |
| localhost | |
| localhost | root |
| localhost | tim |
+---+--+
Any advice is appreciated:
Am working from the installed docs.
Thanks
tj
--
Tim Johnson [EMAIL PROTECTED]
http://www.alaska-internet-solutions.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error 2002:
Hi All, I get the following error in Fedora3 when trying to run mysql from the cli, [EMAIL PROTECTED] mysql]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I installed mysql via yum. I'm rather new to Linux and even more so to MysSQL. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 following error in Fedora3 when trying to run mysql from the cli, [EMAIL PROTECTED] mysql]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I installed mysql via yum. I'm rather new to Linux and even more so to MysSQL. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 following error in Fedora3 when trying to run mysql from the cli, [EMAIL PROTECTED] mysql]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I installed mysql via yum. I'm rather new to Linux and even more so to MysSQL. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Hi All, output =, [EMAIL PROTECTED] mysql]# ps aux | grep mysqld root 4896 0.0 0.2 5300 660 pts/2S+ 00:02 0:00 grep mysqld Sorry, don't un it, eh. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 options if this involves: manual server start, setting up autostart, etc. Thanks -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
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 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 options if this involves: manual server start, setting up autostart, etc. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error 2002
I have upgraded my Debian box from MySQL version 3.23 to version 4.19. Everything works perfectly fine except on the local box. Therefore I'm sure it has something to do with sockets. When I am logged in as root I can connect to the server fine, when I am logged in as a user I get this error messsage: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) My /tmp directory has these permissions: drwxrwxrwt5 root root 4096 Feb 10 11:46 tmp/ and mysql.sock has these permissions: srwxrwxrwx1 mysqlmysql 0 Feb 9 11:36 mysql.sock= I'm not quite sure what is going on, it seems like a permissions issue, but permissions seem to be ok. Michael
RE: Error 2002
I will try to explain what I have done: The previous version of MySQL had some different directory structure. The .pid and .sock files were placed in /var/run/mysqld/, so instead of changing this after the upgrade I attempted to change my /etc/my.cnf file to reflect this. There was a [client] group in that file which I pointed the socket to /var/run/mysqld/mysqld.sock. For some reason this would only work with root (in retrospect, perphaps the my.cnf file is not readable to regular users, hence the skip -- just checked, that is the case). I took out those lines and 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 and I had to start mysql Nestor :-) -Original Message- From: Dean, Michael L USAATC [EMAIL PROTECTED] Sent: Feb 10, 2005 9:02 AM To: 'mysql@lists.mysql.com' mysql@lists.mysql.com Subject: Error 2002 I have upgraded my Debian box from MySQL version 3.23 to version 4.19. Everything works perfectly fine except on the local box. Therefore I'm sure it has something to do with sockets. When I am logged in as root I can connect to the server fine, when I am logged in as a user I get this error messsage: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) My /tmp directory has these permissions: drwxrwxrwt5 root root 4096 Feb 10 11:46 tmp/ and mysql.sock has these permissions: srwxrwxrwx1 mysqlmysql 0 Feb 9 11:36 mysql.sock= I'm not quite sure what is going on, it seems like a permissions issue, but permissions seem to be ok. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Hello! I'm new to MySQl and I have sevral problems to get the Mysql-server going. First of all, when trying to connect (in mysqlcc) I get the following error message: [MySQL] ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Hoe can I get this working? Laurent -- Linux is like an Indian tent: no Windows, no Gates, and an Apache inside! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, 2004 12:46 PM Subject: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Hello! I'm new to MySQl and I have sevral problems to get the Mysql-server going. First of all, when trying to connect (in mysqlcc) I get the following error message: [MySQL] ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Hoe can I get this working? Laurent -- Linux is like an Indian tent: no Windows, no Gates, and an Apache inside! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 restart mysqld and find it working :-) ... but it still doesn't work... I checked the runlevel editor where mysql was not started, so it's no miracle it doesn't work! After ahving the new Mysql 4.0 Server installed, I started that service in runlevel editor and now it ssems to work! Laurent -- Linux is like an Indian tent: no Windows, no Gates, and an Apache inside! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 2002: Can't connect to local MySQL server through socket
I have installed MySQL provided with SuSE Linux 9.0. My intention was to figure out how it could be used with PHP that is running on Apache. I managed to install all required RPM packages, but when I try to laynch MySQL (just typing MySQL], the following error message is displayed: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/ mysql/mysql.sock' (2) I checked the directory '/var/lib/mysql/' and there is no such file. How should I generate one? The server is just a localhost if this has any impact. Regards Sami -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: Mysql Installation on Linux: ERROR 2002: Can't connect to local MySQL server th
Probably your server is not using any sockets, check out your my.cnf. man mysql to see how to connect to a ip based mysql host. C/ya! On Sat, 2004-01-17 at 18:51, Mike Mapsnac wrote: I just install MYSQL on Linux (Red Hat 9) using this manual:http://www.mysql.com/doc/en/Installing_binary.html Have no idea what's wrong. I looked on the mysql.log file and the file is empty. ERROR MESSAGE: [EMAIL PROTECTED] bin]# ./mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [EMAIL PROTECTED] bin]# ./mysql status ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' _ Scope out the new MSN Plus Internet Software optimizes dial-up to the max! http://join.msn.com/?pgmarket=en-uspage=byoa/plusST=1 -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|ext. 325 | ||geek by nature - linux by choice | |...| ... Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. Rich Cook
Re: Mysql Installation on Linux: ERROR 2002: Can't connect tolocal MySQL server
Weird. I cannot find the my.cnf (configuration file).. How that's possible? Thanks From: Victor Medina [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Mysql Installation on Linux: ERROR 2002: Can't connect tolocal MySQL server th Date: Sun, 18 Jan 2004 10:24:53 -0400 Probably your server is not using any sockets, check out your my.cnf. man mysql to see how to connect to a ip based mysql host. C/ya! On Sat, 2004-01-17 at 18:51, Mike Mapsnac wrote: I just install MYSQL on Linux (Red Hat 9) using this manual:http://www.mysql.com/doc/en/Installing_binary.html Have no idea what's wrong. I looked on the mysql.log file and the file is empty. ERROR MESSAGE: [EMAIL PROTECTED] bin]# ./mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [EMAIL PROTECTED] bin]# ./mysql status ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' _ Scope out the new MSN Plus Internet Software optimizes dial-up to the max! http://join.msn.com/?pgmarket=en-uspage=byoa/plusST=1 -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|ext. 325 | ||geek by nature - linux by choice | |...| ... Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. Rich Cook _ Check out the new MSN 9 Dial-up fast reliable Internet access with prime features! http://join.msn.com/?pgmarket=en-uspage=dialup/homeST=1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql Installation on Linux: ERROR 2002: Can't connect to local MySQL server th
I just install MYSQL on Linux (Red Hat 9) using this manual:http://www.mysql.com/doc/en/Installing_binary.html Have no idea what's wrong. I looked on the mysql.log file and the file is empty. ERROR MESSAGE: [EMAIL PROTECTED] bin]# ./mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [EMAIL PROTECTED] bin]# ./mysql status ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' _ Scope out the new MSN Plus Internet Software optimizes dial-up to the max! http://join.msn.com/?pgmarket=en-uspage=byoa/plusST=1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Mysql Installation on Linux: ERROR 2002: Can't connect to local MySQL server th
Hi Mike, You have to start the mysql server before you can run the client. Try running mysqld_safe --user=mysql from /usr/bin or /usr/local/bin, depending on where you installed it. To see if it is running currently on your machine, try this: ps -ef | grep mysqld Hope this helps... ~~Nick --- On Sat 01/17, Mike Mapsnac [EMAIL PROTECTED] wrote: From: Mike Mapsnac [mailto: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Sat, 17 Jan 2004 22:51:29 + Subject: Mysql Installation on Linux: ERROR 2002: Can't connect to local MySQL server th I just install MYSQL on Linux (Red Hat 9)brusing this manual:http://www.mysql.com/doc/en/Installing_binary.htmlbrHave no idea what's wrong. I looked on the mysql.log file and the file is brempty.brbrERROR MESSAGE:br[EMAIL PROTECTED] bin]# ./mysqlbrERROR 2002: Can't connect to local MySQL server through socket br'/tmp/mysql.sock' (2)br[EMAIL PROTECTED] bin]# ./mysql statusbrERROR 2002: Can't connect to local MySQL server through socket br'/tmp/mysql.sock'brbr_brScope out the new MSN Plus Internet Software optimizes dial-up to the max! br http://join.msn.com/?pgmarket=en-uspage=byoa/plusST=1brbrbr-- brMySQL General Mailing ListbrFor list archives: http://lists.mysql.com/mysqlbrTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]brbr ___ Join Excite! - http://www.excite.com The most personalized portal on the Web! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Getting error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
I am trying to connect to mysql database. getting error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Can not shutdown as well as restart. Please help me Thanks for support. - Do you Yahoo!? Free Pop-Up Blocker - Get it now
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 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 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 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? The mysql.sock file only exists while MySQL is running. Maybe you installed MySQL but haven't started it. I don't know how Mandrake handles starting stopping services, but you should have a script: /etc/init.d/mysql ( or something like that ). Try: /etc/init.d/mysql start That's what starts it on mine anyway. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 else. Daniel Kasak 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 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? The mysql.sock file only exists while MySQL is running. Maybe you installed MySQL but haven't started it. I don't know how Mandrake handles starting stopping services, but you should have a script: /etc/init.d/mysql ( or something like that ). Try: /etc/init.d/mysql start That's what starts it on mine anyway. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
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] 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 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? The mysql.sock file only exists while MySQL is running. Maybe you installed MySQL but haven't started it. I don't know how Mandrake handles starting stopping services, but you should have a script: /etc/init.d/mysql ( or something like that ). Try: /etc/init.d/mysql start That's what starts it on mine anyway. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error 2002
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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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? The mysql.sock file only exists while MySQL is running. Maybe you installed MySQL but haven't started it. I don't know how Mandrake handles starting stopping services, but you should have a script: /etc/init.d/mysql ( or something like that ). Try: /etc/init.d/mysql start That's what starts it on mine anyway. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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? The mysql.sock file only exists while MySQL is running. Maybe you installed MySQL but haven't started it. I don't know how Mandrake handles starting stopping services, but you should have a script: /etc/init.d/mysql ( or something like that ). Try: /etc/init.d/mysql start That's what starts it on mine anyway. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au
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/mysqld_safe Password: Starting mysqld daemon with databases from /usr/local/mysql/data 030707 12:31:53 mysqld ended mysqld isn't running. Look in the host_name.err file in the MySQL data dir to see error message. [Computer:/usr/local/mysql] mark% bg bg: No current job. Instructions state that I should now be able to connect to MySQL server, e.g. by running [Computer:/usr/local/mysql] mark% /usr/local/mysql/bin/mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) It appears that the server is not running...any suggestions? I have checked to see if the mysql.sock exists and it appears to be there: [Computer:/usr/local/mysql] mark% ls /tmp 501 mysql.sock printers printing.462 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 2002: Can't connect to local MySQL server through socket
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/mysqld_safe Password: Starting mysqld daemon with databases from /usr/local/mysql/data 030707 12:31:53 mysqld ended [Computer:/usr/local/mysql] mark% bg bg: No current job. Instructions state that I should now be able to connect to MySQL server, e.g. by running [Computer:/usr/local/mysql] mark% /usr/local/mysql/bin/mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) It appears that the server is not running...any suggestions? I have checked to see if the mysql.sock exists and it appears to be there: [Computer:/usr/local/mysql] mark% ls /tmp 501 mysql.sock printers printing.462 Thank you, Mark D -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error 2002
Good day to all; I'm new to this group; ERROR 2002: Can't connect to local MySQL Server through socket '/var/lib/mysql/mysql.sock' (111). The os is SUSE 8.1 and MySQL 4.0.13. This error has been plaqueing me for weeks and after many re-installs have resorted to the kind assistance of this group. I'm new to Linux/MySQL and need to get this MySQL server running. Are there any suggestions that I can employ here? Thank you. Paul Stonehocker __ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I use MDK 8.2 and MySQL 4.0.13 i found this error ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Can anyone help me to solve this problem ? Thank u for advance
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 connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I use MDK 8.2 and MySQL 4.0.13 i found this error ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Can anyone help me to solve this problem ? Thank u for advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ERROR 2002: Can't connect to local MySQL server through socke t '/var/lib/mysql/mysql.sock' (2)
You should be able to find a file in your data directory titled hostname.err. What is the content of that file? If the server is having problems running, you'll more than likely find information in that .err file. -Original Message- From: Christensen, Dave [mailto:[EMAIL PROTECTED] 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: 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 connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I use MDK 8.2 and MySQL 4.0.13 i found this error ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Can anyone help me to solve this problem ? Thank u for advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: My SQL ERROR 2002
skjois [EMAIL PROTECTED] wrote: I get this error ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) how can i get rid of this? Easily. Start MySQL and get rid of the message. :-) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 RedHat 8.0. The installation ran smoothly ; but when trying to start MySQL, from the terminal this appeared communiqué: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) What I should to do? Thanks in advance to all who reply! Best regards, Tomasz Krasiel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ERROR 2002
no mysql.sock file on machine. I'll remove mysql package and reinstall it and see if things go better then.On Tue, 4 Feb 2003, Brian Johnson wrote: Date: Tue, 4 Feb 2003 14:33:54 -0600 From: Brian Johnson [EMAIL PROTECTED] To: 'Tomasz Krasiel' [EMAIL 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: Tuesday, February 04, 2003 6:56 AM To: [EMAIL PROTECTED] Subject: ERROR 2002 I installed MySQL 3.23.54 on RedHat 8.0. The installation ran smoothly ; but when trying to start MySQL, from the terminal this appeared communiqué: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) What I should to do? Thanks in advance to all who reply! Best regards, Tomasz Krasiel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Jude dashielljt(at)gmpexpress-dot-net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 2002
I installed MySQL 3.23.54 on RedHat 8.0. The installation ran smoothly ; but when trying to start MySQL, from the terminal this appeared communiqu: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) What I should to do? Thanks in advance to all who reply! Best regards, Tomasz Krasiel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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.sock' (111)' } Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! Looks like the error message is pretty clear - mysqld is not running. MySQL is a client/server application - there is a server that needs to run, and then the client can connect to that server. You need to make sure that mysqld is running. Since it appears you're on a linux box, you can run this command: ps aux |grep mysql [Edwinraj@edwinraj Edwinraj]$ ps aux | grep mysql root 1176 0.0 0.0 1676 0 ? SW 11:27 0:00 [safe_mysqld] mysql 1200 0.0 0.0 10572 36 ? S 11:27 0:00 [mysqld] mysql 1202 0.0 0.0 10572 36 ? S 11:27 0:00 [mysqld] mysql 1203 0.0 0.0 10572 36 ? S 11:27 0:00 [mysqld] Edwinraj 1826 0.0 0.8 1360 516 pts/1 S 15:13 0:00 grep mysql So I assume the server is running If nothing comes up, then you need to start mysqld. It may reside in /usr/sbin. You should probably check the MySQL manual: http://www.mysql.com/doc/en/Post-installation.html Yes went through it and this is what I get [root@edwinraj mysql]# ./scripts/mysql_install_db Installing all prepared tables 021115 16:06:37 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h edwinraj.naturesoft.com password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com and also [root@edwinraj mysql]# ./bin/safe_mysqld --user=mysql [1] 1953 [root@edwinraj mysql]# Starting mysqld daemon with databases from /usr/local/mysql-3.23.52-pc-linux-gnu-i686/data 021115 16:07:31 mysqld ended Any ideas Thanks for the reply Edwin HTH, /vjl/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
Hello Friends, I have installed mysql version 3.23.52 binary file. The installation went well without any errors but when I type mysql in the command prompt I get this error. Can someone help me fix this. Am using red hat 6.2 version Rgds Edwin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! Edwin Raj wrote: Hello Friends, I have installed mysql version 3.23.52 binary file. The installation went well without any errors but when I type mysql in the command prompt I get this error. Can someone help me fix this. Am using red hat 6.2 version Rgds Edwin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 mysqld is running and that the socket: '/tmp/mysql.sock' exists! Looks like the error message is pretty clear - mysqld is not running. MySQL is a client/server application - there is a server that needs to run, and then the client can connect to that server. You need to make sure that mysqld is running. Since it appears you're on a linux box, you can run this command: ps aux |grep mysql If nothing comes up, then you need to start mysqld. It may reside in /usr/sbin. You should probably check the MySQL manual: http://www.mysql.com/doc/en/Post-installation.html HTH, /vjl/ -- Vince LaMonica UC Irvine, School of Social Ecology W3 Developer * 116 Social Ecology I, Irvine, CA 92697 [EMAIL PROTECTED] http://www.seweb.uci.edu/techsupport No matter what happens, somebody will find a way to take it too seriously. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
why do i get an erro like ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) what could be wrong with this error please send me the reason for it and also how do i overcome this problem regards samratsam Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from http://www.planetm.co.in Change the way you talk. Indiatimes presents Valufon, Your PC to Phone service with clear voice at rates far less than the normal ISD rates. Go to http://www.valufon.indiatimes.com. Choose your plan. BUY NOW. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 server through socket '/var/lib/mysql/mysql.sock' (111) why do i get an erro like ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) what could be wrong with this error please send me the reason for it and also how do i overcome this problem regards samratsam Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from http://www.planetm.co.in Change the way you talk. Indiatimes presents Valufon, Your PC to Phone service with clear voice at rates far less than the normal ISD rates. Go to http://www.valufon.indiatimes.com. Choose your plan. BUY NOW. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 message ERROR 2002: Can't connect to CW local MySQL server through socket '/var/lib/mysql/msql.sock' (111) CW 3. Follow the Binary installation CW 4. At ./scripts/mysql_install_db, there is a message ./bin/mysqld: Shutdown CW Complete CW 5. At ./bin/safe_mysqld --user=mysql , there is a message mysqld ended Your MySQL server doesn't run. To look for possible causes of failed start look into host_name.err file in the MySQL data dir. CW 6. mysql command still cannot be executed successfully with the message in CW the 2nd step. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 2002
Very sorry for my childish question, I'm just starting to learn about MySQL Following is my procedure in fixing the problem of installation on Intel PC, and Linux RH7.3. 1. RPM installation 2. When execute mysql, there is a message ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/msql.sock' (111) 3. Follow the Binary installation 4. At ./scripts/mysql_install_db, there is a message ./bin/mysqld: Shutdown Complete 5. At ./bin/safe_mysqld --user=mysql , there is a message mysqld ended 6. mysql command still cannot be executed successfully with the message in the 2nd step. --- Chai Wutiwiwatchai Furui Laboratory, Department of Computer Science, Tokyo Institute of Technology --- _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
THIS IS NOT AN ADVERTISEMENT, ERROR 2002
Very sorry for my childish question, I'm just starting to learn about MySQL Following is my procedure in fixing the problem of installation on Intel PC, and Linux RH7.3. 1. RPM installation 2. When execute mysql, there is a message ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/msql.sock' (111) 3. Follow the Binary installation 4. At ./scripts/mysql_install_db, there is a message ./bin/mysqld: Shutdown Complete 5. At ./bin/safe_mysqld --user=mysql , there is a message mysqld ended 6. mysql command still cannot be executed successfully with the message in the 2nd step. --- Chai Wutiwiwatchai Furui Laboratory, Department of Computer Science, Tokyo Institute of Technology --- _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Hi Kathy, I don't have that file in my folder, but it still starts. Colin. To fix this i checked the hostname.err file in mysql/data. From looking at this i found the lines that gave me errors, i played around with these and ended up getting an error like 'the socket is already binded' or something ( i put in the host name --host=). I found out that there was the a version of mysql was already on the machine, i was able to take it off, and hey presto, i haven't had the problem since --- Kathy Reyes [EMAIL PROTECTED] wrote: if I dont have the mysql.sock running in the temp folder how do I start it??? I tried service mysql start and it did work it give me the same error in the subject line - Original Message - From: andy thomas [EMAIL PROTECTED] To: colin o [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) 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. --- Mike Yrabedra [EMAIL PROTECTED] wrote: What would cause this error to occur all of a sudden? ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Is the socket? It should show up in a directory listing of /tmp - if it isn't there then mysqld isn't running. Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://http://taxes.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL - ERROR 2002
Andrew, Tuesday, April 02, 2002, 10:06:42 AM, you wrote: A I keep on getting the following error message when trying to connect to A MySQL - ERROR 2002: Can't connect to local MySQL server through socket A '/var/lib/mysql/mysql.sock' A This can be fixed by creating a link from the /tmp/mysql.sock file. Which I A have done and still get the same error A I have searched on Google and on Mysql.com (plus a whole range of other A Linux sites) and I realize the default directory for Mysql was the directory A as it comes with RH7.2 - I have re-installed a newer version of MySQL with A RPMs and still get the same error. A Before I try re-install with the binary version has anybody had a similar A problem ? 1. Is your MySQL server running? 2. Give me contents of your .err file. A Thanks. A Andrew -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
if I dont have the mysql.sock running in the temp folder how do I start it??? I tried service mysql start and it did work it give me the same error in the subject line - Original Message - From: andy thomas [EMAIL PROTECTED] To: colin o [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) 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. --- Mike Yrabedra [EMAIL PROTECTED] wrote: What would cause this error to occur all of a sudden? ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Is the socket? It should show up in a directory listing of /tmp - if it isn't there then mysqld isn't running. Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL - ERROR 2002
G'day, I keep on getting the following error message when trying to connect to MySQL - ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' This can be fixed by creating a link from the /tmp/mysql.sock file. Which I have done and still get the same error I have searched on Google and on Mysql.com (plus a whole range of other Linux sites) and I realize the default directory for Mysql was the directory as it comes with RH7.2 - I have re-installed a newer version of MySQL with RPMs and still get the same error. Before I try re-install with the binary version has anybody had a similar problem ? Thanks. Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error 2002:
Good afternoon one and all, Well, I took the plunge and am trying to get to grips with this Linux and have fallen at the first hurdle with MySQL. When I type mysql from my shell prompt (logged in as root) I get the following message ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I've done some searching and it looks like mysqld needs starting so I ran safe_mysqld and got this: [root@Linux /root]# Starting mysqld daemon with databases from /var/lib/mysql 020329 16:49:58 mysqld ended I know I must have missed something obvious but if anyone could give me any pointers I'd be grateful. Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error 2002:
Andy, Friday, March 29, 2002, 7:04:29 PM, you wrote: AJ Well, I took the plunge and am trying to get to grips with this Linux and AJ have fallen at the first hurdle with MySQL. When I type mysql from my AJ shell prompt (logged in as root) I get the following message AJ ERROR 2002: Can't connect to local MySQL server through socket AJ '/var/lib/mysql/mysql.sock' (111) AJ I've done some searching and it looks like mysqld needs starting so I ran AJ safe_mysqld and got this: AJ [root@Linux /root]# Starting mysqld daemon with databases from AJ /var/lib/mysql AJ 020329 16:49:58 mysqld ended AJ I know I must have missed something obvious but if anyone could give me AJ any pointers I'd be grateful. Please, check the MySQL log file 'your_host_name.err' that is located in the MySQL datadir. Are there any causes of error? Check also your permissions on the '/var/lib/mysql' dir. AJ Andy -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 get a better understanding of how all the pieces fit together. -- sh On Fri, 2002-03-29 at 09:04, Andy Jacobs wrote: Good afternoon one and all, Well, I took the plunge and am trying to get to grips with this Linux and have fallen at the first hurdle with MySQL. When I type mysql from my shell prompt (logged in as root) I get the following message ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I've done some searching and it looks like mysqld needs starting so I ran safe_mysqld and got this: [root@Linux /root]# Starting mysqld daemon with databases from /var/lib/mysql 020329 16:49:58 mysqld ended I know I must have missed something obvious but if anyone could give me any pointers I'd be grateful. Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 2002: Can't connect to local MySQL server through socket'/tmp/mysql.sock' (2)
What would cause this error to occur all of a sudden? ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Server: Mac OS X 10.1.3 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Mike Yrabedra [EMAIL PROTECTED] http://www.macsurfshop.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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? ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Server: Mac OS X 10.1.3 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Mike Yrabedra [EMAIL PROTECTED] http://www.macsurfshop.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. --- Mike Yrabedra [EMAIL PROTECTED] wrote: What would cause this error to occur all of a sudden? ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Is the socket? It should show up in a directory listing of /tmp - if it isn't there then mysqld isn't running. Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 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 password I Nothing I do, that is listed helps. I still have no mysql.sock, and the I server never starts. I do many thinks nothing help. Then I found on my system /usr/share/doc/packages/mysql/README.SuSE. I read it and I remove the RPMs again. Restart the computer. Copy /var/lib/mysql to /backup/var/lib/mysql (or anything else). Remove all Directories and Files in /var/lib/mysql. Start yast1 and install the six RPMs (look README.SuSE). Restart the computer. And MySQL lives again. If you have a similar System, how I, I hope the same procedure will help you. Ciao Oliver Meins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error 2002 can't connect to MySQL server through socket /var/lib...
dlyles, Tuesday, March 05, 2002, 4:54:30 AM, you wrote: d This is the message I am getting. I am currently running MySQL (or trying d to) on a Cobalt Raq3. Is your MySQL server running? d I recently uninstalled and reinstalled, but am unable d to remove this message. I can't start mysql or do anything. That's the d message I keep getting. Any ideas? If your MySQL is not running, you should start mysqld. If your MySQL server is running then you should check location of the socket file and check the socket path in your my.cnf file. Check your privileges on the socket file and on the dir that contains socket file. You can find the description of this error at: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html Please also tell us, how exactly did you installed MySQL on Cobalt server as there are some specific details. Have you compiled MySQL by yourself or took a binary distribution? -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 password Nothing I do, that is listed helps. I still have no mysql.sock, and the server never starts. Mark - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 05, 2002 11:00 AM Subject: Error 2002 can't connect to MySQL server through socket /var/lib... dlyles, Tuesday, March 05, 2002, 4:54:30 AM, you wrote: d This is the message I am getting. I am currently running MySQL (or trying d to) on a Cobalt Raq3. Is your MySQL server running? d I recently uninstalled and reinstalled, but am unable d to remove this message. I can't start mysql or do anything. That's the d message I keep getting. Any ideas? If your MySQL is not running, you should start mysqld. If your MySQL server is running then you should check location of the socket file and check the socket path in your my.cnf file. Check your privileges on the socket file and on the dir that contains socket file. You can find the description of this error at: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html Please also tell us, how exactly did you installed MySQL on Cobalt server as there are some specific details. Have you compiled MySQL by yourself or took a binary distribution? -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 password I Nothing I do, that is listed helps. I still have no mysql.sock, and the I server never starts. Look at /var/lib/mysql/your_host.err file. Is there any cause of an error? I Mark I - Original Message - I From: Egor Egorov [EMAIL PROTECTED] I To: [EMAIL PROTECTED] I Sent: Tuesday, March 05, 2002 11:00 AM I Subject: Error 2002 can't connect to MySQL server through socket /var/lib... dlyles, Tuesday, March 05, 2002, 4:54:30 AM, you wrote: d This is the message I am getting. I am currently running MySQL (or I trying d to) on a Cobalt Raq3. Is your MySQL server running? d I recently uninstalled and reinstalled, but am unable d to remove this message. I can't start mysql or do anything. That's I the d message I keep getting. Any ideas? If your MySQL is not running, you should start mysqld. If your MySQL server is running then you should check location of the socket file and check the socket path in your my.cnf file. Check your privileges on the socket file and on the dir that contains socket file. You can find the description of this error at: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error 2002 can't connect to MySQL server through socket /var/lib...
This is the message I am getting. I am currently running MySQL (or trying to) on a Cobalt Raq3. I recently uninstalled and reinstalled, but am unable to remove this message. I can't start mysql or do anything. That's the message I keep getting. Any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 2002:
Hello Everyone, I ma new to mysql , i have read the online manual for installing mysql and installed it i used MySQL-3.22.32-3.i386.rpm, MySQL-client-3.22.32-3.i386.rpm and installed like this #rpm -i MySQL-3.22.32-3.i386.rpm MySQL-client-3.22.32-3.i386.rpm and after this i have given the passowrd entry as #/usr/bin/mysqladmin -u root password 'chinta' and it did not give any error till now, but when i tried this below statement chinta@linux:~ mysql -u root -p Enter Password: chinta then it gave a message like this: ERROR 2002: cant connect to local mysql server through socket '/var/lib/mysql/mysql.sock' (111) and then i went and searched for help it mentioned that we have to specify the path for the files 'mysql.sock' but my problem is i did not find files like mysql.sock, .cnf etc I am using SuSe 7.1 profesional Edition and I have installed completely alll packages.. but even then how can i miss those files Pls. let me know how to get those file...mysql.sock etc this problem is eating my mind Pls. any one help me -- Thanks Regards Chinta [ [EMAIL PROTECTED] ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 2002
Anyone can help me with this What can i do thanks a lot ! ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) -- Pablo Javier Gonzalez Mateos, [EMAIL PROTECTED] on 07/09/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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: Friday, September 07, 2001 4:10 PM To: [EMAIL PROTECTED] Subject: ERROR 2002 Anyone can help me with this What can i do thanks a lot ! ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) -- Pablo Javier Gonzalez Mateos, [EMAIL PROTECTED] on 07/09/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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?) 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 PM Subject: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' Can anyone tell me what to do about this error. I installed mysql on Redhat 7.0 with the RPM on the Redhat Cd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 2002:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' Can anyone tell me what to do about this error. I installed mysql on Redhat 7.0 with the RPM on the Redhat Cd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 socket '/var/lib/mysql/mysql.sock' Can anyone tell me what to do about this error. I installed mysql on Redhat 7.0 with the RPM on the Redhat Cd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 2002
Hi, I've installed Mysql on my Linux version 7 and i'm having problems starting the database. I'm getting this message ERROR 2002: Can't connect to local Mysql server through socket '/var/lib/mysql/mysql.sock' (111). I've tried the find this file on my system and it not there. Anybody have a clue? Thanks..
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 Hi, I've installed Mysql on my Linux version 7 and i'm having problems starting the database. I'm getting this message ERROR 2002: Can't connect to local Mysql server through socket '/var/lib/mysql/mysql.sock' (111). I've tried the find this file on my system and it not there. Anybody have a clue? Thanks.. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error 2002
Hi I have installed Mysql from the latest tar file and followed these steps. shell groupadd mysql shell useradd -g mysql mysql shell gunzip mysql-VERSION.tar.gz | tar -xvf - shell cd mysql-VERSION shell ./configure --prefix=/usr/local/mysql shell make shell make install shell scripts/mysql_install_db shell chown -R root /usr/local/mysql shell chown -R mysql /usr/local/mysql/var shell chgrp -R mysql /usr/local/mysql shell /usr/local/mysql/bin/safe_mysqld --user=mysql When I run mysql all i seem to be getting is : ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Can anyone help? Thanks Gordon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
newbie problem... (error 2002)
when i try to run phpmyadmin i got an error message and the log from mysql says: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) any idéa? i'm a total newbie :o) -- D. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: newbie problem... (error 2002)
when i try to run phpmyadmin i got an error message and the log from mysql says: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) AAARG if you would have taken the time to check the archive you would have know it has to do with the location where PHP thinks mysql.sock is. Normally it would live in /tmp Change your php.ini to match this. 2th option: mysqld isn't running. To find out: ps -ax If it's not running start it.. check the manual for more info. If you can't find it in the MYSQL lists archive, check the archives at www.php.net this has been answered at least 75 times.. Even a newbie can check the archive :-) Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query: Error 2002 Can't connect to local mysql server.
Dear Sir, We are trying to install and configure mysql version .23.32 on Linux Red Hat 7. Usinf the configure option ./configure --prefix=/usr/local --localstatedir=/usr/local/mysql/data --with-unix-socket-path=/usr.local/mysql/tmp/mysql.sock the make and make install. we have tried several variations of the configure options. no error is shown during compilation and installation. On executing mysql from root there is an error sayin Can't connect to local MySql server. through var/lib/mysql/mysql.sock. We have tried with changed socket path in configure option giving the above path. But we do'nt find the sock file in any of the directory. Plese help us to resolve this problem. We have already installed apache and PHP4 in our system with success. Akshaya - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query: Error 2002 Can't connect to local mysql server.
First try to find out where you socket is located:
# lsof -p {$PID_OF_MYSQL] |grep unix
mysqld 1277 root 4u unix 0xcb596580 1712 /var/lib/mysql/mysql.sock
And then point to this file in mysql conf file:
# more /etc/my.cnf
[client]
socket=/var/lib/mysql/mysql.sock
[mysqld]
socket=/var/lib/mysql/mysql.sock
(this config should startup mysqld with default socket to /var/lib/...)
Regards, Erik
On Fri, 23 Mar 2001, Foresight Systems Ltd. wrote:
Dear Sir,
We are trying to install and configure mysql version .23.32 on Linux Red
Hat 7.
Usinf the configure option
./configure --prefix=/usr/local --localstatedir=/usr/local/mysql/data
--with-unix-socket-path=/usr.local/mysql/tmp/mysql.sock
the make and make install.
we have tried several variations of the configure options.
no error is shown during compilation and installation.
On executing mysql from root
there is an error
sayin Can't connect to local MySql server. through
var/lib/mysql/mysql.sock.
We have tried with changed socket path in configure option giving the
above path.
But we do'nt find the sock file in any of the directory.
Plese help us to resolve this problem.
We have already installed apache and PHP4 in our system with success.
Akshaya
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
===
= Erik Ahlstrm, [EMAIL PROTECTED]
Systems Engineer, ProAct Datasystem AB
Vx: +46 8 4106 6600 Ph: +46 8 4106 6621
Fx: +46 8 623 18 56 Mob:+46 73 356 6621
Lin*x, *BSD, Solaris
===
Unix IS user friendly.
It's just selective about who its friends are.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query: Error 2002 Can't connect to local mysql server.
Did you follow the rest of the instructions? Did you create the mysql user? Did you run mysql_install_db --user=mysql ? Did you start the server ? "Foresight Systems Ltd." wrote: Dear Sir, We are trying to install and configure mysql version .23.32 on Linux Red Hat 7. Usinf the configure option ./configure --prefix=/usr/local --localstatedir=/usr/local/mysql/data --with-unix-socket-path=/usr.local/mysql/tmp/mysql.sock the make and make install. we have tried several variations of the configure options. no error is shown during compilation and installation. On executing mysql from root there is an error sayin Can't connect to local MySql server. through var/lib/mysql/mysql.sock. We have tried with changed socket path in configure option giving the above path. But we do'nt find the sock file in any of the directory. Plese help us to resolve this problem. We have already installed apache and PHP4 in our system with success. Akshaya - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
