Help with ODBC connection from Windows 7 workstation to Linux MySQL database.

I am a MSSQL programmer, but am new to the Linux/MySQL world.  I am using a Windows 7 workstation, trying to create an ODBC connection to our Linux MySQL Database.  

I am referencing port 3306, logging in as root with the password, and specifying the name of the database.  

The ODBC test connection error message says:

Connection Failed: [HY000] [MySQL] [ODBC 5.1 Driver] Can't connect to MySQL server on '100.100.100.82' (10061)

Any help would be appreciated.
VMKuserAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
A normal installation of MySQL does not allow external access with 'root' and strongly recommends against changing that.  You would normally create a more limited user with privileges from 'anyhost' or a specific host IP and use that to connect from another machine.  http://dev.mysql.com/doc/refman/5.1/en/adding-users.html
0
VMKuserAuthor Commented:
Sorry, didn't see this comment.  

Still not working.  I used the GRANT command to grant privileges to "linda".  I've tried connecting using the "linda" login and password, but still no luck.

The error message I'm receiving is the same.
0
Dave BaldwinFixer of ProblemsCommented:
Does your 'linda' login include external access thru 'anyhost' (%)?  MySQL user format includes username, password, and connection.  A 'localhost' connection is Not the same user as an 'anyhost' (%) connection.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

VMKuserAuthor Commented:
Yes, I set one up for %.
0
VMKuserAuthor Commented:
Here's what I see in phpmyadmin.
EE01.JPG
0
Dave BaldwinFixer of ProblemsCommented:
Can you login thru phpMyAdmin with the 'linda' user?
0
VMKuserAuthor Commented:
Yes, I can login thru phpMyAdmin with the 'linda' user.
0
Dave BaldwinFixer of ProblemsCommented:
Then it seems likely that the Linux firewall (iptables) is blocking access from external sources.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
VMKuserAuthor Commented:
I'll check into that.  Since we want this only accessible to our staff in the network, would I allow the internal IP address or the external IP address?
0
Dave BaldwinFixer of ProblemsCommented:
If all your staff are on the internal network, that would be all you would want.
0
VMKuserAuthor Commented:
That was it, David.  Thanks for your help.
0
Dave BaldwinFixer of ProblemsCommented:
You're welcome, thanks for the points.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.