W3Schools Learner's Blog

W3Schools Programming knowledge summary website

div

11/29/2017

mysql "cant connect to MySQL server on 'xxx'(10038)" error

Navicat connection mysql database error: "cant connect to MySQL server on 'xxx'(10038)" ,this is because you haven't permission of access to the remote database.

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.