菜鸟踩坑学习笔记"/>
编程菜鸟踩坑学习笔记
在给访问服务的用户改权限时,报错:your MySQL server version for the right syntax to use near 'identified by 'myPassword'' at line 1
原因是:因为mysql的新版本,创建用户与给用户授权分开了。X
解决方案:
create user 'username' @'%' identified by 'userpassword'; //创建用户grant all privileges on *.* 'username'@'%' indentified by 'userpassword' with grant option; //给用户username 所有权限 flush privileges; //刷新权限
如果能帮到你请点赞谢谢!
更多推荐
编程菜鸟踩坑学习笔记
发布评论