I am trying to set up replication across 2 raspberry Pi's, MYSQL master and slave. I have had this set up working before. The problem I get is that the slave IO thread constantly says 'Connecting' and then does not connect. The Slave SQL is running.
I have unique server ID in the my.cnf files, I have deleted all log files in the /var/log/mysql folders and restarted mysql. I have the correct user on the master, the correct IP address for the Master, basically, I have set this up by the book. My error log is giving me a code 2003, network error, but I can ping, VNC, SSH and use PhpMyAdmin on the master. All work perfectly. I can even log in using PhpMyAdmin on the master from the slave Pi. I have used Netsat to check port 3306. All ok.
Is this a bug? I have been trying everything on Google for 3 days. I'm out of ideas.