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
* g& t0 P7 x/ s' m, B0 r* \5 X$ `- s
* t/ a% F$ Z* r8 E( D5 S! d
#给用户cacti赋予所有库的所有权限  
GRANT ALL PRIVILEGES ON *.* TO 'cacti'@'%' IDENTIFIED BY 'cacti' WITH GRANT OPTION;  
#重新载入赋权表  
FLUSH PRIVILEGES;  
  
  p3 d% I1 O6 q" N0 D9 V#收回权限(不包含赋权权限)  
. q! i2 j1 Q/ t% b+ a& EREVOKE ALL PRIVILEGES ON *.* FROM cacti;  
REVOKE ALL PRIVILEGES ON cacti.* FROM cacti;  
#收回赋权权限  
- n% P# }' u) E; V5 s; G3 oREVOKE GRANT OPTION ON *.* FROM cacti;  
$ J4 Q4 o1 C& }4 a& R! g( N9 V#重新载入赋权表  
FLUSH PRIVILEGES;  

admin

drop User 'cacti'@'localhost';

admin

grant all on *.* to dba@localhost;
* |7 H  a) C; F4 J5 E: f7 arevoke all on *.* from dba@localhost;