Penso di aver configurato tutto bene per la replicazione (anche perchè non è la prima volta che configuro così mysql e non mi ha mai dato problemi), però quando vado a fare load data from master ricevo questo errore:

ERROR 1218 (08S01): Error connecting to master: Lost connection to MySQL server at 'reading initial communication packet', system error: 111

vi posto le due configurazioni:

master (192.168.1.149)
<br />#<br /># The MySQL database server configuration file.<br />#<br /># You can copy this to one of:<br /># - &quot;/etc/mysql/my.cnf&quot; to set global options,<br /># - &quot;~/.my.cnf&quot; to set user-specific options.<br /># <br /># One can use all long options that the program supports.<br /># Run program with --help to get a list of available options and with<br /># --print-defaults to see which it would actually understand and use.<br />#<br /># For explanations see<br /># http://dev.mysql.com/doc/mysql/en/server-system-variables.html<br /><br /># This will be passed to all mysql clients<br /># It has been reported that passwords should be enclosed with ticks/quotes<br /># escpecially if they contain &quot;#&quot; chars...<br /># Remember to edit /etc/mysql/debian.cnf when changing the socket location.<br />[client]<br />port            = 3306<br />socket          = /var/run/mysqld/mysqld.sock<br /><br /># Here is entries for some specific programs<br /># The following values assume you have at least 32M ram<br /><br /># This was formally known as [safe_mysqld]. Both versions are currently parsed.<br />[mysqld_safe]<br />socket          = /var/run/mysqld/mysqld.sock<br />nice            = 0<br /><br />[mysqld]<br />#<br /># * Basic Settings<br />#<br />user            = mysql<br />pid-file        = /var/run/mysqld/mysqld.pid<br />socket          = /var/run/mysqld/mysqld.sock<br />port            = 3306<br />basedir         = /usr<br />datadir         = /var/lib/mysql<br />tmpdir          = /tmp<br />language        = /usr/share/mysql/italian<br />skip-external-locking<br />#<br /># Instead of skip-networking the default is now to listen only on<br /># localhost which is more compatible and is not less secure.<br />bind-address            = 127.0.0.1 192.168.1.144<br />#<br /># * Fine Tuning<br />#<br />key_buffer              = 16M<br />max_allowed_packet      = 16M<br />thread_stack            = 128K<br />thread_cache_size       = 8<br />#max_connections        = 100<br />#table_cache            = 64<br />#thread_concurrency     = 10<br />#<br /># * Query Cache Configuration<br />#<br />query_cache_limit       = 1M<br />query_cache_size        = 16M<br />#<br /># * Logging and Replication<br />#<br /># Both location gets rotated by the cronjob.<br /># Be aware that this log type is a performance killer.<br />#log            = /var/log/mysql/mysql.log<br />#<br /># Error logging goes to syslog. This is a Debian improvement :)<br />#<br /># Here you can see queries with especially long duration<br />#log_slow_queries       = /var/log/mysql/mysql-slow.log<br />#long_query_time = 2<br />#log-queries-not-using-indexes<br />#<br /># The following can be used as easy to replay backup logs or for replication.<br />server-id               = 1<br />log_bin                 = /var/log/mysql/mysql-bin.log<br /># WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian!<br />expire_logs_days        = 10<br />max_binlog_size         = 1000M<br />binlog_do_db            =  my_db<br />#binlog_ignore_db       = include_database_name<br />#<br /># * BerkeleyDB<br />#<br /># Using BerkeleyDB is now discouraged as its support will cease in 5.1.12.<br />skip-bdb<br />#<br /># * InnoDB<br />#<br /># InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.<br /># Read the manual for more InnoDB related options. There are many!<br /># You might want to disable InnoDB to shrink the mysqld process by circa 100MB.<br />#skip-innodb<br />#<br /># * Security Features<br />#<br /># Read the manual, too, if you want chroot!<br /># chroot = /var/lib/mysql/<br />#<br /># For generating SSL certificates I recommend the OpenSSL GUI &quot;tinyca&quot;.<br />#<br /># ssl-ca=/etc/mysql/cacert.pem<br /># ssl-cert=/etc/mysql/server-cert.pem<br /># ssl-key=/etc/mysql/server-key.pem<br /><br />character-set-server = utf8<br />default-character-set = utf8<br /><br />[mysqldump]<br />quick<br />quote-names<br />max_allowed_packet      = 16M<br />default-character-set = utf8<br /><br />[mysql]<br />#no-auto-rehash # faster start of mysql but no tab completition<br />character-sets-dir=/usr/share/mysql/charsets<br />default-character-set=utf8<br /><br />[isamchk]<br />key_buffer              = 16M<br /><br />#<br /># * NDB Cluster<br />#<br /># See /usr/share/doc/mysql-server-*/README.Debian for more information.<br />#<br /># The following configuration is read by the NDB Data Nodes (ndbd processes)<br /># not from the NDB Management Nodes (ndb_mgmd processes).<br />#<br /># [MYSQL_CLUSTER]<br /># ndb-connectstring=127.0.0.1<br /><br /><br />#<br /># * IMPORTANT: Additional settings that can override those from this file!<br />#<br />!includedir /etc/mysql/conf.d/<br />

poi ho dato su mysql:
GRANT SUPER,REPLICATION CLIENT,REPLICATION SLAVE,RELOAD ON *.* to replicatore@192.168.1.144 identified by 'password';

slave (192.168.1.144)
<br />#<br /># The MySQL database server configuration file.<br />#<br /># You can copy this to one of:<br /># - &quot;/etc/mysql/my.cnf&quot; to set global options,<br /># - &quot;~/.my.cnf&quot; to set user-specific options.<br /># <br /># One can use all long options that the program supports.<br /># Run program with --help to get a list of available options and with<br /># --print-defaults to see which it would actually understand and use.<br />#<br /># For explanations see<br /># http://dev.mysql.com/doc/mysql/en/server-system-variables.html<br /><br /># This will be passed to all mysql clients<br /># It has been reported that passwords should be enclosed with ticks/quotes<br /># escpecially if they contain &quot;#&quot; chars...<br /># Remember to edit /etc/mysql/debian.cnf when changing the socket location.<br />[client]<br />port            = 3306<br />socket          = /var/run/mysqld/mysqld.sock<br /><br /># Here is entries for some specific programs<br /># The following values assume you have at least 32M ram<br /><br /># This was formally known as [safe_mysqld]. Both versions are currently parsed.<br />[mysqld_safe]<br />socket          = /var/run/mysqld/mysqld.sock<br />nice            = 0<br /><br />[mysqld]<br />#<br /># * Basic Settings<br />#<br />user            = mysql<br />pid-file        = /var/run/mysqld/mysqld.pid<br />socket          = /var/run/mysqld/mysqld.sock<br />port            = 3306<br />basedir         = /usr<br />datadir         = /var/lib/mysql<br />tmpdir          = /tmp<br />language        = /usr/share/mysql/english<br />skip-external-locking<br />#<br /># Instead of skip-networking the default is now to listen only on<br /># localhost which is more compatible and is not less secure.<br />bind-address            = 127.0.0.1 192.168.1.149<br />#<br /># * Fine Tuning<br />#<br />key_buffer              = 16M<br />max_allowed_packet      = 16M<br />thread_stack            = 128K<br />thread_cache_size       = 8<br />#max_connections        = 100<br />#table_cache            = 64<br />#thread_concurrency     = 10<br />#<br /># * Query Cache Configuration<br />#<br />query_cache_limit       = 1M<br />query_cache_size        = 16M<br />#<br /># * Logging and Replication<br />#<br /># Both location gets rotated by the cronjob.<br /># Be aware that this log type is a performance killer.<br />#log            = /var/log/mysql/mysql.log<br />#<br /># Error logging goes to syslog. This is a Debian improvement :)<br />#<br /># Here you can see queries with especially long duration<br />#log_slow_queries       = /var/log/mysql/mysql-slow.log<br />#long_query_time = 2<br />#log-queries-not-using-indexes<br />#<br /># The following can be used as easy to replay backup logs or for replication.<br />server-id               = 2<br />log_bin                 = /var/log/mysql/mysql-bin.log<br /># WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian!<br />master-host             = 192.168.1.149<br />report-host             = 192.168.1.144<br />master-user             = replicatore<br />master-password         =  password<br />replicate-do-db         =  my_db<br />master-connect-retry    = 60<br />log-warnings<br /><br />expire_logs_days        = 10<br />max_binlog_size         = 1000M<br />#binlog_do_db           = include_database_name<br />#binlog_ignore_db       = include_database_name<br />#<br /># * BerkeleyDB<br />#<br /># Using BerkeleyDB is now discouraged as its support will cease in 5.1.12.<br />skip-bdb<br />#<br /># * InnoDB<br />#<br /># InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.<br /># Read the manual for more InnoDB related options. There are many!<br /># You might want to disable InnoDB to shrink the mysqld process by circa 100MB.<br />#skip-innodb<br />#<br /># * Security Features<br />#<br /># Read the manual, too, if you want chroot!<br /># chroot = /var/lib/mysql/<br />#<br /># For generating SSL certificates I recommend the OpenSSL GUI &quot;tinyca&quot;.<br />#<br /># ssl-ca=/etc/mysql/cacert.pem<br /># ssl-cert=/etc/mysql/server-cert.pem<br /># ssl-key=/etc/mysql/server-key.pem<br />character-set-server            = utf8<br />default-character-set           = utf8<br /><br /><br />[mysqldump]<br />quick<br />quote-names<br />max_allowed_packet      = 16M<br />character-sets-dir=/usr/share/mysql/charsets<br />default-character-set=utf8<br /><br />[mysql]<br />#no-auto-rehash # faster start of mysql but no tab completition<br />character-sets-dir=/usr/share/mysql/charsets<br />default-character-set=utf8<br /><br />[isamchk]<br />key_buffer              = 16M<br /><br />#<br /># * NDB Cluster<br />#<br /># See /usr/share/doc/mysql-server-*/README.Debian for more information.<br />#<br /># The following configuration is read by the NDB Data Nodes (ndbd processes)<br /># not from the NDB Management Nodes (ndb_mgmd processes).<br />#<br /># [MYSQL_CLUSTER]<br /># ndb-connectstring=127.0.0.1<br /><br /><br />#<br /># * IMPORTANT: Additional settings that can override those from this file!<br />#<br />!includedir /etc/mysql/conf.d/<br /><br />

oltretutto non trovo nemmeno un log che mi possa aiutare