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