Connect to remote MariaDB host (error 1130)

797 views Asked by At

Replication from MariaDB (master) to MySQL 5.6 (slave)

When I try to connect to remote MariaDB host on slave server, I get this error:

ERROR 1130 (HY000): Host '[slave server ip]' is not allowed to connect to this MariaDB server

What's wrong?

1

There are 1 answers

0
henry wong On

I've solved the problem. The slave server ip address is wrong! It's ridiculous, the slave server has another ip address, and I have to grant database user for the other one.