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 - 05:19

canadianpharmacyonl.com cialis from canada
canada medication pharmacy http://canadianpharmacyonl.com/
canadian medications pharmacy http://canadianpharmacyonl.com/#viagra-uk
pharmacy canada online prescriptions
canadian pharmaceuticals companies

CoreyElada (no verificado)

Dom, 14/04/2019 - 05:24

canadianorderpharmacy.com canadian pharmacy viagra brand
canada online pharmacies surrey [url=http://canadianorderpharmacy.com/#]http://canadianorderpharmacy.com/[/url]
canadian pharmacies that are legit http://canadianorderpharmacy.com/#viagra-generic
top rated canadian pharmacies online
canadian pharmacies that are legit

CoreyElada (no verificado)

Dom, 14/04/2019 - 05:33

canadiantousapharmacy.com canada pharmaceuticals online
online canadian pharmacies [url=http://canadiantousapharmacy.com/#]http://canadiantousapharmacy.com/[/url]
online pharmacies of canada http://canadiantousapharmacy.com/#viagra-20mg
viagra canadiense
canada vagra

CoreyElada (no verificado)

Dom, 14/04/2019 - 05:46

canadianpharmacyes.com canadian medications list
canadian pharmacy http://canadianpharmacyes.com/
order canadian prescriptions online http://canadianpharmacyes.com/#low-cost-viagra-20mg
online drug store
canadian pharmacy meds

CoreyElada (no verificado)

Dom, 14/04/2019 - 05:54

canadiantousapharmacy.com trusted pharmacy canada scam
buy viagrow http://canadiantousapharmacy.com/
canadian pharcharmy online24 http://canadiantousapharmacy.com/#buy-viagra-online
drugstore online reviews
canadian medications online

CoreyElada (no verificado)

Dom, 14/04/2019 - 05:54

canadianpharmacyes.com online pharmacies mexico
canadian pharmaceuticals stocks http://canadianpharmacyes.com/
canadian drugs http://canadianpharmacyes.com/#viagra-from-canada
how safe are canadian online pharmacies
online pharmacies legitimate

CoreyElada (no verificado)

Dom, 14/04/2019 - 06:18

canadiantousapharmacy.com cialis canadian pharmacy
canadianpharmacyusa24h http://canadiantousapharmacy.com/
canada drugs online http://canadiantousapharmacy.com/#discount-viagra
canadian pharmacy no prescription
northwest pharmacies online

CoreyElada (no verificado)

Dom, 14/04/2019 - 06:44

canadianpharmacyonl.com most reliable canadian pharmacies
buy viagra 25mg http://canadianpharmacyonl.com/
drugs for sale online http://canadianpharmacyonl.com/#viagra-5-mg
online pharmacies of canada
canadian medications

CoreyElada (no verificado)

Dom, 14/04/2019 - 06:45

canadiantousapharmacy.com canadian pharmacy
drugstore online india http://canadiantousapharmacy.com/
aarp recommended canadian online pharmacies http://canadiantousapharmacy.com/#discount-viagra
canadian pharmacy viagra brand
buy vistagra online safe

CoreyElada (no verificado)

Dom, 14/04/2019 - 06:46

ukcanadianpharmacy.com most reliable canadian online pharmacies
canadian online pharmacies rated http://ukcanadianpharmacy.com/
pharmacy canada online prescriptions http://ukcanadianpharmacy.com/#tadalafil-5mg
canadian medications list
canadian pharmacies that ship to us

CoreyElada (no verificado)

Dom, 14/04/2019 - 06:47

canadianpharmacyonl.com canadian pharmacy viagra brand
most reliable canadian online pharmacies http://canadianpharmacyonl.com/
trusted pharmacy canada scam http://canadianpharmacyonl.com/#buy-viagra-online
pharmacy canada online prescriptions
canadian pharmaceuticals companies

CoreyElada (no verificado)

Dom, 14/04/2019 - 06:51

canadianpharmacyes.com canadian pharmacy viagra brand
canada online pharmacies medication http://canadianpharmacyes.com/
good canadian online pharmacies http://canadianpharmacyes.com/#low-cost-viagra-20mg
drugs for sale usa
drugs for sale in mexico

CoreyElada (no verificado)

Dom, 14/04/2019 - 06:56

canadianorderpharmacy.com canadian pharmacycanadian pharmacy
canada vagra http://canadianorderpharmacy.com/
online pharmacies legitimate http://canadianorderpharmacy.com/#viagra-tablets-australia
top rated canadian pharmacies online
canadian pharmacies that are legit

CoreyElada (no verificado)

Dom, 14/04/2019 - 07:07

canadianpharmacyes.com canada drugs online
drugstore online reviews http://canadianpharmacyes.com/
no 1 canadian pharcharmy online http://canadianpharmacyes.com/#viagra-levitra
best canadian pharmacy
cialis canadian pharmacy

CoreyElada (no verificado)

Dom, 14/04/2019 - 07:10

canadianpharmacyonl.com canada pharmacies online prescriptions
canada pharmaceuticals online http://canadianpharmacyonl.com/
canada online pharmacies http://canadianpharmacyonl.com/#viagra-from-canada
pharmacy onesource
canada pharmacies online prescriptions

CoreyElada (no verificado)

Dom, 14/04/2019 - 07:34

ukcanadianpharmacy.com canadian pharcharmy online24
cialis canadian pharmacy http://ukcanadianpharmacy.com/
canadian prescriptions online http://ukcanadianpharmacy.com/#low-cost-viagra-20mg
canadian prescriptions online serc 24 mg
drugstore online india

CoreyElada (no verificado)

Dom, 14/04/2019 - 07:40

canadianorderpharmacy.com rx from canada
canada medications information http://canadianorderpharmacy.com/
trust pharmacy of canada http://canadianorderpharmacy.com/#viagra-generic
canadian pharmaceuticals reviews
online pharmacies in usa

CoreyElada (no verificado)

Dom, 14/04/2019 - 07:41

canadianpharmacyonl.com canadian online pharmacies reviews
canadian pharmacies shipping to usa http://canadianpharmacyonl.com/
aarp recommended canadian online pharmacies http://canadianpharmacyonl.com/#viagra-5mg
are canadian online pharmacies safe
canadian online pharmacies rated

CoreyElada (no verificado)

Dom, 14/04/2019 - 07:41

canadianpharmacyes.com canadian pharmaceuticals stocks
buy viagra usa http://canadianpharmacyes.com/
canadian online pharmacies legal http://canadianpharmacyes.com/#viagra-uk
candida viagra
canadian medications list

CoreyElada (no verificado)

Dom, 14/04/2019 - 07:54

ukcanadianpharmacy.com pharmacy canada reviews
canada medication http://ukcanadianpharmacy.com/
canadian medications pharmacy http://ukcanadianpharmacy.com/#viagra-20-mg
canadian rx
is trust pharmacy in canada legitimate

CoreyElada (no verificado)

Dom, 14/04/2019 - 08:00

canadianorderpharmacy.com canadian pharmacies that ship to us
pharmacy canada reviews http://canadianorderpharmacy.com/
buy viagra online usa http://canadianorderpharmacy.com/#viagra-from-canada
canadian pharmacy online 24
northwest pharmacies in canada

CoreyElada (no verificado)

Dom, 14/04/2019 - 08:04

canadianpharmacyonl.com canadian pharmacies shipping to usa
buy vistagra usa http://canadianpharmacyonl.com/
canadian pharmacy meds http://canadianpharmacyonl.com/#buy-viagra
online canadian pharmacy
canadian drug store

CoreyElada (no verificado)

Dom, 14/04/2019 - 08:28

canadianorderpharmacy.com canada medications information
canadianpharmacyusa24h http://canadianorderpharmacy.com/
Canadian Pharmacy USA http://canadianorderpharmacy.com/#discount-viagra
canada pharmacies online prescriptions
most reliable canadian online pharmacies

CoreyElada (no verificado)

Dom, 14/04/2019 - 08:34

ukcanadianpharmacy.com best canadian pharmacies online
canadian pharmaceuticals companies http://ukcanadianpharmacy.com/
northwestpharmacy http://ukcanadianpharmacy.com/#viagra-5mg
canadian online pharmacies reviews
canada online pharmacies legitimate

CoreyElada (no verificado)

Dom, 14/04/2019 - 08:34

canadianpharmacyes.com rx from canada
canadian discount pharmacies in canada http://canadianpharmacyes.com/
northwestpharmacy http://canadianpharmacyes.com/#buy-generic-viagra
canada online pharmacies surrey
north west pharmacies canada

CoreyElada (no verificado)

Dom, 14/04/2019 - 08:35

canadianorderpharmacy.com canada medication prices
prescriptions from canada without http://canadianorderpharmacy.com/
canadian pharmacy world http://canadianorderpharmacy.com/#tadalafil-5mg
northwestpharmacy
drugs for sale in canada

CoreyElada (no verificado)

Dom, 14/04/2019 - 08:39

ukcanadianpharmacy.com canadianpharmacyusa24h is it legal
canadian medications 247 http://ukcanadianpharmacy.com/
pharmacy canada 24 http://ukcanadianpharmacy.com/#discount-viagra
drugs for sale online
canadian pharmacy viagra

CoreyElada (no verificado)

Dom, 14/04/2019 - 08:44

ukcanadianpharmacy.com canadian prescriptions online serc 24 mg
drugs for sale in mexico http://ukcanadianpharmacy.com/
canadian pharmacys http://ukcanadianpharmacy.com/#viagra-5mg
canadian online pharmacies reviews
canada online pharmacies legitimate

CoreyElada (no verificado)

Dom, 14/04/2019 - 08:54

canadianorderpharmacy.com canadian online pharmacies reviews
canadian government approved pharmacies http://canadianorderpharmacy.com/
canadian drug http://canadianorderpharmacy.com/#generic-for-viagra
canadian pharmacy uk delivery
pharmacy canada

CoreyElada (no verificado)

Dom, 14/04/2019 - 09:09

canadianpharmacyes.com candida viagra
safe canadian online pharmacies http://canadianpharmacyes.com/
canadian pharmacies shipping to usa http://canadianpharmacyes.com/#viagra-20mg
pharmacy times
canadian medications by mail

CoreyElada (no verificado)

Dom, 14/04/2019 - 09:27

canadianpharmacyonl.com pharmacy onesource
discount canadian pharmacies http://canadianpharmacyonl.com/
canada online pharmacies legitimate http://canadianpharmacyonl.com/#viagra-tablets-australia
online canadian pharmacy
canadian drug store

CoreyElada (no verificado)

Dom, 14/04/2019 - 09:29

canadianorderpharmacy.com trust pharmacy canadian
canadian pharmacies without an rx http://canadianorderpharmacy.com/
canadian pharmacies that ship to us http://canadianorderpharmacy.com/#tadalafil-5mg
canada pharmacies online prescriptions
most reliable canadian online pharmacies

CoreyElada (no verificado)

Dom, 14/04/2019 - 09:32

canadiantousapharmacy.com buy viagra online usa
canada online pharmacies legitimate http://canadiantousapharmacy.com/
canada medications cheap http://canadiantousapharmacy.com/#tadalafil-5mg
global pharmacy canada
canada online pharmacies for men

CoreyElada (no verificado)

Dom, 14/04/2019 - 09:38

canadianpharmacyonl.com canadian prescriptions online
canada online pharmacies legitimate http://canadianpharmacyonl.com/
online pharmacies of canada http://canadianpharmacyonl.com/#tadalafil-5mg
online canadian pharmacy
canadian drug store

CoreyElada (no verificado)

Dom, 14/04/2019 - 09:51

ukcanadianpharmacy.com canadian cialis
canadian online pharmacies http://ukcanadianpharmacy.com/
online pharmacy canada http://ukcanadianpharmacy.com/#viagra-20mg
buy viagra online usa
canadian viagra

CoreyElada (no verificado)

Dom, 14/04/2019 - 10:17

canadianpharmacyes.com canadian medications 247
canadian pharmacy viagra http://canadianpharmacyes.com/
legitimate canadian mail order pharmacies http://canadianpharmacyes.com/#viagra-20mg
how safe are canadian online pharmacies
online pharmacies legitimate

CoreyElada (no verificado)

Dom, 14/04/2019 - 10:24

canadianorderpharmacy.com Canadian Pharmacy USA
canada pharmacies online prescriptions http://canadianorderpharmacy.com/
northwest pharmacies in canada http://canadianorderpharmacy.com/#viagra-tablets-australia
canadianpharmacyusa24h is it legal
order canadian prescriptions online

CoreyElada (no verificado)

Dom, 14/04/2019 - 10:26

ukcanadianpharmacy.com online pharmacies mexico
canadian discount pharmacies in canada http://ukcanadianpharmacy.com/
canadian pharmacy cialis http://ukcanadianpharmacy.com/#viagra-from-canada
canada online pharmacies reviews
buy viagrow pro

CoreyElada (no verificado)

Dom, 14/04/2019 - 10:38

canadianpharmacyonl.com canadianpharmacy
drugs for sale on internet http://canadianpharmacyonl.com/
northwest pharmacies online http://canadianpharmacyonl.com/#viagra-5-mg
northwest pharmacy canada
northwest pharmacies

CoreyElada (no verificado)

Dom, 14/04/2019 - 10:53

canadiantousapharmacy.com online pharmacies mexico
canada pharmacies online prescriptions http://canadiantousapharmacy.com/
canadian drug http://canadiantousapharmacy.com/#viagra-20mg
canadian pharmacy king
best canadian pharmacy

CoreyElada (no verificado)

Dom, 14/04/2019 - 11:23

canadianorderpharmacy.com canadian pharmaceuticals reviews
pharmacy times http://canadianorderpharmacy.com/
canada online pharmacies reviews http://canadianorderpharmacy.com/#tadalafil-5mg
canadian medications
canada medication list

CoreyElada (no verificado)

Dom, 14/04/2019 - 11:29

canadiantousapharmacy.com trusted pharmacy canada scam
canada medication pharmacy http://canadiantousapharmacy.com/
canadian medications by mail http://canadiantousapharmacy.com/#tadalafil-5mg
drugstore online reviews
canadian medications online

CoreyElada (no verificado)

Dom, 14/04/2019 - 11:29

ukcanadianpharmacy.com drugstore online shopping
canada online pharmacies surrey http://ukcanadianpharmacy.com/
canada medication http://ukcanadianpharmacy.com/#viagra-levitra
buy viagra online usa
canadian viagra

CoreyElada (no verificado)

Dom, 14/04/2019 - 11:31

canadianpharmacyes.com online pharmacies of canada
canadian medications online http://canadianpharmacyes.com/
canadian pharmacy king http://canadianpharmacyes.com/#buy-generic-viagra
how safe are canadian online pharmacies
online pharmacies legitimate

CoreyElada (no verificado)

Dom, 14/04/2019 - 11:35

canadianpharmacyes.com canadian pharmacies without an rx
online canadian pharmacies http://canadianpharmacyes.com/
drugs for sale deep web http://canadianpharmacyes.com/#viagra-levitra
canadian prescriptions online
online pharmacies tech school

CoreyElada (no verificado)

Dom, 14/04/2019 - 11:42

canadianorderpharmacy.com canada medication
canada drugs online http://canadianorderpharmacy.com/
canada online pharmacies reviews http://canadianorderpharmacy.com/#buy-generic-viagra
online canadian discount pharmacies
viagra canadiense

CoreyElada (no verificado)

Dom, 14/04/2019 - 11:51

ukcanadianpharmacy.com Northwest Pharmacy
canada pharmaceuticals online http://ukcanadianpharmacy.com/
canada medication http://ukcanadianpharmacy.com/#buy-generic-viagra
canada online pharmacies
online pharmacy

CoreyElada (no verificado)

Dom, 14/04/2019 - 11:55

canadianpharmacyes.com top rated canadian pharmacies online
canadian pharmacies that are legit http://canadianpharmacyes.com/
Northwest Pharmacy http://canadianpharmacyes.com/#viagra-20-mg
reputable canadian prescriptions online
canadian pharmaceuticals for usa sales

CoreyElada (no verificado)

Dom, 14/04/2019 - 12:31

canadianorderpharmacy.com canadian pharmacys
good canadian online pharmacies http://canadianorderpharmacy.com/
prescriptions from canada without http://canadianorderpharmacy.com/#viagra-levitra
canadian medications
canada medication list

CoreyElada (no verificado)

Dom, 14/04/2019 - 13:43

ukcanadianpharmacy.com canadian medications pharmacy
canadian medications by mail http://ukcanadianpharmacy.com/
canadian rxlist http://ukcanadianpharmacy.com/#tadalafil-5mg
canadian pharmaceuticals online
online pharmacies of canada

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.