Cifrado en MySQL

Activado 23 Apr, 2012 Por Adolfo 345 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 - 20:35

canadianpharmacyes.com drugs for sale on internet
northwest pharmacies http://canadianpharmacyes.com/
pharmacy canada online prescriptions http://canadianpharmacyes.com/#buy-viagra
canadian medications online
canadian online pharmacies legitimate

CoreyElada (no verificado)

Dom, 14/04/2019 - 20:39

ukcanadianpharmacy.com north west pharmacies canada
canadian medications http://ukcanadianpharmacy.com/
canadian pharmacies http://ukcanadianpharmacy.com/#low-cost-viagra-20mg
canadian pharmaceuticals
pharmacy near me

CoreyElada (no verificado)

Dom, 14/04/2019 - 20:40

canadiantousapharmacy.com pharmacy canada online prescriptions
buy viagrow http://canadiantousapharmacy.com/
canada pharmacies http://canadiantousapharmacy.com/#buy-viagra
drugstore online reviews
canadian medications online

CoreyElada (no verificado)

Dom, 14/04/2019 - 20:41

canadianpharmacyonl.com canadian pharmacies that ship to us
canadianpharmacy http://canadianpharmacyonl.com/
canada rx http://canadianpharmacyonl.com/#generic-for-viagra
pharmacy near me
canadian pharmacy uk delivery

CoreyElada (no verificado)

Dom, 14/04/2019 - 20:43

canadianorderpharmacy.com canadian online pharmacies reviews
pharmacy onesource http://canadianorderpharmacy.com/
buy vistagra online safe http://canadianorderpharmacy.com/#generic-for-viagra
canadian pharmacies-24h
canadian pharmacy world

CoreyElada (no verificado)

Dom, 14/04/2019 - 20:47

canadianpharmacyonl.com canadian pharmacy world
canadian pharmaceuticals nafta http://canadianpharmacyonl.com/
canada online pharmacies http://canadianpharmacyonl.com/#viagra-5-mg
prescriptions from canada without
trust pharmacy canada

CoreyElada (no verificado)

Dom, 14/04/2019 - 20:52

canadianpharmacyes.com are canadian online pharmacies safe
viagra canadiense http://canadianpharmacyes.com/
canadian pharmacys http://canadianpharmacyes.com/#viagra-5-mg
trusted pharmacy canada
canadian government approved pharmacies

CoreyElada (no verificado)

Dom, 14/04/2019 - 21:03

canadiantousapharmacy.com drugstore online shopping
the best canadian online pharmacies http://canadiantousapharmacy.com/
canada medication pharmacy http://canadiantousapharmacy.com/#buy-viagra-online
canadian pharmacies that are legit
canadian discount pharmacies in ocala fl

CoreyElada (no verificado)

Dom, 14/04/2019 - 21:27

ukcanadianpharmacy.com canada drugs
cialis from canada http://ukcanadianpharmacy.com/
drugs for sale in canada http://ukcanadianpharmacy.com/#viagra-20mg
canadian pharmacy meds
pharmacy canada online prescriptions

CoreyElada (no verificado)

Dom, 14/04/2019 - 21:31

canadiantousapharmacy.com canada online pharmacy
canadian online pharmacies reviews http://canadiantousapharmacy.com/
online pharmacy http://canadiantousapharmacy.com/#generic-for-viagra
canadian pharcharmy online
buy viagra now

CoreyElada (no verificado)

Dom, 14/04/2019 - 21:31

canadiantousapharmacy.com trust pharmacy canada
prescriptions from canada without http://canadiantousapharmacy.com/
canadian drugstore http://canadiantousapharmacy.com/#generic-for-viagra
canadian pharmaceuticals stocks
buy vistagra usa

CoreyElada (no verificado)

Dom, 14/04/2019 - 21:32

canadianpharmacyonl.com drugstore online reviews
canadian rx world pharmacy http://canadianpharmacyonl.com/
canadian cialis http://canadianpharmacyonl.com/#viagra-5-mg
canadian pharcharmy online24
drugs for sale in uk

CoreyElada (no verificado)

Dom, 14/04/2019 - 21:34

canadianpharmacyes.com canadian pharmacycanadian pharmacy
online pharmacies in usa http://canadianpharmacyes.com/
canadian online pharmacy http://canadianpharmacyes.com/#viagra-generic
canadian medications online
canadian online pharmacies legitimate

CoreyElada (no verificado)

Dom, 14/04/2019 - 21:37

canadianpharmacyes.com top rated canadian pharmacies online
most reliable canadian pharmacies http://canadianpharmacyes.com/
canadian government approved pharmacies http://canadianpharmacyes.com/#viagra-tablets-australia
canada online pharmacies medication
canadian pharmacies without an rx

CoreyElada (no verificado)

Dom, 14/04/2019 - 21:55

canadianpharmacyonl.com canada pharmaceuticals online
online drug store http://canadianpharmacyonl.com/
canadian pharmaceuticals stocks http://canadianpharmacyonl.com/#buy-viagra
is trust pharmacy in canada legitimate
canadian pharmaceuticals reviews

CoreyElada (no verificado)

Dom, 14/04/2019 - 22:08

canadianpharmacyes.com canadian medications
canada online pharmacies http://canadianpharmacyes.com/
canadian drug store http://canadianpharmacyes.com/#viagra-5mg
canada online pharmacies for men
canadian prescriptions online serc 24 mg

CoreyElada (no verificado)

Dom, 14/04/2019 - 22:25

canadiantousapharmacy.com canadian pharmaceuticals
pharmacy onesource http://canadiantousapharmacy.com/
most reliable canadian pharmacies http://canadiantousapharmacy.com/#viagra-uk
canadian pharmacies online prescriptions
candida viagra

CoreyElada (no verificado)

Dom, 14/04/2019 - 22:36

canadianorderpharmacy.com cialis canadian pharmacy
global pharmacy canada http://canadianorderpharmacy.com/
canadian cialis http://canadianorderpharmacy.com/#viagra-5-mg
canadian pharmaceuticals companies
canadian pharcharmy online

CoreyElada (no verificado)

Dom, 14/04/2019 - 22:40

ukcanadianpharmacy.com canada medication list
canadian pharmacy no prescription http://ukcanadianpharmacy.com/
online pharmacies legitimate http://ukcanadianpharmacy.com/#viagra-20mg
drugs for sale in mexico
canada medication

CoreyElada (no verificado)

Dom, 14/04/2019 - 23:02

canadianorderpharmacy.com canadian pharmacys
aarp recommended canadian online pharmacies http://canadianorderpharmacy.com/
canadian drug http://canadianorderpharmacy.com/#viagra-from-canada
canada pharmacies online prescriptions
most reliable canadian online pharmacies

CoreyElada (no verificado)

Lun, 15/04/2019 - 00:12

ukcanadianpharmacy.com canadian pharmaceuticals reviews
buy vistagra online safe http://ukcanadianpharmacy.com/
safe canadian online pharmacies http://ukcanadianpharmacy.com/#buy-viagra-online
pharmacy canada 24
canadian pharmacys

CoreyElada (no verificado)

Lun, 15/04/2019 - 01:36

canadianpharmacyonl.com best canadian mail order pharmacies
canadian prescription drugstore http://canadianpharmacyonl.com/
canadian online pharmacies http://canadianpharmacyonl.com/#viagra-20-mg
canada medication
canada rx

CoreyElada (no verificado)

Lun, 15/04/2019 - 01:37

canadiantousapharmacy.com canada drugs online
northwest pharmacies online http://canadiantousapharmacy.com/
drugstore online india http://canadiantousapharmacy.com/#viagra-tablets-australia
aarp recommended canadian online pharmacies
canadian pharmacy

CoreyElada (no verificado)

Lun, 15/04/2019 - 01:39

canadianpharmacyonl.com canadian rx world pharmacy
how safe are canadian online pharmacies http://canadianpharmacyonl.com/
canadian pharmaceuticals online http://canadianpharmacyonl.com/#viagra-5mg
pharmacy onesource
canada pharmacies online prescriptions

CoreyElada (no verificado)

Lun, 15/04/2019 - 01:43

canadianpharmacyonl.com canada online pharmacies surrey
canadian government approved pharmacies http://canadianpharmacyonl.com/
drugstore online india http://canadianpharmacyonl.com/#viagra-generic
drugstore online india
canadian pharmacies

CoreyElada (no verificado)

Lun, 15/04/2019 - 02:27

ukcanadianpharmacy.com canadian medications online
the best canadian online pharmacies http://ukcanadianpharmacy.com/
buy viagrow http://ukcanadianpharmacy.com/#low-cost-viagra-20mg
online pharmacies legitimate
northwest pharmacies mail order

BrettNus (no verificado)

Lun, 15/04/2019 - 03:03

betnovate

Stewartlam (no verificado)

Lun, 15/04/2019 - 03:04

rimonabant erythromycin site lipitor avodart online check out your url buy diflucan more kamagra zanaflex cost buy inderal

BrettNus (no verificado)

Lun, 15/04/2019 - 03:05

hyzaar price

CoreyElada (no verificado)

Lun, 15/04/2019 - 03:10

canadianorderpharmacy.com canadian government approved pharmacies
canadian pharmacies shipping to usa http://canadianorderpharmacy.com/
trust pharmacy of canada http://canadianorderpharmacy.com/#viagra-5mg
trust pharmacy canada reviews
drugstore online shopping

CoreyElada (no verificado)

Lun, 15/04/2019 - 04:51

canadianpharmacyes.com canada medication cost
canada medications information http://canadianpharmacyes.com/
cialis canadian pharmacy http://canadianpharmacyes.com/#viagra-5-mg
reputable canadian prescriptions online
canadian pharmaceuticals for usa sales

CoreyElada (no verificado)

Lun, 15/04/2019 - 04:54

ukcanadianpharmacy.com pharmacy canada reviews
canada drug pharmacy http://ukcanadianpharmacy.com/
canadian pharcharmy online http://ukcanadianpharmacy.com/#buy-viagra
canadian pharmaceuticals
pharmacy near me

CoreyElada (no verificado)

Lun, 15/04/2019 - 05:30

canadianpharmacyonl.com online canadian pharmacies
global pharmacy canada http://canadianpharmacyonl.com/
canadian pharmacy no prescription http://canadianpharmacyonl.com/#discount-viagra
online pharmacies of canada
canadian medications

CoreyElada (no verificado)

Lun, 15/04/2019 - 05:36

canadianpharmacyes.com canadian drugstore
canadian online pharmacies reviews http://canadianpharmacyes.com/
canadian medications, liraglutide http://canadianpharmacyes.com/#viagra-from-canada
canada medication cost
buy viagra 25mg

CoreyElada (no verificado)

Lun, 15/04/2019 - 05:44

canadianorderpharmacy.com order canadian prescriptions online
canadian medications http://canadianorderpharmacy.com/
canadian rx http://canadianorderpharmacy.com/#tadalafil-5mg
trust pharmacy canada
aarp recommended canadian online pharmacies

CoreyElada (no verificado)

Lun, 15/04/2019 - 05:47

canadianpharmacyonl.com canadian viagra
legitimate canadian mail order pharmacies http://canadianpharmacyonl.com/
Northwest Pharmacy http://canadianpharmacyonl.com/#generic-for-viagra
north west pharmacy canada
online pharmacies india

CoreyElada (no verificado)

Lun, 15/04/2019 - 06:12

ukcanadianpharmacy.com drugs for sale usa
drugs for sale http://ukcanadianpharmacy.com/
canada medication pharmacy http://ukcanadianpharmacy.com/#generic-for-viagra
canadian rx
is trust pharmacy in canada legitimate

CoreyElada (no verificado)

Lun, 15/04/2019 - 06:14

canadiantousapharmacy.com canada online pharmacies legitimate
canada pharmacies online prescriptions http://canadiantousapharmacy.com/
drugstore online india http://canadiantousapharmacy.com/#buy-viagra
online pharmacies in usa
drugs for sale

CoreyElada (no verificado)

Lun, 15/04/2019 - 06:14

canadianpharmacyes.com canadian pharmacy
canada online pharmacy http://canadianpharmacyes.com/
northwest pharmacies in canada http://canadianpharmacyes.com/#discount-viagra
reputable canadian prescriptions online
canadian pharmaceuticals for usa sales

CoreyElada (no verificado)

Lun, 15/04/2019 - 07:14

ukcanadianpharmacy.com canadian pharmaceuticals
canadian rxlist http://ukcanadianpharmacy.com/
canadian prescriptions online http://ukcanadianpharmacy.com/#viagra-5-mg
north west pharmacies canada
canada pharmacies

CoreyElada (no verificado)

Lun, 15/04/2019 - 07:19

canadianpharmacyes.com canadian prescriptions online serc 24 mg
canadian drugs http://canadianpharmacyes.com/
canada drugs http://canadianpharmacyes.com/#viagra-20mg
pharmacy times
canadian medications by mail

CoreyElada (no verificado)

Lun, 15/04/2019 - 07:40

canadianpharmacyonl.com pharmacy canada best
pharmacy canada reviews http://canadianpharmacyonl.com/
trusted pharmacy canada scam http://canadianpharmacyonl.com/#tadalafil-20-mg
pharmacy canada online prescriptions
canadian pharmaceuticals companies

MichaelNap (no verificado)

Mar, 23/04/2019 - 01:28

ukcanadianpharmacy.com pharmacy canada plus
canadian pharmacy king http://ukcanadianpharmacy.com/
canada online pharmacies medication http://ukcanadianpharmacy.com/#viagra-uk
online pharmacies legitimate
northwest pharmacies mail order

MichaelNap (no verificado)

Mar, 23/04/2019 - 05:03

canadianpharmacyonl.com online pharmacies tech school
drugs for sale on internet http://canadianpharmacyonl.com/
trust pharmacy of canada http://canadianpharmacyonl.com/#viagra-20mg
pharmacy onesource
canada pharmacies online prescriptions

MichaelNap (no verificado)

Mar, 23/04/2019 - 08:05

canadianorderpharmacy.com canadian medications
canada vagra http://canadianorderpharmacy.com/
canadian online pharmacy http://canadianorderpharmacy.com/#discount-viagra
trusted pharmacy canada scam
canada pharmaceuticals online

MichaelNap (no verificado)

Mar, 23/04/2019 - 11:19

ukcanadianpharmacy.com trust pharmacy canadian
canada viagra http://ukcanadianpharmacy.com/
north west pharmacy canada http://ukcanadianpharmacy.com/#viagra-5mg
canada medication pharmacy
canadian pharcharmy online24

MichaelNap (no verificado)

Mar, 23/04/2019 - 13:11

canadiantousapharmacy.com canada online pharmacies surrey
canadian prescriptions online serc 24 mg http://canadiantousapharmacy.com/
legitimate canadian mail order pharmacies http://canadiantousapharmacy.com/#viagra-levitra
online pharmacies in usa
drugs for sale

MichaelNap (no verificado)

Mar, 23/04/2019 - 16:05

canadianpharmacyes.com buy viagrow
the best canadian online pharmacies http://canadianpharmacyes.com/
trust pharmacy canada reviews http://canadianpharmacyes.com/#tadalafil-20-mg
buy vistagra online safe
canadian pharmaceuticals online

MichaelNap (no verificado)

Mar, 23/04/2019 - 17:08

canadianorderpharmacy.com canada pharmacies
north west pharmacy canada http://canadianorderpharmacy.com/
aarp recommended canadian pharmacies http://canadianorderpharmacy.com/#buy-viagra-online
drugs for sale in uk
canadian medications, liraglutide

MichaelNap (no verificado)

Mié, 24/04/2019 - 17:18

canadianpharmacyonl.com order canadian prescriptions online
northwest pharmacies mail order http://canadianpharmacyonl.com/?viagra
canada medications buy http://canadianpharmacyonl.com/?viagra#low-cost-viagra-20mg
canadian pharcharmy online24
drugs for sale in uk

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.