MySQL TLS Access

Use MySQL TLS Access to connect to a Mysql Server from your mobile and perform SQL queries. It is easy, you just have to provide the IP address of your MySQL server, the username and password of your account and you're connected.
MySQL TLS Access provides two query levels: Basic and Advanced. In the Basic Query level you can perform queries like Select
* from any table from your Databases. In Advanced query level you can perform different SQL queries like "Insert", "Delete", "Select from where" "Update", etc..

With an unencrypted connection between your mobile (Client) and the MySQL server, someone with access to the network could watch all your traffic and inspect the data being sent or received between Smartphone and server. MySQL supports secure (encrypted) connections between clients and the server using the TLS (Transport Layer Security) protocol.

MySQL TLS Access app provides a secure connection between your mobile and MySQL Server. In this case once the MySQL server has been correctly configured with security services, you must install in your Smartphone the Certification Authority (CA) certificate file used in your MySQL server.

Proceed as follows:1. Copy the CA Certificate file in the storage phone (e.g., “CACertificate.crt”)2. Navigate to Settings > Security> Credential Storage and select >Install from phone storage, select the file " CACertificate.crt" and install it.3. Verify that the CA Certificate file has been correctly installed. In order to verify Navigate to Settings > Security> Credential Storage >Trusted Credentials.

We provide the CACertificate.pem, SR_Certificate.pem and SR_PrivateKey.pem files that you need. Also we provide the CACertificate.crt (The CA certificate in crt format) that you have to install in your mobile. In this link you can download Certificates and Keys files: CERTIFICATES AND KEY FILES:https://drive.google.com/folderview?id=0B8xK-sIfZogWdEJqcmNrb0lkQlE&usp=sharing

To start MySQL Server with Security Services you can use Worbench administrator Tool." We offer a video and screenshots which is described as the process is carried out. In this link you can see the video and screenshots: MySQL SERVER SECURITY SETTINGS:https://drive.google.com/folderview?id=0B8xK-sIfZogWeDZ3dEh6QVl1WkE&usp=sharing

We also provide a video as the process to install the CAcertificate.crt file in the mobile is carried out:MOBILE SECURITY SETTINGS: https://drive.google.com/folderview?id=0B8xK-sIfZogWRzdKaXlLXzJvTE0&usp=sharing

Finally, you can download videos and snapshots about MySQL TLS AppMySQL TLS ACCESS VIDEOS:https://drive.google.com/folderview?id=0B8xK-sIfZogWQ083ZElJUHp5c1E&usp=sharing

You can found more information to configure MySQL Server with Security Services in this link:"“Building MySQL with Support for Secure Connections”:http://dev.mysql.com/doc/refman/5.7/en/building-with-secure-connection-support.html

The following issues have been detected:New OpenSSL versions has added protection for TLS clients by rejecting handshakes with DH (Diffie-hellman) parameters shorter than 768 bits. This problem can appear with MySQL server versions before 5.7.11 that can manage DH size to 512 bits. Some mobiles like Samsung Galaxy versions reject handshakes with MySQL server versions before 5.7.11.