mysql database

 

SELECT * FROM USER

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

其中，%是远程调用符号；localhost是本地调用

给指定用户赋予部分权限

GRANT SELECT,INSERT,DELETE,UPDATE ON urp.* TO username@'%' IDENTIFIED BY 'password';

GRANT EXECUTE ON urp.* TO username@'%' IDENTIFIED BY 'password';

给指定用户赋予全部权限

GRANT ALL ON *.* TO username@'%' IDENTIFIED BY 'password';

GRANT ALL ON *.* TO username@'localhost' IDENTIFIED BY 'password';