Sha256: 7f17048a90dac08679115b243b3649458ec0d8fe4ab3002515bf844ca0a15a97
Contents?: true
Size: 767 Bytes
Versions: 11
Compression:
Stored size: 767 Bytes
Contents
#!/bin/sh
source ~/.lhm
master() { "$mysqldir"/bin/mysql --protocol=TCP -P $master_port -uroot; }
slave() { "$mysqldir"/bin/mysql --protocol=TCP -P $slave_port -uroot; }
# set up master
echo "create user 'slave'@'localhost' identified by 'slave'" | master
echo "grant replication slave on *.* to 'slave'@'localhost'" | master
# set up slave
echo "change master to master_user = 'slave', master_password = 'slave', master_port = 3306, master_host = 'localhost'" | slave
echo "start slave" | slave
echo "show slave status \G" | slave
# setup for test
echo "grant all privileges on *.* to ''@'localhost'" | master
echo "grant all privileges on *.* to ''@'localhost'" | slave
echo "create database lhm" | master
echo "create database if not exists lhm" | slave
Version data entries
11 entries across 11 versions & 2 rubygems