1.刷新权限表
flush privileges;
2.查看从库状态
show slave status/G;
3.查看mysql状态(包含版本号等信息)
status;
4.创建数据库
CREATE DATABASE dbname;
5.增加一个用户
grant select,insert,update,delete on mydb.* to name@localhost identified by "password";
1.刷新权限表
flush privileges;
2.查看从库状态
show slave status/G;
3.查看mysql状态(包含版本号等信息)
status;
4.创建数据库
CREATE DATABASE dbname;
5.增加一个用户
grant select,insert,update,delete on mydb.* to name@localhost identified by "password";