mariadb主从

|      5416 |              | information_schema,mysql,performance_schema |

+------------------+----------+--------------+---------------------------------------------+

1 row in set (0.00 sec)

 

从

mysql -p123qwe

 

stop slave;

CHANGE MASTER TO MASTER_HOST=‘172.16.0.226‘, MASTER_USER=‘abc‘,  MASTER_PASSWORD=‘123qwe‘, MASTER_LOG_FILE=‘testsql.000001‘, MASTER_LOG_POS=5416;

start slave;        

show slave status\G;

 

select host,user from mysql.user;   

delete from mysql.user where user=‘repl‘;

show master status;

show variables like ‘server_id‘;

 

mariadb主从

标签：orm   mat   sele   rom   _id   ant   creat   mysql   color