A.mysql -u 用户 -p -L 远程主机地址
B.mysql -u 用户 -p -h 远程主机地址
C.mysql -u 用户 -p -l 远程主机地址
D.mysql -u 用户 -passwd -h 远程主机地址
A.GRANTALLPRIVILEGESON*.*TO'mysql'@'localhost'WITHGRANTOPTION;赋予mysql最高权限
B.showgrantsfor'mysql'@'localhost;查看权限
C.withgrantoption表示允许用户将自己的权限授权给其它用户
D.revokecreateon*.*frommysqI’@localhost;回收msyql的create权限
A.当前test用户的登陆状态下权限会立即发生变化
B.当外存user表中关于test用户的信息更新至内存后,test用户的权限才发生改变
C.test用户重新登陆后,权限会发生变化
D.使用FLUSHPRIMLEGESSHE可将数据表字段写入内存
A.grant all on test.* to ‘zhang3’@’localhost’ identified by ‘123.com’
B.grant zhang3 on test.* to ‘all’@’localhost’ identified by ‘123.com’
C.grant zhang3 on test.* to ‘zhang3’@’all’ identified by ‘123.com’
D.grant all on test.* to ‘localhost’@’ zhang3’ identified by ‘123.com’