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

VMKuser
VMKuser used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Dave BaldwinFixer of Problems
Most Valuable Expert 2014

Commented:
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

Author

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.
Dave BaldwinFixer of Problems
Most Valuable Expert 2014

Commented:
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.
Ensure you’re charging the right price for your IT

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

Author

Commented:
Yes, I set one up for %.

Author

Commented:
Here's what I see in phpmyadmin.
EE01.JPG
Dave BaldwinFixer of Problems
Most Valuable Expert 2014

Commented:
Can you login thru phpMyAdmin with the 'linda' user?

Author

Commented:
Yes, I can login thru phpMyAdmin with the 'linda' user.
Fixer of Problems
Most Valuable Expert 2014
Commented:
Then it seems likely that the Linux firewall (iptables) is blocking access from external sources.

Author

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?
Dave BaldwinFixer of Problems
Most Valuable Expert 2014

Commented:
If all your staff are on the internal network, that would be all you would want.

Author

Commented:
That was it, David.  Thanks for your help.
Dave BaldwinFixer of Problems
Most Valuable Expert 2014

Commented:
You're welcome, thanks for the points.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial