Solved

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

Posted on 2014-03-06
12
890 Views
Last Modified: 2014-03-11
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
Comment
Question by:VMKuser
  • 6
  • 6
12 Comments
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
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
 

Author Comment

by:VMKuser
Comment Utility
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
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
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
 

Author Comment

by:VMKuser
Comment Utility
Yes, I set one up for %.
0
 

Author Comment

by:VMKuser
Comment Utility
Here's what I see in phpmyadmin.
EE01.JPG
0
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
Can you login thru phpMyAdmin with the 'linda' user?
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 

Author Comment

by:VMKuser
Comment Utility
Yes, I can login thru phpMyAdmin with the 'linda' user.
0
 
LVL 82

Accepted Solution

by:
Dave Baldwin earned 500 total points
Comment Utility
Then it seems likely that the Linux firewall (iptables) is blocking access from external sources.
0
 

Author Comment

by:VMKuser
Comment Utility
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
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
If all your staff are on the internal network, that would be all you would want.
0
 

Author Comment

by:VMKuser
Comment Utility
That was it, David.  Thanks for your help.
0
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
You're welcome, thanks for the points.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Little introduction about CP: CP is a command on linux that use to copy files and folder from one location to another location. Example usage of CP as follow: cp /myfoder /pathto/destination/folder/ cp abc.tar.gz /pathto/destination/folder/ab…
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

5 Experts available now in Live!

Get 1:1 Help Now