MySQL新建用户，及设定访问权限

访问权限"/>

MySQL新建用户，及设定访问权限

创建新用户:

    -- 创建新用户，设定只能本地登陆CREATE USER 'zero'@'localhost' IDENTIFIED BY '123456';-- 创建新用户，设定任意IP访问CREATE USER 'zero'@'%' IDENTIFIED BY '123456';-- 创建新用户，设定特定IP访问CREATE USER 'zero'@'127.0.0.1' IDENTIFIED BY '123456';

新用户授权：

    -- 设置对某个数据库由所有权限GRANT ALL PRIVILEGES ON test.* to zero@'localhost';-- 设置对某个数据库有增删改查权限GRANT SELECT, INSERT, UPDATE, DELETE ON test.* to zero@'localhost';

刷新权限，是调整生效：

    FLUSH PRIVILEGES;

好记性，不如烂笔头 :)