Mysql5.7 登录报错1045

1045是因为权限不足导致，可以直接授权所有ip，也可以授权指定的ip

授权所有IP：
GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘密码’ WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'rootpassword' WITH GRANT OPTION;

授权指定IP：
GRANT ALL PRIVILEGES ON *.* TO ‘root’@’{要指定的ip}’ IDENTIFIED BY ‘{密码}’ WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.2.201' IDENTIFIED BY 'rootpassword' WITH GRANT OPTION;

刷新

flush privileges;