mysql中远程连接权限语句grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘123456‘ with grant optio报错
grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘123456‘ with grant optio原因: mysql的版本问题,这条语句适用于MySQL8.0之前解决: mysql8.0及以上版本需要使用以下语句:create user root@'%' identified by '123456';grant all privile
·
grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘123456‘ with grant optio
原因: mysql的版本问题,这条语句适用于MySQL8.0之前
解决: mysql8.0及以上版本需要使用以下语句:
create user root@'%' identified by '123456';
grant all privileges on *.* to root@'%' with grant option;
更多推荐
已为社区贡献13条内容
所有评论(0)