89303
Creating a User for Replication
Each slave must connect to the master using a MySQL user name and password, so there must be
a user account on the master that the slave can use to connect. Any account can be used for this
operation, providing it has been granted the REPLICATION SLAVE [775] privilege. You may wish to
create a different account for each slave, or connect to the master using the same
account for each
slave.
You need not create an account specifically for replication. However, you should be aware that
the user name and passwDrd are stored in plain text in the master info repository file or table (see
Section 16.2.2.2, “Slave Status Logs"). Therefore, you may want to create a separate account that has
privileges only for the replication process, to minimize the possibility of compromise to other accounts.
To create a new account, use CREATE USER. To grant this account the prh/ileges reąuired for
replication, use the GRANT statement. If you create an account solely for the purposes of replication,
that account needs only the REPLICATION SLAVE [775] privilege. For example, to set up a new user,
repl, that can connect for replication from any host within the mydomain.com domain, issue these statements on the master:
mysql>CREATE USER 1repl'Q.mydomain.com' IDENTIFIED BY ’slavepass'; mysql>GRANT REPLICATION SLAVE ON *.* TO ’repl*Q’%.mydomain.com1 ;
See Section 13.7.1, “Account Management Statements", for morę information on statements for
manipulation of useraccounts.
Wyszukiwarka
Podobne podstrony:
Connecting to the MySQL Server For a Client program to be able to connect to the MySQL server, it muManagement clients. These dients connect to the management server and prcwide commands for startingAs finał test for monitoring apparatus, a real PT1000 temperaturę sensor has been connected to the fSolution of the equations We notę that the equation above gives two values for y , of which one mustscreenshot 2 To enter this website. you must agree to the terms below. The materiał contained hereln50 Fluid Mechanics connected to the pipę, due to high pressure at A, the heavy !iquid in the reservoThe main disadvantages of using a Computer is that staring at a screen for long periods can be harmf19vcg09 Welcome to Windows for Workgroups Micbosoft.WINDOWS. Type a logon name and password to log o20641 Opel Immo2 TMS2 Step 3. De-solder these two points as this is where the aerial is connected toLoaded hiwes: <san> <systew> <secux ity> Edit user data and passwords Syskey statuCartoon?kes ?bbie Brown 3 1 O For Jerry s ears. spin I5g (’Aoz) of the deep golden brown in halfSecurity Guidelines Anyone using MySQL on a Computer connected to the Internet should read this sectTo start SQL*Plus and connect to the data hast* from the Windows Start nienu: 1. CTo start SQL*Plus and connect to the database from the conimand linę: 1. Open a coReplication Compatibility Between MySQL Versions MySQL supports replication from one major version twięcej podobnych podstron