GRANT ALL PRIVILEGES ON AI_MP_DOC.* TO root@'%' IDENTIFIED BY '123456';
GRANT select,insert,update,delete,create,drop,index ON AI_MP_DOC.* TO root@'%' IDENTIFIED BY '123456';
show grants for xinyan;
GRANT ALL PRIVILEGES ON `AI_MP_BASE`.* TO 'user'@'%' WITH GRANT OPTION;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, EXECUTE, CREATE ROUTINE, ALTER ROUTINE, EVENT ON `CREDIT_MP_MAP`.* TO 'user'@'%' ;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER ON `AI_MP_IDATA`.* TO 'user'@'%' WITH GRANT OPTION;
赋权限GRANT ALL PRIVILEGES ON AI_MP_DOC.* TO root@’%’ IDENTIFIED BY ‘123456’;GRANT select,insert,update,delete,create,drop ON AI_MP_DOC.* TO root@’%’ IDENTIFIED BY ‘123456’;