• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 991
  • Last Modified:

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.
0
VMKuser
Asked:
VMKuser
  • 6
  • 6
1 Solution
 
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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 6
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now