What are the best ways to connect an Android app to a MySQL database ?

Connecting application direct to DB is insecure, you should have middleware between db and app

Hello ...I here mention below some links for connect database to Android App..http://www.androidhive.info/2012/05/how-to-connect-android-with-php-mysql/ Links...Make a class to make an HTTP request to the server. For example (I am using JSON parsing to get the values): public class JSONfunctions { public static JSONObject getJSONfromURL(String url) { InputStream is = null; String result = ""; JSONObject jArray = null; // Download JSON data from URL try { HttpClient httpclient = new DefaultHttpClient(); HttpPost httppost = new HttpPost(url); HttpResponse response = httpclient.execute(httppost); HttpEntity entity = response.getEntity(); is = entity.getContent(); } catch (Exception e) { Log.e("log_tag", "Error in http connection " + e.toString()); } // Convert response to string try { BufferedReader reader = new BufferedReader(new InputStreamReader( is, "iso-8859-1"), 8); StringBuilder sb = new StringBuilder(); String line = null; while ((line = reader.readLine()) != null) { sb.append(line + "\n"); } is.close(); result = sb.toString(); } catch (Exception e) { Log.e("log_tag", "Error converting result " + e.toString()); } try { jArray = new JSONObject(result); } catch (JSONException e) { Log.e("log_tag", "Error parsing data " + e.toString()); } return jArray; } } In your MainActivity, make an object with the class JsonFunctions and pass the URL from where you want to get the data as an argument. For example: JSONObject jsonobject; jsonobject = JSONfunctions.getJSONfromURL("http://YOUR_DATABASE_URL"); And then finally read the JSON tags and store the values in an ArrayList. Later, show them in a ListView if you want.

using any server side programming languages such as php,jsp.if you want to access mySQL database you will need to create a web services in any server side programming language and call those web services from android app.

Best way to connect your Android App to MySQL Database isCreate Middle level communication layer with PHP or Any other technology ( webservice) and you can call that webservice with your app.Simple solution - you can easily find script from other developer communities like herehttps://stackoverflow.com/questions/6806015/android-mysql-connectionHope it might worksthanks

I believe that for these kinds of development, you can create an API to do the job. Unless, you need something else done? Did I get the question right? haha

Creating a Rest api or service is inbuilt the way to do it. Android in it supports sqlite and for mysql db connection u have to create apis to interact ....

we will need to connect Mysql database to an android app: First of all you should have a an online server where you can make your database. You can also use local host for this purpose Php Script that will run on server and fetch the data from MySql database And last but not least you will have an android app to display data from Mysql database after making proper connection. For more information visit : http://www.trustingeeks.com/connect-android-app-to-mysql-database/

You can connect the app with DB. Follow this link ->>http://www.androidhive.info/2012/05/how-to-connect-android-with-php-mysql/

A direct connection between android and MySql is not possible (as far as I know). To read/write data between android app and MySql DB you should have a web app the connects to MySql and provide the android app with an API to deal with the DB.