connecting a database using godaddy

[ak1dnar]

Sorry I already had the database created in Access that's why i asked. Were can I safely download mysql server to install it?

http://dev.mysql.com/downloads/

[nicoletsii]

Ok I had downloaded it but can't figure out how to install it.

[ak1dnar]

Ok I had downloaded it but can't figure out how to install it.

Everything you need were there on the URL provided in my earlier post. make sure to use google or your favorite search engine application before asking more questions.

http://dev.mysql.com/doc/refman/5.0/en/installing.html

[nicoletsii]

Thank You for your help I downloaded the wrong one at first that was the problem.

[nicoletsii]

I'm sorry to keep bothering you but i'm really having some issue with this database & godaddy after I get this working I will not use godaddy ever again. anyways what do I need to do to connect my database to my web site. The database is created but I tried to use a connection string that keeps tell me that there's something wrong with my server & when I called them (godaddy) they told me that 's it 's on my behalf. How do you connect your database to your web site?

[ak1dnar]

I'm sorry to keep bothering you but i'm really having some issue with this database & godaddy after I get this working I will not use godaddy ever again. anyways what do I need to do to connect my database to my web site. The database is created but I tried to use a connection string that keeps tell me that there's something wrong with my server & when I called them (godaddy) they told me that 's it 's on my behalf. How do you connect your database to your web site?

Please show us the source codes that you have used recently. and Tell us what is getting as the error message.

[nicoletsii]

1.DRIVER={MySQL ODBC 3.51 Driver}; 2.SERVER=hxxmys qlxx.secureserv er.net; PORT=3306; DATABASE='datab ase name';
3.USER=tsiiinc; PASSWORD='your password'; OPTION=0;

with the right settings for my database

This is the code I was trying to use , but not matter what code I use no matter what I put it keeps giving me this error, I called godaddy too and they said that the server is working just fine. I just need to find a new hosting server.

ERROR
#1064 you have an error in your sql syntax; check tne manual that corresponds to your mysql server version for the right sytax to use near " driver = { mysql ODBC 3.51 Driver}' at line 1

[nicoletsii]

1.DRIVER={MySQL ODBC 3.51 Driver}; 2.SERVER=hxxmys qlxx.secureserv er.net; PORT=3306; DATABASE='datab ase name';
3.USER=tsiiinc; PASSWORD='your password'; OPTION=0;

with the right settings for my database

This is the code I was trying to use , but not matter what code I use no matter what I put it keeps giving me this error, I called godaddy too and they said that the server is working just fine. I just need to find a new hosting server.

ERROR
#1064 you have an error in your sql syntax; check tne manual that corresponds to your mysql server version for the right sytax to use near " driver = { mysql ODBC 3.51 Driver}' at line 1

I'm assuming no one know anything about this. Just to let everyone know i'm not the only one with these issues.
i'm

[nicoletsii]

I'm assuming no one know anything about this. Just to let everyone know i'm not the only one with these issues.
i'm

512 views within 1 month shows how many people really need help with godaddy's database services. i will help all as soon as i figure it out.

[nicoletsii]

go daddy already has phpmyadmin install in the database

[fury]

Here is Your Solution...

Either get dedicated hosting from GoDaddy or get a better hosting provider. I would go with the latter, I currently have godaddy for both of my websites and I have been disappointed many times by their lack of customer support and the way they disable so many of the features you would expect from a hosting provider (E.g such as your problem, no remote database access).

Here is the solution I found for your problem (also the one I was having during development)

"Unfortunat ely, we do not allow external connections to our database servers. When connecting to a database in your Shared Hosting account, you must access it through the Database section of the Hosting Control Center."

Can I connect to my database remotely? - Help Center—Kn owledge Base and FAQ


Oh and you can use access as your development database (on your computer) and then just export the database to a file and then import it to mysql on your live server. There is no reason why you should have to download mysql and use that instead of whatever development database you want to use. Any database server will have these import/export features (even Excel has them).

[bwtharp]

godaddy access

Actually, GoDaddy does allow remote access to the databases. When creating the database be sure to check the box "allow remote access". Things will work fine. The default is no access.

Bruce