数据库Mysql给用户赋予操作表的权限
CMD命令:
1:使用管理员账户登陆
2:创建用户:CREATE USER 'username'@'host' IDENTIFIED BY 'password';
3:授权:grant all privileges on orderautocategory.* to xcuser@localhost identified by 'xcuser';
3:或:GRANT all ON *.* TO 'root'@'%' WITH GRANT OPTION;
4:授予账号复制数据的权限:
GRANT REPLICATION SLAVE ON *.* TO 'test'@'%';
5:flush privileges;