“` bindaddress = 127.0.0.1 “` 如果该行被注释掉(以#开头),请取消注释并修改为: “` bindaddress = 0.0.0.0 “` 保存文件并重启MySQL服务。 4、检查网络连接 确保客户端和MySQL服务器之间的网络连接正常,可以尝试使用ping命令测试网络连通性。 5、检查MySQL用户权限 确保客户端使用的MySQL用户具有足够的权限...
server-id=1 #bind-address = 91.121.239.234 #bind-address = 0.0.0.0 key_buffer = 16M max_allowed_packet = 16M thread_stack = 192K thread_cache_size = 8 myisam-recover = BACKUP query_cache_limit = 1M query_cache_size = 16M log_slow_queries = /var/log/mysql/mysql-slow.log ...
The "bind-address" line says that when the server binds to a socket and listens on it, it will only access networking connections from clients that connect to it on that IP address. This is not what I wanted because "127.0.0.1" is the IP address for "localhost". This configuration will...
100416 20:31:14 [ERROR] Can't start server : Bind on unix socket: No such file or directory 100416 20:31:14 [ERROR] Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ? 100416 20:31:14 [ERROR] Aborting ...
120713 23:22:21 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address 120713 23:22:21 [ERROR] Do you already have another mysqld server running on port: 3306 ? 120713 23:22:21 [ERROR] Aborting 120713 23:22:21 InnoDB: Starting shutdown... ...