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/
signature.asc
Description: OpenPGP digital signature
