Mysq用户创建、修改密码、授权命令

CREATE USER 'isap'@'localhost' IDENTIFIED BY '123456'; 
GRANT ALL ON *.* TO 'isap'@'%'; 


GRANT privileges ON isapioe.* TO 'isapioe'@'localhost' WITH GRANT OPTION; 




GRANT privileges ON *.* TO 'isapioe'@'host' 


grant all on database.* to 'isap'@'%';


update user set password=password('123456') where user='root' and host='localhost';