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

MichaelNap (no verificado)

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

ukcanadianpharmacy.com canada medication pharmacy
prescription drugs without prior prescription http://ukcanadianpharmacy.com/?viagra
canadian pharmacy online 24 http://ukcanadianpharmacy.com/?viagra#tadalafil-20-mg
canadian medications list
canadian pharmacies that ship to us

MichaelNap (no verificado)

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

canadiantousapharmacy.com safe canadian online pharmacies
online pharmacy http://canadiantousapharmacy.com/?viagra
rx from canada http://canadiantousapharmacy.com/?viagra#viagra-20mg
canadian pharmacy king
best canadian pharmacy

MichaelNap (no verificado)

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

canadianpharmacyes.com canadian pharmacy viagra
order canadian prescriptions online http://canadianpharmacyes.com/?viagra
canadian online pharmacies http://canadianpharmacyes.com/?viagra#low-cost-viagra-20mg
canada online pharmacies medication
canadian pharmacies without an rx

MichaelNap (no verificado)

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

ukcanadianpharmacy.com canada online pharmacies reviews
canadian pharmacy viagra http://ukcanadianpharmacy.com/?viagra
buy viagra 25mg http://ukcanadianpharmacy.com/?viagra#tadalafil-20-mg
best canadian mail order pharmacies
online canadian pharmacy

MichaelNap (no verificado)

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

canadianpharmacyes.com buy vistagra usa
canadianpharmacy http://canadianpharmacyes.com/?viagra
canadian pharmacies http://canadianpharmacyes.com/?viagra#viagra-generic
drugs for sale
most reliable canadian pharmacies

MichaelNap (no verificado)

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

canadiantousapharmacy.com drugs for sale online
reputable canadian prescriptions online http://canadiantousapharmacy.com/?viagra
canadian pharmaceuticals stocks http://canadiantousapharmacy.com/?viagra#viagra-20mg
global pharmacy canada
canada online pharmacies for men

MichaelNap (no verificado)

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

canadianpharmacyonl.com canadian discount pharmacies in ocala fl
canadian pharmacies that are legit http://canadianpharmacyonl.com/?viagra
online pharmacies india http://canadianpharmacyonl.com/?viagra#viagra-5mg
canada medication
canada rx

MichaelNap (no verificado)

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

canadianorderpharmacy.com canada medications buy
canada rx http://canadianorderpharmacy.com/?viagra
trust pharmacy canada reviews http://canadianorderpharmacy.com/?viagra#buy-viagra-online
canadian online pharmacies rated
canadian rx world pharmacy

MichaelNap (no verificado)

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

canadianorderpharmacy.com canadian discount pharmacies in canada
canadian pharmaceuticals for usa sales http://canadianorderpharmacy.com/?viagra
canada viagra http://canadianorderpharmacy.com/?viagra#viagra-levitra
trust pharmacy canadian
canadian cialis

MichaelNap (no verificado)

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

canadianpharmacyes.com drugstore online
good canadian online pharmacies http://canadianpharmacyes.com/?viagra
canadianpharmacyusa24h is it legal http://canadianpharmacyes.com/?viagra#buy-viagra
pharmacy times
canadian medications by mail

MichaelNap (no verificado)

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

canadiantousapharmacy.com online pharmacies legitimate
canadian drug http://canadiantousapharmacy.com/?viagra
canadian pharmaceuticals http://canadiantousapharmacy.com/?viagra#viagra-5mg
northwest pharmacies in canada
canada medication cost

MichaelNap (no verificado)

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

canadianpharmacyonl.com canadian pharmacy
legitimate canadian mail order pharmacies http://canadianpharmacyonl.com/?viagra
pharmacy times http://canadianpharmacyonl.com/?viagra#generic-for-viagra
buy viagrow
canada medications cheap

MichaelNap (no verificado)

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

ukcanadianpharmacy.com northwest pharmacies
buy viagra usa http://ukcanadianpharmacy.com/?viagra
canadian drugs http://ukcanadianpharmacy.com/?viagra#buy-viagra
canadian rxlist
good canadian online pharmacies

MichaelNap (no verificado)

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

canadiantousapharmacy.com canadian rx
drugs for sale usa http://canadiantousapharmacy.com/?viagra
pharmacy http://canadiantousapharmacy.com/?viagra#viagra-uk
canadian medications, liraglutide
how safe are canadian online pharmacies

MichaelNap (no verificado)

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

ukcanadianpharmacy.com online pharmacy canada
buy viagra now http://ukcanadianpharmacy.com/?viagra
canadian pharmaceuticals stocks http://ukcanadianpharmacy.com/?viagra#viagra-5-mg
canada medication pharmacy
canadian pharcharmy online24

MichaelNap (no verificado)

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

canadianpharmacyonl.com northwest pharmacy canada
trust pharmacy canada http://canadianpharmacyonl.com/?viagra
northwest pharmacies online http://canadianpharmacyonl.com/?viagra#viagra-5-mg
canadian pharmacies that ship to us
top rated canadian pharmacies online

MichaelNap (no verificado)

Mié, 24/04/2019 - 19:06

canadianpharmacyes.com canadian medications 247
pharmacy canada plus http://canadianpharmacyes.com/?viagra
canada vagra http://canadianpharmacyes.com/?viagra#viagra-uk
canadian medications online
canadian online pharmacies legitimate

MichaelNap (no verificado)

Mié, 24/04/2019 - 19:08

canadianpharmacyonl.com canadian pharmaceuticals companies
drugs for sale deep web http://canadianpharmacyonl.com/?viagra
canadian pharmacies shipping to usa http://canadianpharmacyonl.com/?viagra#viagra-5-mg
canada online pharmacies legitimate
canadian pharmacies-24h

MichaelNap (no verificado)

Mié, 24/04/2019 - 19:19

canadianpharmacyes.com safe canadian online pharmacies
northwest pharmacies mail order http://canadianpharmacyes.com/?viagra
canadian online pharmacies rated http://canadianpharmacyes.com/?viagra#viagra-5mg
canadian online pharmacies legal
best canadian mail order pharmacies

MichaelNap (no verificado)

Mié, 24/04/2019 - 19:21

canadianpharmacyonl.com canadian pharmacy king
safe canadian online pharmacies http://canadianpharmacyonl.com/?viagra
canada medication cost http://canadianpharmacyonl.com/?viagra#viagra-5-mg
is trust pharmacy in canada legitimate
canadian pharmaceuticals reviews

MichaelNap (no verificado)

Mié, 24/04/2019 - 19:25

canadianorderpharmacy.com safe canadian online pharmacies
drugs for sale in mexico http://canadianorderpharmacy.com/?viagra
canada medication pharmacy http://canadianorderpharmacy.com/?viagra#low-cost-viagra-20mg
canadian prescription drugstore
global pharmacy canada

MichaelNap (no verificado)

Mié, 24/04/2019 - 19:26

canadiantousapharmacy.com canadian pharmacies online prescriptions
canada viagra http://canadiantousapharmacy.com/?viagra
canadian pharmacies http://canadiantousapharmacy.com/?viagra#tadalafil-5mg
canadian pharmacy king
best canadian pharmacy

MichaelNap (no verificado)

Mié, 24/04/2019 - 19:27

ukcanadianpharmacy.com canadian pharmacies without an rx
canadian pharmacies stendra http://ukcanadianpharmacy.com/?viagra
canadian medications by mail http://ukcanadianpharmacy.com/?viagra#buy-generic-viagra
canadian online pharmacies legitimate
canadian pharmacycanadian pharmacy

MichaelNap (no verificado)

Mié, 24/04/2019 - 19:34

canadianpharmacyes.com online pharmacy
canada pharmacies http://canadianpharmacyes.com/?viagra
canadian drug http://canadianpharmacyes.com/?viagra#tadalafil-5mg
canadian medications online
canadian online pharmacies legitimate

MichaelNap (no verificado)

Mié, 24/04/2019 - 19:38

canadianorderpharmacy.com canada medication pharmacy
canadian pharmaceuticals online http://canadianorderpharmacy.com/?viagra
canadian pharmaceuticals reviews http://canadianorderpharmacy.com/?viagra#tadalafil-20-mg
canadian pharmacies
canadian pharmacy no prescription

MichaelNap (no verificado)

Mié, 24/04/2019 - 19:42

canadianpharmacyes.com online canadian discount pharmacies
canadian viagra http://canadianpharmacyes.com/?viagra
canada medication cost http://canadianpharmacyes.com/?viagra#viagra-generic
canada medication cost
buy viagra 25mg

MichaelNap (no verificado)

Mié, 24/04/2019 - 19:50

canadiantousapharmacy.com canadian pharmaceuticals stocks
best canadian pharmacies online http://canadiantousapharmacy.com/?viagra
drugs for sale on internet http://canadiantousapharmacy.com/?viagra#viagra-20-mg
canadian medications, liraglutide
how safe are canadian online pharmacies

MichaelNap (no verificado)

Mié, 24/04/2019 - 19:56

canadiantousapharmacy.com canadian pharmaceuticals stocks
trusted pharmacy canada scam http://canadiantousapharmacy.com/?viagra
canada online pharmacy http://canadiantousapharmacy.com/?viagra#buy-viagra
canadian cialis
drugstore online shopping reviews

MichaelNap (no verificado)

Mié, 24/04/2019 - 20:04

canadianorderpharmacy.com canada pharmacies online prescriptions
canadian pharmacies without an rx http://canadianorderpharmacy.com/?viagra
canadian drug http://canadianorderpharmacy.com/?viagra#low-cost-viagra-20mg
canadian pharmacy online 24
northwest pharmacies in canada

MichaelNap (no verificado)

Mié, 24/04/2019 - 20:04

canadianpharmacyonl.com online pharmacies of canada
canadian pharmacy viagra http://canadianpharmacyonl.com/?viagra
trusted pharmacy canada scam http://canadianpharmacyonl.com/?viagra#viagra-levitra
buy viagrow pro
canadianpharmacy

MichaelNap (no verificado)

Mié, 24/04/2019 - 20:11

canadianpharmacyes.com online canadian discount pharmacies
canada drugs http://canadianpharmacyes.com/?viagra
trust pharmacy of canada http://canadianpharmacyes.com/?viagra#tadalafil-5mg
canada medications buy
canadian rxlist

MichaelNap (no verificado)

Mié, 24/04/2019 - 20:14

canadianorderpharmacy.com canadian pharmacy viagra brand
canada online pharmacies legitimate http://canadianorderpharmacy.com/?viagra
canada medications cheap http://canadianorderpharmacy.com/?viagra#viagra-tablets-australia
drugs for sale in uk
canadian medications, liraglutide

MichaelNap (no verificado)

Mié, 24/04/2019 - 20:23

canadianpharmacyonl.com the best canadian online pharmacies
northwest pharmacies http://canadianpharmacyonl.com/?viagra
canadian medications 247 http://canadianpharmacyonl.com/?viagra#buy-viagra-online
canadian pharmacy viagra
Canadian Pharmacy USA

MichaelNap (no verificado)

Mié, 24/04/2019 - 20:25

canadiantousapharmacy.com canadian online pharmacies reviews
reputable canadian prescriptions online http://canadiantousapharmacy.com/?viagra
trusted pharmacy canada http://canadiantousapharmacy.com/?viagra#tadalafil-20-mg
canadian online pharmacies
best canadian pharmacies online

MichaelNap (no verificado)

Mié, 24/04/2019 - 20:35

canadianorderpharmacy.com candida viagra
online drug store http://canadianorderpharmacy.com/?viagra
canada vagra http://canadianorderpharmacy.com/?viagra#generic-for-viagra
canadian pharmacies-24h
canadian pharmacy world

MichaelNap (no verificado)

Mié, 24/04/2019 - 20:35

ukcanadianpharmacy.com candida viagra
pharmacy near me http://ukcanadianpharmacy.com/?viagra
canada drug http://ukcanadianpharmacy.com/?viagra#buy-generic-viagra
canadian online pharmacies legitimate
canadian pharmacycanadian pharmacy

MichaelNap (no verificado)

Mié, 24/04/2019 - 20:45

canadianpharmacyes.com online canadian discount pharmacies
canadian prescriptions online http://canadianpharmacyes.com/?viagra
buy vistagra online safe http://canadianpharmacyes.com/?viagra#buy-viagra
drugs for sale
most reliable canadian pharmacies

MichaelNap (no verificado)

Mié, 24/04/2019 - 20:47

canadiantousapharmacy.com canadian drug store
canadian medications online http://canadiantousapharmacy.com/?viagra
canadianpharmacyusa24h is it legal http://canadiantousapharmacy.com/?viagra#viagra-from-canada
drugs for sale on internet
canadian online pharmacies legal

MichaelNap (no verificado)

Mié, 24/04/2019 - 20:51

canadianorderpharmacy.com canadian pharmacies without an rx
online pharmacies legitimate http://canadianorderpharmacy.com/?viagra
drugstore online india http://canadianorderpharmacy.com/?viagra#buy-viagra-online
legitimate canadian mail order pharmacies
canadian pharmacy king

MichaelNap (no verificado)

Mié, 24/04/2019 - 21:08

canadianorderpharmacy.com online pharmacies legitimate
pharmacy times http://canadianorderpharmacy.com/?viagra
canadian pharmacy http://canadianorderpharmacy.com/?viagra#viagra-uk
Canadian Pharmacy USA
canadian pharmacies online prescriptions

MichaelNap (no verificado)

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

canadianpharmacyes.com cialis canadian pharmacy
canadianpharmacyusa24h is it legal http://canadianpharmacyes.com/?viagra
best canadian pharmacy http://canadianpharmacyes.com/?viagra#viagra-tablets-australia
how safe are canadian online pharmacies
online pharmacies legitimate

MichaelNap (no verificado)

Mié, 24/04/2019 - 21:22

ukcanadianpharmacy.com canadian pharmacy viagra brand
canada online pharmacy http://ukcanadianpharmacy.com/?viagra
canadian medications by mail http://ukcanadianpharmacy.com/?viagra#viagra-from-canada
pharmacy canada 24
canadian pharmacys

jaisygaH (no verificado)

Vie, 31/05/2019 - 13:45

Inwacy
http://paydayloanse.loan

jaisygaH (no verificado)

Sáb, 01/06/2019 - 11:18

Insags
http://paydayloanse.loan

AustRaf (no verificado)

Mié, 05/06/2019 - 23:31

Vardenafil Bestellen cialis without prescription Amoxicillin Prescribing Information Buy. Amytryptline

emophasiopiek (no verificado)

Dom, 09/06/2019 - 12:31

pau caesars online casino

Randswoli (no verificado)

Lun, 10/06/2019 - 11:05

Vendite Kamagra In Spagna cialis Propecia After 10 Years Testosterone Levels Viagra No Rx Echeck Viagara

unobioppypop (no verificado)

Lun, 17/06/2019 - 20:08

fxe free casino slot games

unobioppypop (no verificado)

Mar, 18/06/2019 - 07:51

sge parx casino online

unobioppypop (no verificado)

Mar, 18/06/2019 - 11:36

tej prairie meadows casino

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.