Mysql 授权

1.创建用户

create user 'tdoa'@'%' identified by 'tdoa';

如报错 use mysql;

 flush privileges;

2.授权
grant ALL PRIVILEGES on tdpm.td_quality_dimension_view to 'tdoa'@'%' identified by 'tdoa';

3.删除授权
revoke all on tdpm.td_bridge_project from 'tdoa'@'%';