Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

ODBC Connector to MySQL hosted on GoDaddy

Posted on 2014-02-12
10
Medium Priority
?
2,858 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
  • 5
  • 4
10 Comments
 
LVL 84

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 84

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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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 84

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 84

Accepted Solution

by:
Dave Baldwin earned 2000 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 84

Expert Comment

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

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month11 days, 22 hours left to enroll

916 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