Mysql.sock and remote access

Hello!

I am writing in order to get help about my problem with mysql server (on debian). Everything works well when server is "local only", but when I try to make it remote accessable i get some problems...
When I change "bind-address" in /etc/mysql/my.cnf to '*' or '%' (or any valid IP address like my own) i get following errors:

Code:

/etc/init.d/mysql[5801]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
/etc/init.d/mysql[5801]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
/etc/init.d/mysql[5801]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
/etc/init.d/mysql[5801]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

/var/run/mysqld folder is empty

Thanks for any replies,
Samik

 

Can you post your /etc/mysql/my.cnf?

What's the output of

Code:

netstat -tap

?

 

I'm using 3305 port instead of 3306 because i had some problems with it.

It says nothing about 3306, 3305 ports or mysql.

 

Can you completely comment out the bind-address line and restart MySQL?

 

Yeah, It works!

Thanks!