469,936 Members | 2,361 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,936 developers. It's quick & easy.

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?

Apr 5 '06 #1
2 1338
td****@gmail.com wrote:
So socket works, port doesn't. What should that tell me?


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

Regards,
Bill K.
Apr 6 '06 #2
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.

Apr 7 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

20 posts views Thread by =?Utf-8?B?cmtibmFpcg==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.