List:General Discussion« Previous MessageNext Message »
From:xPol Date:April 2 2011 3:36pm
Subject:Re: Can't connect to MySQL server on '127.0.0.1' (111)
View as plain text  
Reindl Harald wrote:

> Did you make any change in the my.cnf?
> What does "netstat --numeric-hosts --notrim --programs -u -t" say?
> What is the content of your my.cnf?
> 

Here incluede

thank you 
----p

--
(xpol) % netstat --numeric-hosts --notrim --programs -u -t                               
~ (17:32-Sat  2) 
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
Active Internet connections (w/o servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       
PID/Program name   
tcp        0      0 10.121.243.241:38315    74.125.77.109:smtp      
TIME_WAIT   -                   
tcp        0      0 127.0.0.1:50793         127.0.0.1:48856         
ESTABLISHED 6752/npviewer.bin   
tcp        0      0 127.0.0.1:57336         127.0.0.1:48856         
ESTABLISHED 6752/npviewer.bin   
tcp        0      0 10.121.243.241:53924    74.125.232.152:https    
ESTABLISHED 6252/firefox        
tcp        0      0 10.121.243.241:53925    74.125.232.152:https    
ESTABLISHED 6252/firefox        
tcp        0      0 10.121.243.241:53894    74.125.232.152:https    
ESTABLISHED 6252/firefox        
tcp        0      0 10.121.243.241:35673    209.85.227.189:https    
ESTABLISHED 6252/firefox        
tcp        0      0 10.121.243.241:35672    209.85.227.189:https    
ESTABLISHED 6252/firefox        
tcp        0      0 10.121.243.241:48554    209.85.149.105:www-http 
ESTABLISHED 6252/firefox        
tcp        0      0 10.121.243.241:35666    209.85.227.189:https    
TIME_WAIT   -                   
tcp        0      0 10.121.243.241:35667    209.85.227.189:https    
TIME_WAIT   -                   
tcp        0      0 10.121.243.241:53926    74.125.232.152:https    
ESTABLISHED 6252/firefox        
tcp        0      0 127.0.0.1:52722         127.0.0.1:48856         
ESTABLISHED 6752/npviewer.bin   
tcp        0      0 127.0.0.1:48856         127.0.0.1:52722         
ESTABLISHED 6767/GoogleTalkPlug 
tcp        0      0 127.0.0.1:48856         127.0.0.1:50793         
ESTABLISHED 6767/GoogleTalkPlug 
tcp        0      0 127.0.0.1:48856         127.0.0.1:57336         
ESTABLISHED 6767/GoogleTalkPlug 
tcp        0      0 10.121.243.241:54324    80.91.229.10:nntp       
ESTABLISHED 11402/knodeo10783.s 

---
(xpol) % cat /mnt/etc/my.cnf | grep -v "^#"                                           
~ (17:34-Sat  2) 

[client]
port            = 3306
socket          = /var/run/mysql/mysql.sock


[mysqld]
port            = 3306
socket          = /var/run/mysql/mysql.sock
datadir = /var/lib/mysql
skip-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M


log-bin=mysql-bin

binlog_format=mixed

server-id       = 1




[safe_mysqld]
log-error       = /var/log/mysql/mysqld.log
socket          = /var/run/mysql/mysql.sock

!include_dir /etc/mysql

[mysqldump]
socket          = /var/run/mysql/mysql.sock
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

[mysqld_multi]
mysqld     = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
log        = /var/log/mysqld_multi.log






-----

Thread
Can't connect to MySQL server on '127.0.0.1' (111)xPol2 Apr
  • Re: Can't connect to MySQL server on '127.0.0.1' (111)Reindl Harald2 Apr
  • Re: Can't connect to MySQL server on '127.0.0.1' (111)Andrew Moore2 Apr
  • Re: Can't connect to MySQL server on '127.0.0.1' (111)xPol2 Apr
  • Re: Can't connect to MySQL server on '127.0.0.1' (111)xPol2 Apr
    • Re: Can't connect to MySQL server on '127.0.0.1' (111)Reindl Harald2 Apr
  • Re: Can't connect to MySQL server on '127.0.0.1' (111)xPol2 Apr
    • Re: Can't connect to MySQL server on '127.0.0.1' (111)Reindl Harald2 Apr
  • Re: Can't connect to MySQL server on '127.0.0.1' (111)xPol2 Apr