当前位置：刘世明的博客 > mysql > 正文

mysql telnet 3306 connection refused解决办法

2020-03-27 分类：mysql / problem-solved / troubleshoot 阅读(5026) 评论(2)

问题描述

mysql看起来在公网提供服务

$ netstat -tulpn | grep mysqld
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      4381/mysqld

telnet 127.0.0.1 3306可以通

但是telnet 公网ip 3306 报connection refused

解决办法

修改bind-address

vi /etc/mysql/mysql.conf.d/mysqld.cnf

将bind-address改为0.0.0.0

重启mysql

systemctl restart mysql

赞(6) 打赏

欢迎转载，注明出处：刘世明的博客 » mysql telnet 3306 connection refused解决办法

标签：mysql telnet

相关推荐

评论 2

#1
Hi,

I was looking at your website and noticed something interesting.

Most businesses are losing potential customers because they are not actively managing their online reviews.

Reviews can significantly increase trust and conversions when handled properly.

I recently found a tool that automatically collects, manages, and improves online reviews for businesses.

You can see how it works here:

https://jvz3.com/c/688203/434579/

It’s surprisingly simple and can make a big difference in attracting new customers.

Oj James3天前回复
#2
Hi,

I just visited liushiming.cn and wondered if you’d ever thought about having an engaging video to explain what you do?

Our videos cost just $195 (USD) for a 30 second video ($239 for 60 seconds) and include a full script, voice-over and video.

I can show you some previous videos we’ve done if you want me to send some over. Let me know if you’re interested in seeing samples of our previous work.

Regards,
Joanna

Unsubscribe: https://unsubscribe.video/unsubscribe.php?d=liushiming.cn

Joanna Riggs3天前回复