List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:April 2 2011 3:51pm
Subject:Re: Can't connect to MySQL server on '127.0.0.1' (111)
View as plain text  
please do not only post outputs, read them and try to understand
before press send - "not all processes could be identified, non-owned process
info will not be shown, you would have to be root to see it all." in
the ouptput says that all afterwards is useless

"netstat --numeric-hosts --notrim --programs -u -t -l" as ROOT on the machine
where mysql is running! alterante: "telnet 127.0.0.1 3306"

"/mnt/etc/my.cnf" is really your active mysql-config?
normally "/etc/my.cnf" is used, even if /etc/ is a own
disk/partition you should never mount it as /mnt/etc/
and managing with symlinks - mount it directly to /etc

i would assume something like "skip-networking" in your
config if connection fails

anyways this mysql-config ma contain some includes
because the line "!include_dir /etc/mysql"

Am 02.04.2011 17:36, schrieb xPol:
> 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
> 
> 
> 
> 
> 
> 
> -----
> 
> 

-- 

Mit besten Grüßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
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