Good morning all,
I am using c++ and also using wxWidget, In backend i m using MySql C API, i want to save user name and password in encrypted form inside the database,
when user will try to login,I will decrypt the data for authentication,
1-Is there any headerfiles in c++ who can handle encryption or decryption?
2-is there any functions in mysql who can save the data in encrypt form and decrypt the data when required?

Hi,

this is certainly one way of achieving a login solution. However, a more robust solution is store the encrypted password in the database and compare the encrypted password from your application with that in the database.

MySQL provides MD5() function which encrypts a string. MD5 is a one way hashing algorithm i.e. once hashed you can never get back your original string. If the password being passed in is also encrypted with MD5 and you compare the same string in the database with your passed in string. If they match you have a login.

It just means that when someone forgets their password you have to assign a new password for them, you cannot read their password from the database.

Reading up about MD5, as technology advances using brute force methods on every string will take less and less time, but for the majority of cases this is sufficient. Failing that there is another function called SHA and SHA2. MySQL 5.1 offers a full range of security functions:

MySQL :: MySQL 5.1 Reference Manual :: 11.13 Encryption and Compression Functions