Databases Reference
In-Depth Information
We could add other database names to the list by using Ctrl + Click or Command +
Click, depending on our workstation's OS. However, all that phpMyAdmin does
is to generate correct lines; to make them operational, we still need to follow the
given advice and paste these lines at the end of the [mysqld] section of our MySQL
configuration file. We should then restart the MySQL server process—the way to do
this depends on our environment.
After our server has been restarted, we go back to the Replication menu; at this
point, we see a different panel regarding the master:
We can use the Show master status link to get some information about the master,
including the current binary log name and position, and information on which
databases to replicate or to ignore, as specified previously.
The Show connected slaves link would report nothing currently, as no slave is yet
connected to this master.
Now would be the time to use the Add slave replication user link, because this
master needs to have a separate account dedicated to replication. The slaves will use
this account created on the master to connect to it. Clicking on this link displays the
following panel, in which a user account, replic , is being created with a password of
our choosing:
 
Search WWH ::




Custom Search