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


+ f$ B: |" Y' j$ _. J! ~7 Y#给用户cacti赋予所有库的所有权限  
  w8 \" P$ l3 P; VGRANT ALL PRIVILEGES ON *.* TO 'cacti'@'%' IDENTIFIED BY 'cacti' WITH GRANT OPTION;  
, t# l9 j4 u: `9 E' K* e' w* m#重新载入赋权表  
FLUSH PRIVILEGES;  
  
5 ^1 q- V8 Q0 M: f0 ^, w#收回权限(不包含赋权权限)  
! p& u; U) W7 b( \0 R. \REVOKE ALL PRIVILEGES ON *.* FROM cacti;  
REVOKE ALL PRIVILEGES ON cacti.* FROM cacti;  
#收回赋权权限  
REVOKE GRANT OPTION ON *.* FROM cacti;  
. [" t, m$ |  H! U8 X5 @& a#重新载入赋权表  
FLUSH PRIVILEGES;  

admin

drop User 'cacti'@'localhost';

admin

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