Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2014-03-06
12
909 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 83

Expert Comment

by:Dave Baldwin
ID: 39910172
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
ID: 39918556
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 83

Expert Comment

by:Dave Baldwin
ID: 39918585
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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

Author Comment

by:VMKuser
ID: 39918605
Yes, I set one up for %.
0
 

Author Comment

by:VMKuser
ID: 39918612
Here's what I see in phpmyadmin.
EE01.JPG
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39918643
Can you login thru phpMyAdmin with the 'linda' user?
0
 

Author Comment

by:VMKuser
ID: 39918646
Yes, I can login thru phpMyAdmin with the 'linda' user.
0
 
LVL 83

Accepted Solution

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

Author Comment

by:VMKuser
ID: 39918679
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 83

Expert Comment

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

Author Comment

by:VMKuser
ID: 39920887
That was it, David.  Thanks for your help.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39921265
You're welcome, thanks for the points.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Linux boot cd to do hardware report on PC? 3 63
Upgraded from Debian 7 to 8.7 and got black screen 20 69
expand ext4 on centos 6 5 37
plsql job on oracle 18 35
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

829 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