MySQL is failing to connect

view full story

http://serverfault.com – I am building two mysql machines in master-slave config. Master has: mysql> create user 'repl'@'%.%.%.abc.mydomain.com' identified by 'mypassword'; mysql> grant replication slave on *.* to 'repl'@'%.%.%.abc.mydomian.com'; So basically anything like my.sql.slave.abc.mydomian.com should be able to connect but on slave if I try: shell> mysql -h my.sql.master.abc.mydomain.com -urepl -pmypassword it says: ERROR 1130 (HY000): Host '' is not allowed to connect to this MySQL server I think this is happening because %.%.%.abc.mydomian.com is allowed to connect and not 10.10 (HowTos)