So I have a master and a slave in a mysql cluster, the syntonization works as it should however I am not able to connect to the slave from any host except from the server it self.
I have no problems connection to the master, but now I need to spread the load of read queries to the slave and this problem appears.
I have used GRANT with % as host to ensure that it's just not a typo. But now I'm stuck and can't seem to find a solution.
Using working credentials on the master resolves in a ERROR 1103 on the slave: ERROR 1130 (HY000): Host 'host' is not allowed to connect to this MySQL server
workBook:~ gonace$ mysql --no-defaults -h10.0.5.101 -uroot -p
Enter password:
ERROR 1130 (HY000): Host '10.0.2.13' is not allowed to connect to this MySQL server
Thanks in advance
user.MYD
,user.MYI
anduser.frm
files from master to the slave. Sure you have to backup old files on the slave. Then start both servers. That is not a solution but you can login at slave at least.