Cifrado en MySQL

Activado 23 Apr, 2012 Por Adolfo 350 Comentarios

Muchas veces queremos guardar datos en una base de datos MySQL de forma cifrada. Una forma muy eficiente es guardando el contenido con un hash tipo md5 o sha-1. Estos dos algoritmos permiten guardar los datos de forma cifrada y muy difícil de recuperar.

Podemos utilizar esta codificación de la siguiente manera (extraido del manual MySQL):

  1. CREATE TABLE md5_tbl (md5_val CHAR(32), ...);
  2. INSERT INTO md5_tbl (md5_val, ...) VALUES(MD5('abcdef'), ...);

El problema que ocurre en este caso es que nosotros tampoco podemos recuperar la información. Esto hace que sea un método muy útil para contraseñas. así la que nos introduce el usuario es cifrada y la podemos comparar con esta.

Recuperando datos cifrados

Puede ocurrir el caso en el que queramos mantener datos cifrados en la base de datos, pero, al mismo tiempo poder recuperarlos. Para ello utilizamos otro tipo de funciones que utilizan una clave externa para realizar la codificación del contenido del campo. Una que nos puede resultar muy útil es AES_ENCRYPT. Esta función nos permite cirar un contenido juntamente con la clave y posteriormente, con AES_DECRYPT y la clave recuperar el valor original.

Un ejemplo puede ser el siguiente:

  1. INSERT INTO t (col1, col2) VALUES (1, AES_ENCRYPT('valor original', 'clave'));
  2. SELECT col1, EAS_DECRYPT(col2, 'clave');

Hemos de tener en cuenta que para utilizar este cifrado la columna la hemos de definir como VARBINARY, y que normalmente con una longitud de 32 suele ser suficiente. En nuestro ejemplo la columna definida como varbinary sería col2.

Eperamos que os sea de utilidad este tipo de cifrado.

Etiquetas: 
Tecnología
MySQL

Comentarios

CoreyElada (no verificado)

Sáb, 13/04/2019 - 22:29

canadianpharmacyonl.com most reliable canadian pharmacies
canada online pharmacies http://canadianpharmacyonl.com/
drugs for sale deep web http://canadianpharmacyonl.com/#buy-viagra-online
cialis from canada
canadian pharmacy online 24

CoreyElada (no verificado)

Sáb, 13/04/2019 - 22:30

canadianpharmacyonl.com canada medications information
canadian online pharmacies legitimate http://canadianpharmacyonl.com/
online pharmacies tech school http://canadianpharmacyonl.com/#viagra-from-canada
is trust pharmacy in canada legitimate
canadian pharmaceuticals reviews

CoreyElada (no verificado)

Sáb, 13/04/2019 - 22:33

canadianorderpharmacy.com canadian prescription drugstore
drugs for sale in canada http://canadianorderpharmacy.com/
online canadian pharmacy http://canadianorderpharmacy.com/#viagra-levitra
canadian online pharmacies rated
canadian rx world pharmacy

CoreyElada (no verificado)

Sáb, 13/04/2019 - 22:39

canadianorderpharmacy.com canadian pharmaceuticals for usa sales
canada online pharmacies reviews http://canadianorderpharmacy.com/
canada drugs online http://canadianorderpharmacy.com/#tadalafil-5mg
canadian pharmacy uk delivery
pharmacy canada

CoreyElada (no verificado)

Sáb, 13/04/2019 - 22:49

ukcanadianpharmacy.com canada pharmaceuticals online
canadian drug store http://ukcanadianpharmacy.com/
drugstore online reviews http://ukcanadianpharmacy.com/#viagra-from-canada
canadian pharmacies without an rx
online pharmacies mexico

CoreyElada (no verificado)

Sáb, 13/04/2019 - 22:52

ukcanadianpharmacy.com canada vagra
drugs for sale online http://ukcanadianpharmacy.com/
canadian online pharmacies legal http://ukcanadianpharmacy.com/#tadalafil-20-mg
canadian government approved pharmacies
rx from canada

CoreyElada (no verificado)

Sáb, 13/04/2019 - 23:01

canadiantousapharmacy.com online pharmacies tech school
online canadian pharmacy http://canadiantousapharmacy.com/
northwest pharmacies http://canadiantousapharmacy.com/#viagra-uk
drugstore online reviews
canadian medications online

CoreyElada (no verificado)

Sáb, 13/04/2019 - 23:14

canadiantousapharmacy.com no 1 canadian pharcharmy online
canada online pharmacies http://canadiantousapharmacy.com/
viagra canadiense http://canadiantousapharmacy.com/#buy-generic-viagra
canada drugs online
pharmacy times

CoreyElada (no verificado)

Sáb, 13/04/2019 - 23:20

ukcanadianpharmacy.com pharmacy canada online prescriptions
canadianpharmacyusa24h is it legal http://ukcanadianpharmacy.com/
canadian rx world pharmacy http://ukcanadianpharmacy.com/#generic-for-viagra
canadian online pharmacies reviews
canada online pharmacies legitimate

CoreyElada (no verificado)

Sáb, 13/04/2019 - 23:21

ukcanadianpharmacy.com canadian prescriptions online
canada medications information http://ukcanadianpharmacy.com/
canadianpharmacyusa24h is it legal http://ukcanadianpharmacy.com/#buy-viagra-online
canada medication pharmacy
canadian pharcharmy online24

CoreyElada (no verificado)

Sáb, 13/04/2019 - 23:23

canadianorderpharmacy.com pharmacy
rx from canada http://canadianorderpharmacy.com/
canada medications cheap http://canadianorderpharmacy.com/#viagra-uk
trust pharmacy canadian
canadian cialis

CoreyElada (no verificado)

Sáb, 13/04/2019 - 23:27

ukcanadianpharmacy.com canada medications cheap
is trust pharmacy in canada legitimate http://ukcanadianpharmacy.com/
buy viagrow pro http://ukcanadianpharmacy.com/#viagra-generic
north west pharmacies canada
canada pharmacies

CoreyElada (no verificado)

Sáb, 13/04/2019 - 23:33

canadiantousapharmacy.com canadian pharmacy cialis
canadian drug store http://canadiantousapharmacy.com/
online pharmacies legitimate http://canadiantousapharmacy.com/#viagra-tablets-australia
canadian pharmaceuticals stocks
buy vistagra usa

CoreyElada (no verificado)

Sáb, 13/04/2019 - 23:42

ukcanadianpharmacy.com pharmacy
northwest pharmacies online http://ukcanadianpharmacy.com/
canadian discount pharmacies in ocala fl http://ukcanadianpharmacy.com/#viagra-20mg
canadian online pharmacies legitimate
canadian pharmacycanadian pharmacy

CoreyElada (no verificado)

Sáb, 13/04/2019 - 23:46

canadianpharmacyes.com the best canadian online pharmacies
canadian online pharmacies http://canadianpharmacyes.com/
canadian pharmaceuticals online http://canadianpharmacyes.com/#viagra-generic
best canadian pharmacies online
trust pharmacy of canada

CoreyElada (no verificado)

Sáb, 13/04/2019 - 23:58

canadiantousapharmacy.com canadian pharmacy cialis
pharmacy canada plus http://canadiantousapharmacy.com/
canadian pharmacy online 24 http://canadiantousapharmacy.com/#viagra-generic
canadian pharcharmy online
buy viagra now

CoreyElada (no verificado)

Dom, 14/04/2019 - 00:10

canadianpharmacyonl.com good canadian online pharmacies
canadian pharmacies shipping to usa http://canadianpharmacyonl.com/
canadian drugs http://canadianpharmacyonl.com/#buy-viagra
rx from canada
canadian medications pharmacy

CoreyElada (no verificado)

Dom, 14/04/2019 - 00:18

canadiantousapharmacy.com canadian pharmacy cialis
viagra canadiense http://canadiantousapharmacy.com/
canadian medications http://canadiantousapharmacy.com/#viagra-20mg
canada drugs online
pharmacy times

CoreyElada (no verificado)

Dom, 14/04/2019 - 00:23

canadiantousapharmacy.com online pharmacy
canadian pharmacy viagra brand http://canadiantousapharmacy.com/
trusted pharmacy canada scam http://canadiantousapharmacy.com/#viagra-tablets-australia
pharmacy canada plus
canadian mail order pharmacies

CoreyElada (no verificado)

Dom, 14/04/2019 - 00:30

canadianpharmacyonl.com canada online pharmacies for men
canadian pharmaceuticals for usa sales http://canadianpharmacyonl.com/
global pharmacy canada http://canadianpharmacyonl.com/#viagra-levitra
canada online pharmacy
pharmacy

CoreyElada (no verificado)

Dom, 14/04/2019 - 00:38

canadianorderpharmacy.com trust pharmacy canada
drugs for sale usa http://canadianorderpharmacy.com/
pharmacy canada plus http://canadianorderpharmacy.com/#viagra-generic
trust pharmacy canada reviews
drugstore online shopping

CoreyElada (no verificado)

Dom, 14/04/2019 - 00:42

canadiantousapharmacy.com canadian pharmacies stendra
canada pharmaceuticals online http://canadiantousapharmacy.com/
online pharmacies of canada http://canadiantousapharmacy.com/#viagra-from-canada
no 1 canadian pharcharmy online
canada medications buy

CoreyElada (no verificado)

Dom, 14/04/2019 - 01:08

canadianorderpharmacy.com canada drug pharmacy
canadian online pharmacies rated http://canadianorderpharmacy.com/
canada medications information http://canadianorderpharmacy.com/#low-cost-viagra-20mg
trust pharmacy canada reviews
drugstore online shopping

CoreyElada (no verificado)

Dom, 14/04/2019 - 01:17

canadiantousapharmacy.com best canadian mail order pharmacies
canadian rx world pharmacy http://canadiantousapharmacy.com/
buy viagra 25mg http://canadiantousapharmacy.com/#low-cost-viagra-20mg
online canadian pharmacies
canadian online pharmacy

CoreyElada (no verificado)

Dom, 14/04/2019 - 01:28

canadianpharmacyonl.com canadian prescriptions online serc 24 mg
are canadian online pharmacies safe http://canadianpharmacyonl.com/
canadian prescriptions online serc 24 mg http://canadianpharmacyonl.com/#buy-viagra
are canadian online pharmacies safe
canadian online pharmacies rated

CoreyElada (no verificado)

Dom, 14/04/2019 - 01:41

canadianpharmacyonl.com canadian medications
trusted pharmacy canada scam http://canadianpharmacyonl.com/
canadian prescriptions online http://canadianpharmacyonl.com/#buy-viagra-online
prescriptions from canada without
trust pharmacy canada

CoreyElada (no verificado)

Dom, 14/04/2019 - 01:52

canadiantousapharmacy.com northwest pharmacy canada
aarp recommended canadian pharmacies http://canadiantousapharmacy.com/
prescriptions from canada without http://canadiantousapharmacy.com/#viagra-from-canada
global pharmacy canada
canada online pharmacies for men

CoreyElada (no verificado)

Dom, 14/04/2019 - 02:06

canadianorderpharmacy.com canadian pharmaceuticals for usa sales
canada medication cost http://canadianorderpharmacy.com/
trusted pharmacy canada http://canadianorderpharmacy.com/#buy-viagra
canada medications cheap
no 1 canadian pharcharmy online

CoreyElada (no verificado)

Dom, 14/04/2019 - 02:12

canadiantousapharmacy.com canadian online pharmacy
northwest pharmacies mail order http://canadiantousapharmacy.com/
canadian pharmacies online prescriptions http://canadiantousapharmacy.com/#tadalafil-5mg
canadian pharmacies online prescriptions
candida viagra

CoreyElada (no verificado)

Dom, 14/04/2019 - 02:13

ukcanadianpharmacy.com drugstore online reviews
canada online pharmacies reviews http://ukcanadianpharmacy.com/
reputable canadian prescriptions online http://ukcanadianpharmacy.com/#low-cost-viagra-20mg
drugs for sale online
canadian pharmacy viagra

CoreyElada (no verificado)

Dom, 14/04/2019 - 02:15

canadianpharmacyonl.com buy viagrow
canadian pharmacy online 24 http://canadianpharmacyonl.com/
canada medication list http://canadianpharmacyonl.com/#viagra-generic
online pharmacy
canada drugs

CoreyElada (no verificado)

Dom, 14/04/2019 - 02:20

canadiantousapharmacy.com canadian prescription drugstore
canada online pharmacies reviews http://canadiantousapharmacy.com/
rx from canada http://canadiantousapharmacy.com/#generic-for-viagra
online canadian pharmacies
canadian online pharmacy

CoreyElada (no verificado)

Dom, 14/04/2019 - 03:04

canadianorderpharmacy.com canada drugs
trust pharmacy canada reviews http://canadianorderpharmacy.com/
online canadian pharmacies http://canadianorderpharmacy.com/#viagra-levitra
canadian medications 247
pharmacy canada plus

CoreyElada (no verificado)

Dom, 14/04/2019 - 03:07

ukcanadianpharmacy.com canadian pharmacy world
canadian cialis http://ukcanadianpharmacy.com/
canadian online pharmacy http://ukcanadianpharmacy.com/#discount-viagra
canadian prescriptions online serc 24 mg
drugstore online india

CoreyElada (no verificado)

Dom, 14/04/2019 - 03:12

canadianpharmacyes.com viagra canadiense
pharmacy near me http://canadianpharmacyes.com/
canada medication prices http://canadianpharmacyes.com/#buy-viagra
canada drug pharmacy
canada online pharmacies

CoreyElada (no verificado)

Dom, 14/04/2019 - 03:18

ukcanadianpharmacy.com canadian discount pharmacies in ocala fl
best canadian mail order pharmacies http://ukcanadianpharmacy.com/
prescription drugs without prior prescription http://ukcanadianpharmacy.com/#buy-generic-viagra
canadian drugstore
canadian discount pharmacies in canada

CoreyElada (no verificado)

Dom, 14/04/2019 - 03:26

ukcanadianpharmacy.com canada online pharmacies medication
canadian pharmaceuticals stocks http://ukcanadianpharmacy.com/
pharmacy near me http://ukcanadianpharmacy.com/#discount-viagra
canadian pharmacies stendra
pharmacy onesource

CoreyElada (no verificado)

Dom, 14/04/2019 - 03:42

canadianpharmacyonl.com canadian pharmacy online 24
canadian pharmacy viagra brand http://canadianpharmacyonl.com/
canadianpharmacy http://canadianpharmacyonl.com/#viagra-20mg
canadian drugs
canada viagra

CoreyElada (no verificado)

Dom, 14/04/2019 - 03:55

canadiantousapharmacy.com canadian discount pharmacies in ocala fl
canadian online pharmacies rated http://canadiantousapharmacy.com/
canadian pharmacycanadian pharmacy http://canadiantousapharmacy.com/#viagra-5mg
canadian pharmacy world
canada online pharmacies medication

CoreyElada (no verificado)

Dom, 14/04/2019 - 03:58

ukcanadianpharmacy.com is trust pharmacy in canada legitimate
canada viagra http://ukcanadianpharmacy.com/
canadian pharmacy no prescription http://ukcanadianpharmacy.com/#tadalafil-5mg
buy viagra 25mg
buy viagra usa

CoreyElada (no verificado)

Dom, 14/04/2019 - 04:00

canadianpharmacyes.com canadian pharmaceuticals
canadian mail order pharmacies http://canadianpharmacyes.com/
viagra canadiense http://canadianpharmacyes.com/#buy-viagra
canada medication cost
buy viagra 25mg

CoreyElada (no verificado)

Dom, 14/04/2019 - 04:00

ukcanadianpharmacy.com canadian drug
canadian medications list http://ukcanadianpharmacy.com/
cialis from canada http://ukcanadianpharmacy.com/#buy-viagra-online
canada online pharmacies reviews
buy viagrow pro

CoreyElada (no verificado)

Dom, 14/04/2019 - 04:05

canadiantousapharmacy.com canadian pharmacys
buy viagra 25mg http://canadiantousapharmacy.com/
pharmacy canada 24 http://canadiantousapharmacy.com/#viagra-tablets-australia
canadian pharmacies that are legit
canadian discount pharmacies in ocala fl

CoreyElada (no verificado)

Dom, 14/04/2019 - 04:12

ukcanadianpharmacy.com online pharmacies legitimate
drugs for sale online http://ukcanadianpharmacy.com/
drugstore online reviews http://ukcanadianpharmacy.com/#viagra-levitra
canada online pharmacies reviews
buy viagrow pro

CoreyElada (no verificado)

Dom, 14/04/2019 - 04:21

canadiantousapharmacy.com canadian pharmacies stendra
canada online pharmacies medication http://canadiantousapharmacy.com/
canadian government approved pharmacies http://canadiantousapharmacy.com/#viagra-levitra
drugs for sale on internet
canadian online pharmacies legal

CoreyElada (no verificado)

Dom, 14/04/2019 - 04:52

canadianpharmacyonl.com canada pharmacies online prescriptions
canadian drug store http://canadianpharmacyonl.com/
canadian pharmaceuticals nafta http://canadianpharmacyonl.com/#low-cost-viagra-20mg
canada medication
canada rx

CoreyElada (no verificado)

Dom, 14/04/2019 - 04:57

canadianpharmacyonl.com drugs for sale online
canadian cialis http://canadianpharmacyonl.com/
buy vistagra online safe http://canadianpharmacyonl.com/#viagra-5-mg
canadian pharmacycanadian pharmacy
trusted pharmacy canada scam

CoreyElada (no verificado)

Dom, 14/04/2019 - 04:57

canadianpharmacyonl.com canadian medications, liraglutide
drugstore online shopping http://canadianpharmacyonl.com/
online pharmacies http://canadianpharmacyonl.com/#viagra-uk
pharmacy near me
canadian pharmacy uk delivery

CoreyElada (no verificado)

Dom, 14/04/2019 - 05:01

ukcanadianpharmacy.com canada drug
canada drug http://ukcanadianpharmacy.com/
good canadian online pharmacies http://ukcanadianpharmacy.com/#tadalafil-20-mg
canadian pharmacies without an rx
online pharmacies mexico

CoreyElada (no verificado)

Dom, 14/04/2019 - 05:03

canadiantousapharmacy.com online canadian pharmacy
prescription drugs without prior prescription http://canadiantousapharmacy.com/
canadianpharmacyusa24h is it legal http://canadiantousapharmacy.com/#generic-for-viagra
online pharmacies in usa
drugs for sale

Páginas

Añadir nuevo comentario

Más información sobre los formatos de texto

Filtered HTML

  • Las direcciones de las páginas web y las de correo se convierten en enlaces automáticamente.
  • Etiquetas HTML permitidas: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Saltos automáticos de líneas y de párrafos.

Plain text

  • No se permiten etiquetas HTML.
  • Las direcciones de las páginas web y las de correo se convierten en enlaces automáticamente.
  • Saltos automáticos de líneas y de párrafos.
CAPTCHA
Esta pregunta se realiza para comprobar que se trata de un humano y prevenir los accesos automatizados para publicar spam.