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 08:50PM

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
> > 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
> is my local area ip address. I dont
> think you can ping it.
> About the access , for example:
> A database was installed in My
> laptop IP is I can ping the 110
> address successfuly and use the access it by
> command mysql -h -ucrc -p123456 in
> laptop By when i used the mysql for
> excel in, i cant connect the database
> of
> 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.

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.