解决mysql远程无法链接问题

登入mysql

mysql -u root -p

固定ip登入

GRANT ALL PRIVILEGES ON *.* TO '账号'@'固定ip' IDENTIFIED BY '密码' WITH GRANT OPTION;

 

任何id登入

GRANT ALL PRIVILEGES ON *.* TO '账号'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;