CREATE USER
CREATE USER '用户'@'%' IDENTIFIED BY '密码';
Grant the highest authority
GRANT ALL PRIVILEGES ON *.* TO '用户'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
创建数据库的用户
create user 'shop_user'@'%' identified by 'shop@123';
'shop_user' 用户名称
'shop@123' 用户密码
@后的命令解释
'%' - 所有情况都能访问
'localhost' - 本机才能访问
'111.222.33.44' - 指定 ip 才能访问
给予新用户的授予权限
GRANT ALL PRIVILEGES ON *.* TO 'gddl'@'%' with grant option; #8.0的版本
grant all on 数据库名.数据库表 to 用户名@'%' identified by "密码";
GRANT ALL PRIVILEGES ON *.* TO 'gddl'@'%' IDENTIFIED BY 'Asd@2021' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
GRANT ALL PRIVILEGES ON *.* TO 'gddl'@'%' IDENTIFIED BY 'Asd@2021' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
例如
grant all on shop.* to 'shop_user'@'%' identified by 'shop@123';
all 可以替换为 select,delete,update,create,drop
数据库名 所有的 用*
数据库表 所有的 用*
查看权限
show grants for '用户'@'%' (如果定义了指定ip 访问 就需要更改为ip地址)
+-----------------------------------------------------------------------------------------------------+
| Grants for shop@% |
+-----------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'shop'@'%' IDENTIFIED BY PASSWORD '*E42549EA23D1591C3297C2BDAB0C91699F3D66DB' |
| GRANT ALL PRIVILEGES ON `shop`.* TO 'shop'@'%' |
+-----------------------------------------------------------------------------------------------------+
第一条 表示 创建的账号以及密码
第二条 表示 ALL PRIVILEGES 权限 ALL表示全部 如有部分 是 select,delete,update,create,drop.. 其中一些、
删除用户
drop user 用户名称
修改用户
rename user '用户名称'@'ip地址/%' to '新用户'@'ip地址/%';
修改密码
set password for '用户名'@'IP地址' = Password('新密码');
SELECT
user
FROM
数据库的名字.user;