大网数据广告活动
服务器运维问答

MariaDB is not listening on port 3306

· 52CE 我爱测

I have MariaDB server running on Debian 9. Problem is that if I run netstat -anp | grep 3306 nothing shows, but MariaDB server is running, I can connect to it via mysql command. MariaDB config: bind-address = 0.0.0.0 port = 3306 …

问题原文

原帖链接 · tomsk · CC BY-SA 3.0

I have MariaDB server running on Debian 9. Problem is that if I run netstat -anp | grep 3306 nothing shows, but MariaDB server is running, I can connect to it via mysql command.

MariaDB config:

bind-address = 0.0.0.0
port = 3306
skip-networking

已采纳解答

原帖链接 · Gerald Schneider · CC BY-SA 3.0

mysql by default connects via unix sockets when localhost is used as the server.

If you want your server to be available via TCP/IP you need to remove the skip-networking directive from your config (and restart the service).

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2018-02-21)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 3.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。