localhost okay, all else not okay

[tdbtdb]

When I access mysql through localhost it works. When I use my IP number
is does not. What should this tell me? networking config? firewall?
hosts.allow? Googling on the error message leads nowhere.

for example:

root@0[mysql]# mysql --socket=/var/lib/mysql/mysql.sock -p -u root
--host=localhost
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13 to server version: 4.0.24_Debian-10

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> exit
Bye
root@0[mysql]# mysql --socket=/var/lib/mysql/mysql.sock -p -u root
--host=128.171.156.130
Enter password:
ERROR 2013: Lost connection to MySQL server during query
So socket works, port doesn't. What should that tell me?

[Bill Karwin]

td****@gmail.com wrote:

So socket works, port doesn't. What should that tell me?

Was mysqld started with "--skip-networking"?

Regards,
Bill K.

[jim]

td****@gmail.com wrote:

When I access mysql through localhost it works. When I use my IP number
is does not. What should this tell me? networking config? firewall?
hosts.allow? Googling on the error message leads nowhere.

My reading suggests that MySQL will only let you connect as root on the
local machine. For remote connections you may have to log in as
another user.