远程连接服务器mysql问题

is not allowed to connect to this MySQL server:

 

'%'  --指任何IP都可访问   指定IP访问可把'%'  改为'ip'
GRANT
ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; FLUSH PRIVILEGES;

 

posted @ 2018-05-29 14:49  charliepan94  阅读(85)  评论(0编辑  收藏  举报