I have a cloud based application in PHP with one master server and multiple slaves. All servers are using master's database (mysql).
I already done this steps
CREATE USER 'mysql'@'%' IDENTIFIED BY 'my_secret_password'; GRANT ALL PRIVILEGES ON *.* TO 'mysql'@'%';
Also I commented "skip-external-locking" and "bind-address" from my.cnf
The connection from my Mac works and it also works from each slave server. On the master server I'm using the same config as on the slave servers, but it doesn't work.
Host: master.myapp.com Port: 9999 User: mysql