mysql 创建用户 grant

使用 GRANT 语句创建MySQL用户：
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
    -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
： 所有权限，在localhost登录，用户名为"monty", 密码为"some_pass"

mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
    -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
: 所有权限，允许远程登录，用户名为"monty",密码为"some_pass"

mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
: 赋予RELOAD,PROCESS权限，从localhost登录，用户名admin，无密码

mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';
: 无任何权限(待修改),从localhost登录，用户名dummy,无密码