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?
Subject
Views
Written By
Posted
12115
September 26, 2014 05:36AM
4728
September 26, 2014 05:48AM
4092
October 08, 2014 01:12AM
3482
September 26, 2014 06:05AM
3202
September 26, 2014 06:29AM
3292
September 26, 2014 04:57PM
3130
September 26, 2014 04:56PM
2989
September 26, 2014 06:59PM
2796
September 26, 2014 08:50PM
Re: MYSQL for excel cant connect the remote mysql database
3037
September 26, 2014 09:42PM
2578
September 30, 2014 01:52PM
2984
September 30, 2014 02:15PM
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.