Re: Err 2002 socks suck noway to start
Thansk for your suggestion Steve, see what I have. I don't know why by default server wants a sock in /var/lib/mysql and why it doesnt exists anymore ? How to create a new one ? A search [EMAIL PROTECTED] [~]# find / -name mysql.sock /var/tmp/mysql.sock /tmp/mysql.sock /usr/local/lib/mysql.sock I try to force sock in tmp dir [EMAIL PROTECTED] [~]# tail /etc/my.cnf [client] socket=/tmp/mysql.sock [mysqld] set-variable = max_connections=500 socket=/tmp/mysql.sock [EMAIL PROTECTED] [~]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) [EMAIL PROTECTED] [~]# tail ~/.my.cnf [client] user=root pass=** [mysqladmin] password=** user=root and now # is a comment, without any directive [EMAIL PROTECTED] [~]# tail /etc/my.cnf #[client] #socket=/tmp/mysql.sock [mysqld] set-variable = max_connections=500 #socket=/tmp/mysql.sock [EMAIL PROTECTED] [~]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) You advise me to test the other socks ? Thanks --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 31/05/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Err 2002 socks suck noway to start
Noway :( [EMAIL PROTECTED] [/etc]# vi my.cnf [EMAIL PROTECTED] [/etc]# service mysql start [EMAIL PROTECTED] [/etc]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/usr/local/lib/mysql.sock' (2) [EMAIL PROTECTED] [/etc]# vi my.cnf [EMAIL PROTECTED] [/etc]# service mysql start [EMAIL PROTECTED] [/etc]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/tmp/mysql.sock' (2) Thanks --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 31/05/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Err 2002 socks suck noway to start
[EMAIL PROTECTED] [/tmp]# locate mysql.server /usr/share/mysql/mysql.server [EMAIL PROTECTED] [/tmp]# /usr/share/mysql/mysql.server start [EMAIL PROTECTED] [/tmp]# it seems nothing ... should I have to see in some log file ? Thanks. - Original Message - # locate mysql.server # /path/to/mysql.server start what error it gives ? Peter Zyumbilev --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 01/06/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Err 2002 socks suck noway to start
Hi, I am on a redhat, i read a lot of doc on the problem I hav but noway to advance, mysql won't start and won't tell anything : [EMAIL PROTECTED] [~]# service mysql start [EMAIL PROTECTED] [~]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) [EMAIL PROTECTED] [~]# ls -ls /tmp total 48 8 drwxrwxrwt3 root root 8192 Jun 5 11:55 ./ 4 drwxr-xr-x 20 root root 4096 Jun 5 11:01 ../ 4 drwxrwxrwx2 bin bin 4096 Jun 5 11:02 .iroha_unix/ 0 srwxrwxrwx1 mysqlmysql 0 Jun 5 11:55 mysql.sock= ... [EMAIL PROTECTED] [/tmp]# rpm -qa | grep MySQL MySQL-server-4.0.18-0 perl-DBD-MySQL-2.1021-3 MySQL-client-4.0.18-0 MySQL-embedded-4.0.18-0 MySQL-devel-4.0.18-0 MySQL-shared-4.0.18-0 Thanks. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 31/05/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Err 2002 socks suck noway to start
At 19:21 +0200 6/5/04, pourave wrote: Hi, I am on a redhat, i read a lot of doc on the problem I hav but noway to advance, mysql won't start and won't tell anything : mysql is a client program. The server is named mysqld. I know under redhat a script call service is used to start mysql service : #service mysql start same as # /etc/rc.d/init.d/mysql start Nothing : [EMAIL PROTECTED] [/var/log]# ps auxw | grep mysql root 6212 0.0 0.1 3776 568 pts/0S12:59 0:00 grep mysql Mysql used to start automaticaly [EMAIL PROTECTED] [/var/log]# /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/leya .pid /dev/null 21 [1] 6301 [EMAIL PROTECTED] [/var/log]# ps auxw | grep mysql root 6335 0.0 0.1 3776 568 pts/0S13:02 0:00 grep mysql [1]+ Done /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/leya .pid /dev/null 21 and been stopped :( --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 31/05/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Err 2002 socks suck noway to start
Okay. What does the MySQL error log say. Anything? Do you know where can I find it ? Dates are old 031222 ! ... [EMAIL PROTECTED] [/var/log]# tail mysqld.log /usr/sbin/mysqld: ready for connections. Version: '4.0.15-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 031222 12:57:02 /usr/sbin/mysqld: Normal shutdown 031222 12:57:02 InnoDB: Starting shutdown... 031222 12:57:04 InnoDB: Shutdown completed 031222 12:57:04 /usr/sbin/mysqld: Shutdown Complete 031222 12:57:04 mysqld ended [EMAIL PROTECTED] [/var/log]# head mysqld.log 031202 22:05:39 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 031202 22:05:39 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 031202 22:05:39 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 031202 22:05:40 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB [EMAIL PROTECTED] [/var/log]# Thanks. David D --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 31/05/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]