About this app

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 App
MySQL 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

MySQL TLS Access (v3.0) avoids using TLS handshakes cipher suites based on DH (Diffie-hellman) keys.
New OpenSSL versions has added protection for TLS clients by rejecting handshakes with 64 bit DH (Diffie-hellman) key length.
In this way MySQL TLS Access (v3.0) can connect with MySQL server versions before 5.7.11 using TLS.

App Web Site: https://sites.google.com/site/mysqltlsaccessapp

New features

This new version incorporates the latest JDBC MySQL driver (mysql-connector-java-5.1.45-bin.jar).
This version is compatible with old versions of MySQL Server in which the default family Diffie helman
generates a short key. For this we force the cipher suite to TLS_RSA_WITH_AES_128_CBC_SHA.
This version generates a log file in case of error connection to MySQL server.
Bugs fixed