mysql 操作

CREATE USER 'repliceof'@'172.18.140.7' IDENTIFIED WITH mysql_native_password BY 'repliceof123.';

grant SELECT,UPDATE,DELETE,INSERT,ALTER,CREATE on test_grant.* to 'testuser1'@'%' with grant option; 

## 新建复制用户

GRANT REPLICATION SLAVE ON *.* TO 'testuser1'@'%' with grant option;

## 忘记密码【skip-grant-tables】

先执行 flush privileges;

--再执行 set password for 'root'@'localhost'=‘123456’；

'>