Solved

ODBC Connector to MySQL hosted on GoDaddy

Posted on 2014-02-12
10
2,662 Views
Last Modified: 2014-02-13
Hi
First time i'm trying to setup ODBC connector to MySQL database, but not connecting.
I'm not sure what info should be placed in TCP/IP server, i tried using the Hostname or the admiun url but nothing worked.
If anyone can help with that or maybe something else is missing or need to be setup.
Thanks in advance !
0
Comment
Question by:Gozreh
[X]
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
  • 5
  • 4
10 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39855283
First, have you set up a database in your hosting control panel?  Second, did you record the username, password, and connection info so you can use it to connect?  Third, did you set it up to allow external connections?  Fourth, what programming language are you using to connect and from where are you trying to connect?
0
 
LVL 10

Author Comment

by:Gozreh
ID: 39855304
1) i have a database hosting on Godday.

2) i can see on the control panel all my info, Hostname, admiun url, user name, and i have my password.

3) how do i setup to allow external connections, i know how to connect through php coding, and i did it, and it work. (i used mysqli_connect('ip address', 'user name', 'password');)

4) now i want to connect to ms access to be able to pull reports, so i want to create a dsn with "Data Sources (ODBC)" in the "Control Panel\System and Security\Administrative Tools", but now i'm stuck, its not working.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39855408
You need to install the MySQL ODBC connector, it does not come with Windows.  You can find the different versions on this page: http://dev.mysql.com/downloads/connector/odbc/   Pick the one that matches your system (32/64 bit) and install it.  Then you can set up a DSN with the same credentials you used in PHP IF you have allowed external connections in the MySQL setup.  If the IP address starts with 10.x.x.x then you can't make an external connection to it because it is on Godaddy's internal private LAN.
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 10

Author Comment

by:Gozreh
ID: 39856942
What do mean "you have allowed external connections in the MySQL setup" ?

I downloaded the odbc driver, i entered all info but getting error "cant connect to mysql server 10060"
MySql.png
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39857108
When you set up a MySQL database on Godaddy, if you select version 5.0 in the setup, there is an option under Additional Options at the bottom to allow external connections.  If you select MySQL version 5.5, that option is not available.  Some hosting companies do not allow external connections to databases at all because it is considered a security risk.
Godaddy MySQL set up
0
 
LVL 10

Author Comment

by:Gozreh
ID: 39857173
I see now in my MySql details
MySQL version:
5.0 (Direct access not allowed)

do you know how i can change it ?
0
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 39857336
You can't change it after it is setup.  They are actually on different servers, one refuses external access and one allows it.  You can only create a new database, export from the old one and import into the new one.
0
 
LVL 10

Author Closing Comment

by:Gozreh
ID: 39857397
Thanks for this information, will see what i can do in my situation.

 Thank you very much
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39857408
You're welcome, glad to help.
0

Featured Post

 Watch the Recording: Learning MySQL 5.7

MySQL 5.7 has a lot of new features. If you've dabbled with an older version of MySQL, it is definitely worth learning.

Question has a verified solution.

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

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

636 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