Problem connecting mysql on windows 10

Question

0.00/5 (No votes)

See more:

Hi all,

I have a visual basic app that uses the WAN connection (connecting thru router). It uses mysql as its database for the data. After I have finished the application, I tried connecting the mysql server on a Windows 7 pc, from another pc with same OS, and the connection was fined, I can query any data I want. Then came a brand new pc with Windows 10 as its OS. So I installed the mysql server with the database on this new pc. However, when I try to connect to it from a Windows 7 laptop or PC via WAN, the connection always fails. But when I try to connect the mysql server on the Windows 10 pc's localhost the connection is fine? Am i missing something? Or is this bug in Windows 10?

What I have tried:

I tried turning off the firewall on both PCS( the Windows 10 pc and the Windows 7 laptop), but still it is failing, I tried googling for an answer but it seems that they only provide a solution if you cannot connect on the localhost on the Windows 10 pc with the mysql server installed, but to me I can connect to it just fine. I'm connecting the mysql server thru mysql odbc driver.

Any help, link, or solution will be much appreciated. Thank you very much :)

Posted 27-Oct-16 14:51pm

kenchidag

Add a Solution

Comments

Herman<T>.Instance 31-Oct-16 8:46am

IP4 or IP6?

kenchidag 2-Nov-16 19:32pm

Hi digimanus! umm its IP4

Herman<T>.Instance 3-Nov-16 9:39am

Do you get any exception?

kenchidag 3-Nov-16 20:20pm

there is no exception in the case of my vb app,, however the error comes from connection the mysql odbc driver installed on my laptop via Administrative Tools on my Windows 7 laptop, it says "could not connect to the specified instance". Although the username i created in mysql to access mysqlserver has all priviledges granted on it. and when i ping the connection its an error, thought both firewalls are turn off already. Also on a personal note I just noticed that when I ping the connection thru cmd it is also error it says "Request time out".But when i ping the connection from my Windows 10 pc to the Laptop pc with Windows 7, the connection is Ok. Sometimes I just wonder? Why is it like that hahaha :). Its wierd though,, haha

Herman<T>.Instance 4-Nov-16 3:58am

do you connect/pin to the right portnumber of the MySql Server?

kenchidag 4-Nov-16 4:12am

Yes i connect with port number 3306

Herman<T>.Instance 4-Nov-16 4:16am

Can the MySQL workbench connect to the database?

kenchidag 6-Nov-16 19:23pm

actually I havent used mysql workbench... Is it necessary to have?

Herman<T>.Instance 7-Nov-16 3:19am

Well that's the best tool to see why your connection is failing...

kenchidag 8-Nov-16 2:31am

Oh I see. I'll try to use it. Tnx

kenchidag 3-Nov-16 22:10pm

I googled for a while and found something about ICMP, does it have something to do with this?

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)