mysql赋权限
1、为在mysql创建test1账号,并赋予10.96.90.78,只读amp库中alert_info_tab表的权限
grant select on amp.alert_info_tab to identified by "123456";
2、取消10.96.90.78,只读amp库中alert_info_tab表的权限
REVOKE SELECT ON amp.alert_info_tab FROM ;
3、显示10.96.90.78 ,使用test1账号有什么权限
show grants for ;
相关推荐
sifeimeng 2020-06-21
阿斌Elements 2020-05-05
songerxing 2020-05-03
yixiaoqi00 2020-04-22
要啥自行车一把梭 2020-04-17
随心而作 2020-04-07
JayFighting 2020-04-07
80327065 2020-03-09
lhxxhl 2020-03-06
woxmh 2020-03-04
hgzhang 2020-02-18
时光如瑾雨微凉 2020-02-02
winmeanyoung 2020-01-29
wyqwilliam 2020-01-17
typhoonpython 2020-01-12
sofast 2020-01-08
KaiZhaoKZ 2019-12-29
snowpage 2014-07-10