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 09:42PM

Grady Wang Wrote:
-------------------------------------------------------
> 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.


Hi Javier
Both of my laptos installed WINDWOS 7 and the DHCP server of local area network installed Redhat 6.5. I checked in iptables -L and the firewall is closed. any suggestions?

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.