Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

DSN ODBC from Windows XP to MySQL

Posted on 2009-12-16
2
Medium Priority
?
549 Views
Last Modified: 2013-11-16
I have a MySQL database on a VPS that I would like to access through an ODBC connection from more than on location using Windows XP clients.

I followed these guides:
http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html
http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-configuration-dsn-windows.html

The problem is I keep getting the following error (see attachment):
Connection Error (..) Access denied

First how do fix this error, and how can I access the MySQL db from multiple locations?
Screen-shot-2009-12-16-at-12.25..jpg
0
Comment
Question by:eMijael
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 26066274
that is a plain grant problem.
you need, on the mysql server, to grant the permission to that login for that host, or, to grant to 'username'@'%' to allow the username to connect from any host.
0
 

Author Closing Comment

by:eMijael
ID: 31667005
Yes that was it.

Thank you. I'm new to MySQL so your help is greatly appreciated.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

564 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