Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Encryption in SQL

 
Ramesh Pramuditha Rathnayake
Ranch Hand
Posts: 178
2
Java MySQL Database Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have some questions....

Is there a way to decrypt MySQL password..? Or any software have been made..? (Password get from " Select Password('password') ")

I think that, it is possible to decrypt the password get from that command. Can we get more secure password to SQL...? Then how can we get it..?

 
Ulf Dittmer
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Passwords are generalls stored hashed (or digested), not encrypted. That means it is impossible to recover the password, as there is no decrpytion.

What is the underlying problem you're trying to solve?
 
Ramesh Pramuditha Rathnayake
Ranch Hand
Posts: 178
2
Java MySQL Database Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I want to know a better way to make a password. Is there any way to do it..?

Thank you for the reply...!
 
Ulf Dittmer
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What do you mean by "make a password"? And in which way do you want to improve on it?
 
Ramesh Pramuditha Rathnayake
Ranch Hand
Posts: 178
2
Java MySQL Database Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
make password means, create a password like in Select Password() command..

I have to know a way to improve its privacy. That means, ensure no one could break it..
 
Ulf Dittmer
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have no idea what "Select Password() " does, and -I suspect- neither do a lot of other folks. So we can't say how that might be improved. If you search for "choosing a strong password" or some such phrase on Google, I'm sure you'll get lots of results.
 
Ramesh Pramuditha Rathnayake
Ranch Hand
Posts: 178
2
Java MySQL Database Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you for the reply..
 
Supun Lakshan Dissanayake
Ranch Hand
Posts: 135
Android Java PHP
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ulf Dittmer wrote:I have no idea what "Select Password() " does


imagine you create a table in mysql database and you store it for login data.
if somebody knows mysql commands he can read login data in previously mentioned table.
Isn't a security issue??

so you MUST encrypt secure data you insert into your table.

SELECT PASSWORD(123); command encrypts 123 into unrecognizable(you can read it but doesn't make any sense) string. So even you can't extract 123 from encrypted data.
 
Campbell Ritchie
Sheriff
Pie
Posts: 50196
79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The password() function does not (I think) encrypt anything. What it does is to work out a hash, rather like an SHA. It gives the hash of the password string, but it is not possible to reconstruct the password from that hash.

[Add: That sounds just what what Ulf said nearly two weeks ago.]
 
Ramesh Pramuditha Rathnayake
Ranch Hand
Posts: 178
2
Java MySQL Database Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Campbell Ritchie wrote:The password() function does not (I think) encrypt anything. What it does is to work out a hash, rather like an SHA. It gives the hash of the password string, but it is not possible to reconstruct the password from that hash.

[Add: That sounds just what what Ulf said nearly two weeks ago.]


What does mean by hash of the password..? Can we get hash in manual way..?
 
Campbell Ritchie
Sheriff
Pie
Posts: 50196
79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It is a sort of hash code. You can calculate it manually if you can find out the algorithm used.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic