B4J Question encrypt password for mysql PASSWORD function

[le_toubib]

hi all
i connect to a mysql db with a b4x <-> php <-> mysql

i encrypted the passwords columns using the mysql function PASSWORD(`column`)
while i can receive the row password in a post string and encrypt it in the SQL string inside the php b4 validation ,
but i would like to encrypt it in b4j b4 sending it to php ...

how to encrypt it in b4j .. which library to use and which protocol to fit with the mysql PASSWORD function?

 

[Erel]

I recommend you to switch to jRDC 2 instead of the PHP script. It will be more powerful and more secure.

Based on the MySQL documentation you shouldn't use PASSWORD: http://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html#function_password

You can use MD5 or SHA2.

You can implement these hash functions with the Encryption library.