Привет. Столкнулся с проблемой MYSQL. Уже перепробовал все. Google результатов не дал.
Отписался на форуме MYSQL, http://forums.mysql.com/read.php?11,265041,265041#msg-265041
Проблема при подключении к MySQL:
mysql -uroot --host 127.0.0.1 -P3306 -p
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0
НО
mysql -uroot --host localhost -P3306 -p
Ошибок не выдает и подключиться удается.
-------------------------------------------------------
iptables -F
-------------------------------------------------------
# cat /etc/mysql/my.cnf
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
bind-address = 0.0.0.0
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8
myisam-recover = BACKUP
query_cache_limit = 1M
query_cache_size = 16M
expire_logs_days = 10
max_binlog_size = 100M
skip-bdb
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
[isamchk]
key_buffer = 16M
!includedir /etc/mysql/conf.d/
-----------------------------------------------------
#cat /etc/hosts.deny
portmap:ALL
lockd:ALL
mountd:ALL
rquotad:ALL
statd:ALL
-----------------------------------------------------
# cat /etc/hosts
127.0.0.1 localhost
-----------------------------------------------------