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
: M% t" i" N6 X3 I9 |

! C9 b+ l( f( [# N3 H#给用户cacti赋予所有库的所有权限  
  S* i1 l+ R# s" I3 KGRANT ALL PRIVILEGES ON *.* TO 'cacti'@'%' IDENTIFIED BY 'cacti' WITH GRANT OPTION;  
#重新载入赋权表  
8 H2 l9 J# s( H1 yFLUSH PRIVILEGES;  
0 e0 p$ g6 B# E3 e! x  
6 s) u9 L! I: s, ^/ A' v#收回权限(不包含赋权权限)  
REVOKE ALL PRIVILEGES ON *.* FROM cacti;  
REVOKE ALL PRIVILEGES ON cacti.* FROM cacti;  
& T( A: x& _2 E4 F#收回赋权权限  
' l3 X; S( |6 ^6 ~/ \! ~' n9 nREVOKE GRANT OPTION ON *.* FROM cacti;  
  v$ b; M8 R4 h#重新载入赋权表  
FLUSH PRIVILEGES;  

admin

drop User 'cacti'@'localhost';

admin

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