Solved

ODBC Connector to MySQL hosted on GoDaddy

Posted on 2014-02-12
10
2,410 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 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MSSQL 2008 with mySQL webservers 7 52
Duplicating MySQL Table columns 5 38
xampp tool 12 50
MySqlDump not dumping triggers 1 31
Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

810 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