MySQL Forums
Forum List  »  MySQL for Excel

Re: MYSQL for excel cant connect the remote mysql database
Posted by: Grady Wang
Date: September 26, 2014 06:59PM

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.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.