've ben connecting to the mysql database on my readynas pro 6 and up until now it's been fine.
Error I get is:
08:04:54 T:7172 ERROR: Unable to open database: MyMusic32 [2013](Lost connection to MySQL server at 'waiting for initial communication packet', system error: 2)
My.cnf is:
[client] port = 3306 socket = /var/run/mysqld/mysqld.sock
[mysqld] # # * Basic Settings # user = admin pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking ###skip-name-resolve # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. # bind-address = 127.0.0.1 #bind-address = 192.168.10.238 #bind-address = 0.0.0.0 ###skip-networking innodb_buffer_pool_size = 6M key_buffer_size = 16k myisam_sort_buffer_size = 16k max_connection = 50 #was 20 # # * Fine Tuning # key_buffer = 16k max_allowed_packet = 16M thread_stack = 128K # # * Query Cache Configuration #
# # * Logging and Replication # # Both location gets rotated by the cronjob. # Be aware that this log type is a performance killer. #log = /var/log/mysql.log #log = /var/log/mysql/mysql.log # # The following can be used as easy to replay backup logs or for replication. #server-id = 1 #log-bin = /var/log/mysql/mysql-bin.log # See /etc/mysql/debian-log-rotate.conf for the number of files kept. max_binlog_size = 16384 #binlog-do-db = include_database_name #binlog-ignore-db = include_database_name skip-bdb # # * InnoDB #
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. # Read the manual for more InnoDB related options. There are many!
