localhost okay, all else not okay

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?

Re: localhost okay, all else not okay

tdbtdb@gmail.com wrote:
> So socket works, port doesn't. What should that tell me?

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

Regards,
Bill K.

Re: localhost okay, all else not okay

tdbtdb@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.