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 table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select host, user, authentication_string, plugin from user;
相关推荐
CoderToy 2020-11-16
emmm00 2020-11-17
王艺强 2020-11-17
ribavnu 2020-11-16
bianruifeng 2020-11-16
wangshuangbao 2020-11-13
苏康申 2020-11-13
vivenwan 2020-11-13
moyekongling 2020-11-13
云中舞步 2020-11-12
要啥自行车一把梭 2020-11-12
aydh 2020-11-12
kuwoyinlehe 2020-11-12
minerk 2020-11-12
vitasfly 2020-11-12
jazywoo在路上 2020-11-11
敏敏张 2020-11-11
世樹 2020-11-11