1、方式一:创建用户时默认本机可以登录,授权外网可以登录。
语法:
CREATE USER '用户名'@'localhost' IDENTIFIED BY '密码';
GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
/*刷新*/
flush privileges;
示例:
CREATE USER 'zhaoliu'@'localhost' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON *.* TO 'zhaoliu'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
/*刷新*/
flush privileges;
2、方式二:创建用户时默认外网可以登录,授权本机可以登录。
语法:
CREATE USER '用户名'@'%' IDENTIFIED BY '密码';
GRANT ALL PRIVILEGES ON *.* TO '用户名'@'localhost' IDENTIFIED BY '密码' WITH GRANT OPTION;
/*刷新*/
flush privileges;
示例:
CREATE USER 'wangwu'@'%' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON *.* TO 'wangwu'@'localhost' IDENTIFIED BY '123456' WITH GRANT OPTION;
/*刷新*/
flush privileges;