ERROR 1064 (42000):

admin

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
9 `! F% J2 k+ B, E3 F
; c) _' b: o; z( l  V
#给用户cacti赋予所有库的所有权限  
1 S* z7 t% O3 s; `GRANT ALL PRIVILEGES ON *.* TO 'cacti'@'%' IDENTIFIED BY 'cacti' WITH GRANT OPTION;  
) B$ H' Q8 w- d6 ^3 X" e+ Z#重新载入赋权表  
5 t7 r) n2 C4 X( ~1 V+ I, U0 Z: \" vFLUSH PRIVILEGES;  
$ Q' n6 @. D: I* G  
#收回权限(不包含赋权权限)  
0 I( L. W- j$ i7 VREVOKE ALL PRIVILEGES ON *.* FROM cacti;  
  H$ g0 r! k+ _+ o, ^/ l  XREVOKE ALL PRIVILEGES ON cacti.* FROM cacti;  
#收回赋权权限  
' S, I1 t& G& y" PREVOKE GRANT OPTION ON *.* FROM cacti;  
#重新载入赋权表  
# i5 x$ r; X. z, s/ I: y, A" Y  DFLUSH PRIVILEGES;  

admin

drop User 'cacti'@'localhost';

admin

grant all on *.* to dba@localhost;
revoke all on *.* from dba@localhost;