so, how to grant remote access permissions to mysql server for root?
run the following commands.
//xxx is your root password #mysql -uroot -pxxx #use mysql //grant remote access permissions for root #grant all privileges on *.* to root@'%' identified by "xxx"; //flush #flush privileges;The "cant connect to MySQL server on 'xxx'(10038)" error has been solved.
No comments:
Post a Comment
Note: only a member of this blog may post a comment.