Skip to main content

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】

-- set password for 'root'@'localhost'=‘123456’;

 

 



'>