Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Securing mysql password
Message
From
26/05/2012 01:37:18
Al Doman (Online)
M3 Enterprises Inc.
North Vancouver, British Columbia, Canada
 
 
To
25/05/2012 23:55:05
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
MySQL
Application:
Desktop
Miscellaneous
Thread ID:
01544489
Message ID:
01544490
Views:
60
This message has been marked as the solution to the initial question of the thread.
>Hi All,
>I'm using my vfp application to access mysql data on the internet via odbc driver. When I open my exe file using notepad++, its surprised me because I can see my MySql password.
>Really need help.

If you have your VFP project open, you can click on the menu Project...Project Info, there is an Encrypted checkbox option (see attached image). I don't know if it encrypts string literals, such as passwords, so it may not help in your case.

One thing you could do would be to encrypt your password using a function, say from Craig Boyd's library: http://www.sweetpotatosoftware.com/spsblog/2009/08/09/MajorVFPEncryptionUpdate.aspx . You would then decrypt it at runtime. If you do that, you'd have to store the encrypted value, and the encryption key, but it wouldn't be obvious what a cracker would have to do to get the password.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform