Why not directly connect to databases such as mysql or SQL Server on android or ios?

Why not directly connect to databases such as mysql or SQL Server on android or ios?

Many of you have the idea of directly connecting to these databases. If you want to connect directly after I talk about the following two questions, then I cannot

A database is the most important and vulnerable part of a server. It is also the most sensitive part.

If direct connection causes the following problems:

1. security issues: your account and password for connecting to the database are exposed to the client, which is easy to be caught. This information is easily available for both android decompilation and packet capture, and if you need direct connection, the database is bound to listen to 0.0.0.0, so that anyone can try your database. What a terrible thing

2. Performance problems. We know that the concurrent connection to a database is very low. The default configuration of mysql is only 100, and the database is directly connected. As a result, no cache can be used, such as memcache,

There should be other questions. Let's add them.

The original database used by the ssh2 project is sqlserver, And I want to change it to mysql later.

Check the database connection configurations, such as DriverName and URL.

Redeploy and restart the Web server. If there is no problem with the configuration, it is some minor issues such as the overall deployment, operation, and cache. In short, after you find out the problem, you may say it bluntly, then I have to knock on my head, hey. This cannot help you. Check it by yourself.

Adopt the post.

How can I run SQL Server-based database programs with MySQL support?

1. The database connection part of the program must be modified.
2. Some programs with inconsistent data types should also be adjusted.
3. If the database structure is different, the program must be modified accordingly.