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
, k# S/ @! t6 j. i* E. A. h
, d$ L; I- Z$ u& a
#给用户cacti赋予所有库的所有权限  
9 D. A  m# n7 c, `) fGRANT ALL PRIVILEGES ON *.* TO 'cacti'@'%' IDENTIFIED BY 'cacti' WITH GRANT OPTION;  
6 L# w( S# j5 U- Y* u- M6 m3 J& F#重新载入赋权表  
FLUSH PRIVILEGES;  
  
8 v, }# @, \/ g! [* v6 X9 z#收回权限(不包含赋权权限)  
REVOKE ALL PRIVILEGES ON *.* FROM cacti;  
- X1 U1 M( F% q% e6 NREVOKE ALL PRIVILEGES ON cacti.* FROM cacti;  
#收回赋权权限  
REVOKE GRANT OPTION ON *.* FROM cacti;  
& N1 X& v  N7 E; j/ b2 Z# u#重新载入赋权表  
! \+ y, ?  @1 |* iFLUSH PRIVILEGES;  

admin

drop User 'cacti'@'localhost';

admin

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