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


#给用户cacti赋予所有库的所有权限  
GRANT ALL PRIVILEGES ON *.* TO 'cacti'@'%' IDENTIFIED BY 'cacti' WITH GRANT OPTION;  
3 N1 y4 k. @; M- L#重新载入赋权表  
9 \; P4 b5 {2 ]) z9 qFLUSH PRIVILEGES;  
  
#收回权限(不包含赋权权限)  
REVOKE ALL PRIVILEGES ON *.* FROM cacti;  
) w) U! L# Z+ B0 g; e/ _0 `: \7 cREVOKE ALL PRIVILEGES ON cacti.* FROM cacti;  
0 m/ X) x% j  z2 f* I3 l#收回赋权权限  
4 o0 |1 k; G$ ]" nREVOKE GRANT OPTION ON *.* FROM cacti;  
#重新载入赋权表  
FLUSH PRIVILEGES;  

admin

drop User 'cacti'@'localhost';

admin

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