Mysql建立用户及权限
创建用户
CREATE USER 'newuser'@'%' IDENTIFIED BY 'newuserpasswd123';
分配权限
GRANT ALL ON yourtable.* TO 'newuser'@'%';
修改密码
update user set authentication_string = password('newuserpasswd123'),password_last_changed=now() where user='root';
博文最后更新时间：
评论
-
暂无评论