-- 登录MySQL
mysql -u root -p12345678
-- 创建用户
CREATE USER 'client4web2'@'127.0.0.1' IDENTIFIED BY 'client4web2';
-- 切换到mysql数据库
use mysql
-- 配置root用户访问主机
update user set host='%' where user='client4web2';
flush privileges;
-- 授权root用户为可访问所有数据库
grant all privileges on *.* to 'root'@'%';
flush privileges;
-- 配置用户访问主机
update user set host='%' where user='client4web2';
flush privileges;
-- 授权client4web2用户可访问所有数据库
grant all privileges on *.* to 'client4web2'@'%';
-- 授权vss数据库
-- grant all privileges on vss.* to 'client4web2'@'%';
flush privileges;
创建用户并赋予数据库权限语句
GRANT ALL PRIVILEGES ON 数据库名.* TO '用户名'@'%' IDENTIFIED BY '密码';
删除用户
-- 查询用户
SELECT user, host FROM mysql.user;
-- 删除用户:语法DROP USER '用户名'@'host字段值';
DROP USER 'client4webdebug'@'%';