qq_43817164的博客

1.删除用指定户 delete from user where user='root' and host='%'; 2. 给用户授权 --增删改 GRANT select, insert, update, delete ON project_class.* TO 'rgzx'@'%' IDENTIFIED BY 'rgzx@123321@' WITH GRANT OPTION; --所有 grant all privileges on root.* to 'root'@'172.18.23.201'