Solved

mySQL - Allow access to ALL remote Windows connections

Posted on 2013-02-07
1
478 Views
Last Modified: 2013-02-26
I have a very basic install of mySQL that was packaged with a product called actiTime for time management.

My manager wants to be able to connect to the database via an ODBC connection. I have downloaded the ODBC drivers but cannot connect remotely. Comes back with "connection failed Host 'ManagersPC' is not allowed to connect to this MySQL server.

It runs on a Windows 2008 R2 box and the firewall is off.

I have seen commands listed for mySQL that allow one PC/IP address or user at-a-time access, but this is useless to us. The PC name could change, the ip address could change due to DHCP etc.

So, how do I open mySQL to allow remote connections to ALL?

I am a complete mySQL beginner, so yes the most basic and straightforward way would be great - thanks.
0
Comment
Question by:sterlingdev
1 Comment
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 38863250
you need to check the permissions/users created on  the MySQL side, you cannot "solve" this from the client side.
http://dev.mysql.com/doc/refman/5.1/en/grant.html

the username is implicitly also given a "hostname". with hostname being %, it would allow permission to connect (and executed the given grant) from any hostname.

but of course, reducing the % to specific host name(s) will increase the security
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

760 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

18 Experts available now in Live!

Get 1:1 Help Now