iOS how to connect mysql remote database from iphone

[srinivas.be88]

hi ,
Hello, Can somebody please provide some example code to how I might connect a iPhone to a remote mysql database directly ( I know it's not the best way but is what is required for my app) ....

i need to upadte a database and retrive information


i am using cocos2D template to connect to the database

 

[adrian.oconnor]

Here's a blog post where someone has listed the steps to build libmysql for iPhone. It should be exactly what you need:

http://blog.iosplace.com/?p=20

 

[srinivas.be88]

thank you for reply... this link gave what i need

 

[Karl Kraft]

If you want to save yourself the trouble of having to compile the static library yourself, I have a 6 way fat version as part of my MysqlConnector for Objective-C. You can find more details on my blog: http://www.karlkraft.com/index.php/2010/09/17/mysql-for-iphone-and-osx/

 

[ulbador]

I don't know what you are planning on doing, but connecting remotely to a database is a horrible idea.

First, you basically eliminate any security that is built into the database. The username and password will be sent across the network in the clear, not to mention stored in the app. If you want to do something like this, build a web service. Have you iPhone app connect to a web server running something like Java, PHP or ASP that provides an interface to your database.

 

[adrian.oconnor]

I don't know what you are planning on doing, but connecting remotely to a database is a horrible idea. >snip<

For every tool there is a purpose. There are plenty of good reasons why OP might want to connect to MySQL directly. Maybe he's writing a MySQL management tool for iPhone. Maybe he doesn't want his product to require a web front end, for simplicity's sake. Maybe's it's a bespoke line-of-business app that will only get used in a particular way.

He can secure connections with ssh or SSL, if that's a requirement.