mysql创建/删除用户

创建远程用户：

GRANT ALL PRIVILEGES ON *.* TO 'zhengyu’@'%' IDENTIFIED BY ‘zhengyu' WITH GRANT OPTION;

创建本地用户：将%改成localhost

删除用户：

DELETE FROM user WHERE User=“zhengyu" and Host="localhost";