Shulou(Shulou.com)05/31 Report--

MySQL database how to achieve two-way encryption, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

Two-way encryption

Let's start with the simplest encryption: two-way encryption. In this case, a piece of data is encrypted by a key and can only be decrypted by people who know the key. MySQL has two functions to support this type of encryption, called ENCODE () and DECODE (). Here is a simple example:

Mysql > INSERT INTO users (username, password)

VALUES (joe, ENCODE (guessme, abracadabra))

Query OK, 1 row affected (0.14 sec)

Where the password of Joe is guessme, which is encrypted through the key abracadabra. Note that the result of the encryption is a binary string, as follows:

Mysql > SELECT * FROM users WHERE username=joe

+-+ +

| | username | password |

+-+ +

| | joe | email? | |

+-+ +

1 row in set (0.02 sec)

The abracadabra key is critical for restoring to the original string. This key must be passed to the DECODE () function to get the original, unencrypted password. Here's how to use it:

Mysql > SELECT DECODE (password, abracadabra)

FROM users WHERE username=joe

+-+

| | DECODE (password, abracadabra) | |

+-+

| | guessme |

+-+

1 row in set (0.00 sec)

It should be easy to see how it works in Web applications-when verifying a user's login, DECODE () uses a site-specific key to unlock the password stored in and compares it with what the user typed. Assuming that you use PHP as your scripting language, you can query like this:

Undefined undefined

$query = "SELECT COUNT (*) FROM users WHERE

Username=$inputUser AND DECODE (password

Abracadabra) = $inputPass ";? >

Note: although the ENCODE () and DECODE () functions meet most of the requirements, there are times when you want to use stronger encryption. In this case, you can use the AES_ENCRYPT () and AES_DECRYPT () functions, which work the same way, but with higher encryption strength.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.