Androidapp and MySQL connection Didn't Work Connection.Open

Android device can't connect to mysql in localhost

I have solved adding this on manifest...

    android:usesCleartextTraffic="true"

Xamarin, Android-MySQL connection error

I think first of all, you should check your connection string, in c# interactive you first need to initialize variable to use them then. You can't use variables from your code, cause c# interactive doesn't know them.
You should try this in c# interactive:

 con = new MySqlConnection(<your Connection string>);
 con.Open()

Why don't connect android to database directly?

There are a number of reasons.

1. Security- If the user has direct access, they can get anything from your database. Plus they will have a password into your database. As a result, if the SQL server you are using has a flaw, then they can exploit it. Also, if your permissions are set up wrong, the could wipe your database.
2. Speed- If the users frequently use large queries, then it can bog down your system quickly and needlessly. If you go through a web interface, you can throttle it.
3. Accessibility- Web queries are supported by almost everything. It requires special clients to access SQL databases directly.

But if you trust your users completely, have the right libraries/drivers, then you could allow direct querying, and it might even be a bit quicker.

---

Related Topics