Solved

ODBC Connector to MySQL hosted on GoDaddy

Posted on 2014-02-12
10
2,310 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 82

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 82

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
 
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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
LVL 82

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 82

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 82

Expert Comment

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

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

707 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

15 Experts available now in Live!

Get 1:1 Help Now