# MySQL Configuration for Remote Connections # Add these settings to your my.cnf (Linux/Mac) or my.ini (Windows) file [mysqld] # Allow connections from any IP (change to specific IP for security) bind-address = 0.0.0.0 # Or bind to specific interface # bind-address = 192.168.29.101 # Increase connection timeouts wait_timeout = 600 interactive_timeout = 600 connect_timeout = 60 # Increase packet size (helps with "server has gone away") max_allowed_packet = 64M # Connection limits max_connections = 200 max_connect_errors = 1000 # Network timeouts net_read_timeout = 120 net_write_timeout = 120 # Skip name resolution for faster connections skip-name-resolve # Port configuration port = 3309