running ISPConfig on wheeze trying to follow How To Set Up Database Replication In MySQL by falko After adding server-id=2 master-host=xxx.168.0.100 master-user=slave_user master-password=secret master-connect-retry=60 replicate-do-db=AAL Mysql will not restart, Is there something I need to do to let the salve have access to the database through the net address I did comment out #bind-address = 127.0.0.1 during setup of ISPConfig and there was no the line #skip-networking on the master server. I also double checked the created user and password for 'slave_user"
I have never tried this, but in a multiserver environment you typically communicate through cli and need to configure a master and slave in the control panel for it to work properly.
IIRC this tutorial is for an older mysql-version. With newer version you can not set slave-data in my.cnf. Login to your mysql and enter Code: CHANGE MASTER TO MASTER_HOST='master', MASTER_USER='slave_user00', MASTER_PASSWORD='some_password';
Thanks Tried a couple of things as were suggested but Think I will look for other solutions. Thanks for your responses
