|
|
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'to 'nova'@'%' identified by '123'' at line 1/ h, k+ ~: ^' n0 _+ Y; Y
9 J7 h7 F/ W3 N x
2 c4 J; F4 M4 x* r" e, g#给用户cacti赋予所有库的所有权限 ' L; L" {0 o- w* h E! f& {
GRANT ALL PRIVILEGES ON *.* TO 'cacti'@'%' IDENTIFIED BY 'cacti' WITH GRANT OPTION; " z3 e+ B8 c6 `6 T ?5 k2 p
#重新载入赋权表
, J6 g, |9 F* uFLUSH PRIVILEGES; ! `! l8 }) b4 v
4 B6 \( H2 M/ a: {( z" d
#收回权限(不包含赋权权限) ) A' L4 k) e! D. \5 T' n4 r I
REVOKE ALL PRIVILEGES ON *.* FROM cacti;
, q& B5 i& k5 E+ [& lREVOKE ALL PRIVILEGES ON cacti.* FROM cacti; 3 {5 }5 I1 a- M
#收回赋权权限
. K6 v x$ y8 D, t6 HREVOKE GRANT OPTION ON *.* FROM cacti;
, W( Z7 P( K9 g! b" o; [4 i$ x9 i#重新载入赋权表 0 b1 p7 p$ b/ \$ I
FLUSH PRIVILEGES; |
|
发表于 2018-1-9 09:50:31