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;