Re: MYSQL for excel cant connect the remote mysql database

[Grady Wang]

Grady Wang Wrote:
-------------------------------------------------------
> Javier Treviño Wrote:
> --------------------------------------------------
> -----
> > Hi Grady,
> > Thanks for writing in our forums.
> >
> > I tried to ping that IP address you supplied in
> > your example with no success. Is the IP
> > 172.20.0.110 the correct one?
> >
> > When you said you accessed the server by
> command,
> > do you mean you ran the MySQL console from the
> > same computer where MySQL for Excel was
> installed?
> > This is very important, because if you ran the
> > MySQL console from a different computer then
> the
> > test is not good.
> >
> > Can you please clarify and provide an IP
> address
> > that works so I can help you troubleshoot?
> >
> > Best regards.
>
> Hi Javier
> 172.20.0.110 is my local area ip address. I dont
> think you can ping it.
> About the access , for example:
> A database was installed in 172.20.0.110. My
> laptop IP is 172.20.0.171. I can ping the 110
> address successfuly and use the access it by
> command mysql -h 172.20.0.110 -ucrc -p123456 in
> laptop 172.20.0.171. By when i used the mysql for
> excel in 172.20.0.171, i cant connect the database
> of 172.20.0.110.
> That it.

Hi Javier
I found something new:
This issue was caused by my local network. I make the two laptops connect our company network (IP address:9.x.x.x), the mysql for excel in one laptop can connect the database in another laptop. So it was not the software issue.
But i sitll suffer the problem , because the database of laptop has to work in my local network. Since i know something worong in my local network, but i dont know how to fix it. Could you give me some suggestions? I had already check the firewall, and mysql port:3306 and any other.
When i run the mysql for excel in my laptop, the pid of computer was found setup but didnt make a connection with the service mysqld in the database of laptop. But the connection action is succesful by typing mysql command "mysql -h -u -p" in the two laptops.