msyql无法远程登录

error1:

ERROR 1045 (28000): Access denied for user 'root'@'xyt.local' (using password: YES)

grant all on mysql.* to 'root'@'192.168.11.172' identified by '1111'

 

error2:

Host 'ubuntu.local' is not allowed to connect to this MySQL server

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
FLUSH PRIVILEGES;