失眠雨

文章
5
资源
0
加入时间
3年0月8天

Mysql 8.0 ERROR 1064 (42000)

在mysql 8.0中使用mysql5.7的语法对mysql进行远程登录授权时会报语法错误正确的姿势是:CREATE USER 'root'@'%' IDENTIFIED BY '****密码****'; GRANT ALL ON *.* TO 'root'@'%'; ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '****密码****';mysql> use mysql;Reading tabl