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)

Dom, 14/04/2019 - 13:50

canadiantousapharmacy.com canadian online pharmacies rated
aarp recommended canadian online pharmacies http://canadiantousapharmacy.com/
canada medications information http://canadiantousapharmacy.com/#viagra-tablets-australia
northwest pharmacies in canada
canada medication cost

CoreyElada (no verificado)

Dom, 14/04/2019 - 13:58

canadiantousapharmacy.com northwest pharmacies in canada
canadian pharmaceuticals companies http://canadiantousapharmacy.com/
rx from canada http://canadiantousapharmacy.com/#viagra-tablets-australia
aarp recommended canadian online pharmacies
canadian pharmacy

CoreyElada (no verificado)

Dom, 14/04/2019 - 14:31

canadiantousapharmacy.com Northwest Pharmacy
pharmacy onesource http://canadiantousapharmacy.com/
canadian pharmacies stendra http://canadiantousapharmacy.com/#discount-viagra
online pharmacies in usa
drugs for sale

CoreyElada (no verificado)

Dom, 14/04/2019 - 14:32

canadianorderpharmacy.com drugs for sale online
canada pharmacies online prescriptions http://canadianorderpharmacy.com/
canadian pharmacy meds http://canadianorderpharmacy.com/#buy-generic-viagra
canadian pharmaceuticals reviews
online pharmacies in usa

CoreyElada (no verificado)

Dom, 14/04/2019 - 14:33

canadianpharmacyes.com canada pharmaceuticals online
canada online pharmacies medication http://canadianpharmacyes.com/
drugs for sale in canada http://canadianpharmacyes.com/#viagra-generic
drugstore online shopping reviews
canadian pharmaceuticals

CoreyElada (no verificado)

Dom, 14/04/2019 - 14:35

canadiantousapharmacy.com northwest pharmacies
canadian pharmaceuticals online http://canadiantousapharmacy.com/
canadian pharmacies that are legit http://canadiantousapharmacy.com/#viagra-levitra
drugs for sale in canada
reputable canadian prescriptions online

CoreyElada (no verificado)

Dom, 14/04/2019 - 14:44

canadianpharmacyonl.com canadian discount pharmacies in ocala fl
cialis from canada http://canadianpharmacyonl.com/
trust pharmacy canada reviews http://canadianpharmacyonl.com/#buy-viagra
pharmacy near me
canadian pharmacy uk delivery

CoreyElada (no verificado)

Dom, 14/04/2019 - 14:53

canadiantousapharmacy.com northwest pharmacies mail order
canadian pharmaceuticals http://canadiantousapharmacy.com/
canada medication prices http://canadiantousapharmacy.com/#buy-viagra-online
order canadian prescriptions online
pharmacy canada reviews

CoreyElada (no verificado)

Dom, 14/04/2019 - 14:59

canadianpharmacyes.com online pharmacies tech school
rx from canada http://canadianpharmacyes.com/
trust pharmacy canada http://canadianpharmacyes.com/#viagra-generic
trusted pharmacy canada
canadian government approved pharmacies

CoreyElada (no verificado)

Dom, 14/04/2019 - 15:09

canadianpharmacyes.com canadian pharmacy uk delivery
online pharmacy canada http://canadianpharmacyes.com/
canadianpharmacy http://canadianpharmacyes.com/#viagra-5mg
canadian medications online
canadian online pharmacies legitimate

CoreyElada (no verificado)

Dom, 14/04/2019 - 15:33

ukcanadianpharmacy.com drugstore online india
canada online pharmacies for men http://ukcanadianpharmacy.com/
viagra canadiense http://ukcanadianpharmacy.com/#low-cost-viagra-20mg
canada online pharmacies reviews
buy viagrow pro

CoreyElada (no verificado)

Dom, 14/04/2019 - 15:33

ukcanadianpharmacy.com canadian pharmacy king
are canadian online pharmacies safe http://ukcanadianpharmacy.com/
canada medications buy http://ukcanadianpharmacy.com/#viagra-20mg
canadian pharmaceuticals
pharmacy near me

CoreyElada (no verificado)

Dom, 14/04/2019 - 15:38

canadianpharmacyonl.com prescription drugs without prior prescription
canadian medications, liraglutide http://canadianpharmacyonl.com/
canadian medications 247 http://canadianpharmacyonl.com/#viagra-uk
canada pharmacies
northwestpharmacy

CoreyElada (no verificado)

Dom, 14/04/2019 - 15:45

canadianpharmacyes.com canadian medications 247
online pharmacies legitimate http://canadianpharmacyes.com/
pharmacy onesource http://canadianpharmacyes.com/#buy-viagra
buy vistagra usa
canada medication pharmacy

CoreyElada (no verificado)

Dom, 14/04/2019 - 15:54

canadianpharmacyes.com canadian pharmacy no prescription
canada online pharmacies surrey http://canadianpharmacyes.com/
canadian pharmacys http://canadianpharmacyes.com/#tadalafil-5mg
canadian medications online
canadian online pharmacies legitimate

CoreyElada (no verificado)

Dom, 14/04/2019 - 16:08

canadianorderpharmacy.com canada rx
trusted pharmacy canada scam http://canadianorderpharmacy.com/
buy viagra online usa http://canadianorderpharmacy.com/#tadalafil-20-mg
canadian pharmaceuticals companies
canadian pharcharmy online

CoreyElada (no verificado)

Dom, 14/04/2019 - 16:23

canadianorderpharmacy.com northwest pharmacy canada
canada pharmacies online prescriptions http://canadianorderpharmacy.com/
how safe are canadian online pharmacies http://canadianorderpharmacy.com/#buy-generic-viagra
canadian medications pharmacy
online canadian pharmacies

CoreyElada (no verificado)

Dom, 14/04/2019 - 16:28

ukcanadianpharmacy.com aarp recommended canadian online pharmacies
canadian pharmaceuticals online http://ukcanadianpharmacy.com/
canadian pharmacy http://ukcanadianpharmacy.com/#generic-for-viagra
best canadian mail order pharmacies
online canadian pharmacy

CoreyElada (no verificado)

Dom, 14/04/2019 - 16:29

ukcanadianpharmacy.com online pharmacies of canada
drugs for sale deep web http://ukcanadianpharmacy.com/
canadian pharmaceuticals online http://ukcanadianpharmacy.com/#viagra-20mg
canadian pharmacy cialis
canada online pharmacy

CoreyElada (no verificado)

Dom, 14/04/2019 - 16:29

canadiantousapharmacy.com canadian pharmaceuticals
canadian online pharmacies rated http://canadiantousapharmacy.com/
canada medications information http://canadiantousapharmacy.com/#tadalafil-5mg
canadianpharmacyusa24h
drugs for sale usa

CoreyElada (no verificado)

Dom, 14/04/2019 - 16:33

canadianpharmacyonl.com candida viagra
buy viagra usa http://canadianpharmacyonl.com/
the best canadian online pharmacies http://canadianpharmacyonl.com/#viagra-5-mg
canadian pharmacys
trust pharmacy canadian

CoreyElada (no verificado)

Dom, 14/04/2019 - 16:40

canadianpharmacyes.com canadian pharcharmy online
canadianpharmacy http://canadianpharmacyes.com/
canadian online pharmacies reviews http://canadianpharmacyes.com/#tadalafil-5mg
buy vistagra online safe
canadian pharmaceuticals online

CoreyElada (no verificado)

Dom, 14/04/2019 - 16:48

canadianpharmacyes.com canada online pharmacies surrey
cialis from canada http://canadianpharmacyes.com/
online pharmacy http://canadianpharmacyes.com/#viagra-5mg
buy viagra now
online pharmacy canada

CoreyElada (no verificado)

Dom, 14/04/2019 - 16:51

canadianpharmacyonl.com canada medication prices
canadianpharmacyusa24h is it legal http://canadianpharmacyonl.com/
canadian pharmacies shipping to usa http://canadianpharmacyonl.com/#tadalafil-20-mg
good canadian online pharmacies
online pharmacies

CoreyElada (no verificado)

Dom, 14/04/2019 - 17:03

canadiantousapharmacy.com canada medication cost
canadian pharmacy online 24 http://canadiantousapharmacy.com/
online canadian discount pharmacies http://canadiantousapharmacy.com/#buy-generic-viagra
canadian pharmacies online prescriptions
candida viagra

CoreyElada (no verificado)

Dom, 14/04/2019 - 17:14

ukcanadianpharmacy.com Northwest Pharmacy
is trust pharmacy in canada legitimate http://ukcanadianpharmacy.com/
buy vistagra online safe http://ukcanadianpharmacy.com/#viagra-uk
canada online pharmacies
online pharmacy

CoreyElada (no verificado)

Dom, 14/04/2019 - 17:18

canadianorderpharmacy.com canadian online pharmacies legal
pharmacy canada http://canadianorderpharmacy.com/
canadian online pharmacy http://canadianorderpharmacy.com/#discount-viagra
northwest pharmacies
drugstore online

CoreyElada (no verificado)

Dom, 14/04/2019 - 17:19

canadiantousapharmacy.com canadianpharmacy
canadian drug http://canadiantousapharmacy.com/
rx from canada http://canadiantousapharmacy.com/#viagra-generic
canadian online pharmacies
best canadian pharmacies online

CoreyElada (no verificado)

Dom, 14/04/2019 - 17:19

canadianpharmacyonl.com online pharmacies
canadian medications online http://canadianpharmacyonl.com/
canadian pharmacy king http://canadianpharmacyonl.com/#low-cost-viagra-20mg
northwest pharmacy canada
northwest pharmacies

CoreyElada (no verificado)

Dom, 14/04/2019 - 17:21

canadianorderpharmacy.com northwest pharmacies mail order
is trust pharmacy in canada legitimate http://canadianorderpharmacy.com/
most reliable canadian online pharmacies http://canadianorderpharmacy.com/#generic-for-viagra
canadian medications pharmacy
online canadian pharmacies

CoreyElada (no verificado)

Dom, 14/04/2019 - 17:24

canadianpharmacyonl.com canadian pharmacy no prescription
canadian pharmacies online prescriptions http://canadianpharmacyonl.com/
online drug store http://canadianpharmacyonl.com/#buy-viagra-online
north west pharmacy canada
online pharmacies india

CoreyElada (no verificado)

Dom, 14/04/2019 - 17:30

canadianorderpharmacy.com drugs for sale in uk
canada drugs online http://canadianorderpharmacy.com/
discount canadian pharmacies http://canadianorderpharmacy.com/#viagra-generic
canadian online pharmacies rated
canadian rx world pharmacy

CoreyElada (no verificado)

Dom, 14/04/2019 - 17:38

canadiantousapharmacy.com online canadian discount pharmacies
canadian pharmaceuticals stocks http://canadiantousapharmacy.com/
prescriptions from canada without http://canadiantousapharmacy.com/#viagra-20-mg
canadian pharmacies online prescriptions
candida viagra

CoreyElada (no verificado)

Dom, 14/04/2019 - 17:42

canadianorderpharmacy.com cialis canadian pharmacy
drugstore online india http://canadianorderpharmacy.com/
online pharmacies india http://canadianorderpharmacy.com/#viagra-5-mg
trust pharmacy canada
aarp recommended canadian online pharmacies

CoreyElada (no verificado)

Dom, 14/04/2019 - 17:53

canadianpharmacyonl.com canadian government approved pharmacies
canada medication http://canadianpharmacyonl.com/
online pharmacies india http://canadianpharmacyonl.com/#tadalafil-5mg
drugstore online india
canadian pharmacies

CoreyElada (no verificado)

Dom, 14/04/2019 - 18:11

canadianpharmacyonl.com drugstore online shopping
canadian pharmacycanadian pharmacy http://canadianpharmacyonl.com/
canadian pharmaceuticals reviews http://canadianpharmacyonl.com/#low-cost-viagra-20mg
canadian viagra
online canadian discount pharmacies

CoreyElada (no verificado)

Dom, 14/04/2019 - 18:12

canadianpharmacyonl.com order canadian prescriptions online
canada medication http://canadianpharmacyonl.com/
Canadian Pharmacy USA http://canadianpharmacyonl.com/#viagra-20mg
canadian pharmacy viagra
Canadian Pharmacy USA

CoreyElada (no verificado)

Dom, 14/04/2019 - 18:15

canadiantousapharmacy.com canada medication
canada drugs http://canadiantousapharmacy.com/
canadian pharmacy no prescription http://canadiantousapharmacy.com/#viagra-uk
canadian rx world pharmacy
canada pharmacies account

CoreyElada (no verificado)

Dom, 14/04/2019 - 18:30

canadiantousapharmacy.com canadian pharmacy
canadian pharmacy viagra brand http://canadiantousapharmacy.com/
canada medication list http://canadiantousapharmacy.com/#viagra-from-canada
canadian pharmacy no prescription
northwest pharmacies online

CoreyElada (no verificado)

Dom, 14/04/2019 - 18:44

canadianpharmacyonl.com canadian pharcharmy online24
drugstore online reviews http://canadianpharmacyonl.com/
canadian pharmacys http://canadianpharmacyonl.com/#buy-generic-viagra
pharmacy onesource
canada pharmacies online prescriptions

CoreyElada (no verificado)

Dom, 14/04/2019 - 18:57

canadianpharmacyonl.com online canadian pharmacies
canadian prescriptions online serc 24 mg http://canadianpharmacyonl.com/
canadian online pharmacies rated http://canadianpharmacyonl.com/#viagra-20-mg
prescriptions from canada without
trust pharmacy canada

CoreyElada (no verificado)

Dom, 14/04/2019 - 19:04

canadianorderpharmacy.com viagra canadiense
are canadian online pharmacies safe http://canadianorderpharmacy.com/
canadian government approved pharmacies http://canadianorderpharmacy.com/#viagra-uk
canadian prescription drugstore
global pharmacy canada

CoreyElada (no verificado)

Dom, 14/04/2019 - 19:04

ukcanadianpharmacy.com canadian discount pharmacies in canada
top rated canadian pharmacies online http://ukcanadianpharmacy.com/
pharmacy canada best http://ukcanadianpharmacy.com/#viagra-5mg
canadian prescriptions online serc 24 mg
drugstore online india

CoreyElada (no verificado)

Dom, 14/04/2019 - 19:09

canadiantousapharmacy.com canadian mail order pharmacies
pharmacy canada reviews http://canadiantousapharmacy.com/
order canadian prescriptions online http://canadiantousapharmacy.com/#discount-viagra
drugstore online shopping
canada drug pharmacy

CoreyElada (no verificado)

Dom, 14/04/2019 - 19:14

canadiantousapharmacy.com canadian discount pharmacies in canada
aarp recommended canadian online pharmacies http://canadiantousapharmacy.com/
online canadian pharmacies http://canadiantousapharmacy.com/#viagra-5-mg
pharmacy canada plus
canadian mail order pharmacies

CoreyElada (no verificado)

Dom, 14/04/2019 - 19:50

canadianorderpharmacy.com trusted pharmacy canada scam
canada online pharmacies medication http://canadianorderpharmacy.com/
drugs for sale online http://canadianorderpharmacy.com/#buy-viagra
canada medications information
canadian pharmacies shipping to usa

CoreyElada (no verificado)

Dom, 14/04/2019 - 19:52

canadianpharmacyonl.com canadian pharmacy uk delivery
pharmacy canada 24 http://canadianpharmacyonl.com/
most reliable canadian online pharmacies http://canadianpharmacyonl.com/#generic-for-viagra
prescriptions from canada without
trust pharmacy canada

CoreyElada (no verificado)

Dom, 14/04/2019 - 19:56

canadianpharmacyonl.com buy vistagra online safe
online pharmacy [url=http://canadianpharmacyonl.com/#]http://canadianpharmacyonl.com/[/url]
canadian online pharmacies rated http://canadianpharmacyonl.com/#buy-viagra
buy viagrow
canada medications cheap

CoreyElada (no verificado)

Dom, 14/04/2019 - 20:10

canadianpharmacyonl.com buy viagra usa
order canadian prescriptions online http://canadianpharmacyonl.com/
drugstore online shopping reviews http://canadianpharmacyonl.com/#low-cost-viagra-20mg
online canadian pharmacy
canadian drug store

CoreyElada (no verificado)

Dom, 14/04/2019 - 20:14

ukcanadianpharmacy.com canadian online pharmacies legitimate
aarp recommended canadian pharmacies http://ukcanadianpharmacy.com/
north west pharmacies canada http://ukcanadianpharmacy.com/#buy-viagra-online
online pharmacy canada
canada medication prices

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.