0

i am newbie to iphone programming. I am working on an iphone project.

My question is:

How to connect my iphone application to a remote server mysql database directly? There are many ways to connect through PHP scrip/ json/xml/ webservices. But i dont need that. I would like to have direct connetion to mysql of remote server without any intermediate?

mH16
  • 2,356
  • 4
  • 25
  • 35
  • See [this](http://stackoverflow.com/questions/4858274/xcode-objective-c-connect-to-mysql-database). – denolk Sep 16 '11 at 11:07

3 Answers3

2

Basically you would need to build a mysql client lib for iOS and then use that from Objective-C. This blog post should get you started. As stated by peko you should really reconsider that you are doing the right thing. The mysql network protocol isn't exactly made for mobile clients where connections can drop, be unavailable, etc.

cellcortex
  • 3,166
  • 1
  • 24
  • 34
1

You shouldn't do this because someone could sniff the traffic and get the username and password for your database, or inject sql-code.

peko
  • 11,267
  • 4
  • 33
  • 48
1

Here's a MySql objective-C client for iPhone. It was traditionally available only for OSX but they just released it for iOS:

http://www.karlkraft.com/index.php/2010/09/17/mysql-for-iphone-and-osx/

I haven't used it. I would still strongly recommend exposing via services. I would also be interested in why you need to directly connect to the DB and why services isn't appropriate :)

bryanmac
  • 38,941
  • 11
  • 91
  • 99
  • thankss , i read this.I will use it for my homemade application. Is there any specific example for iphone where this library used. – mH16 Sep 16 '11 at 11:47