Databases Reference
In-Depth Information
After clicking on
Go
, phpMyAdmin takes care of creating this user with the correct
permissions set.
Slave server configuration
Now, on the machine that will act as a slave server in the replication process,
we start phpMyAdmin. In the
Replication
menu, we click on
configure
in the
following dialog:
The slave server configuration panel appears, as shown in the following screenshot:
As with the master configuration, we get a suggestion about having a unique server
ID in the configuration file for the slave, and we should follow this advice.
In this panel, we enter the username and password of the dedicated replication
account we created on the master. We also have to indicate the hostname and port
number corresponding to the master server. After filling this panel and clicking on
Go
, phpMyAdmin sends the appropriate
CHANGE MASTER
command to the slave,
which puts this server in slave mode.
Search WWH ::
Custom Search