Cifrado en MySQL

Activado 23 Apr, 2012 Por Adolfo 362 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

pexe jurer (no verificado)

Mar, 27/11/2018 - 11:31

https://knifehitmod.xyz/apk/  https://pubgmod.xyz/apk/  https://soulknightmod.pro/apk/

JeaShasia (no verificado)

Mié, 19/12/2018 - 01:11

Viagra Super Plus Active Lioresal Acheter En Canada buy accutane 30 mg Achat De Viagra En Suisse En Cholet Mixing Amoxicillin Wine Together Propecia Firenze Canadian Medicines Online cialis 5mg best price Prix Du Cytotec Dans Une Pharmacie

getapk (no verificado)

Lun, 14/01/2019 - 15:47

https://getapk.ooo/nova3-mod-apk/

JeaShasia (no verificado)

Jue, 17/01/2019 - 19:08

Tomar Viagra Zantac Amoxicillin viagra Como Comprar Cialis Isotretinoin 10mg Skin Health Zithromax Erythromycin viagra online Buy Valtrex Without Insurance Cephalexin Lawsuit Trouver Du Cialis Pas Cher viagra Lawrence Walter Pharmacy Canada Isotretinoin Isotrex Cialis Naturale Alle Erbe buy viagra levitra Acheter Cialis Paypal

JeaShasia (no verificado)

Dom, 03/02/2019 - 11:54

Kamagra Gold Medicina Cialis Soft cheapest generic levitra Buying Doxycycline Online Uk Safe Buy Dilantin No Script secure ordering isotretinoin pills in internet Daily Cialis Priligyonlineusa Cialis Farmacia Online cialis 5 mg Meprate Propecia Low Risk Of Side Effects Purchase Minocycline 100mg Propecia 100mg viagra Cialis Daily Propecia Merck Serono general pharmacy levitra Cialis 20 Mg Precio Farmacia What Is Amoxicillin Bp Cipla Viagra Products Lowest Price Viagra 100mg Canada 2014 cialis 5mg best price Propecia Hipertension 247overnightpharmacy Scam Viagra Professional 100 Mg Generic

JeaShasia (no verificado)

Mar, 26/03/2019 - 20:20

Cialis Inconvenients cialis 5mg Viagra Yahoo Respuestas Propecia Finasteride Acheter Tadalafil 40mg

CoreyElada (no verificado)

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

ukcanadianpharmacy.com candida viagra
canadian pharmacys http://ukcanadianpharmacy.com/
drugs for sale online http://ukcanadianpharmacy.com/#low-cost-viagra-20mg
canadian pharmacy cialis
canada online pharmacy

BrettNus (no verificado)

Vie, 12/04/2019 - 11:49

diflucan estrace hyzaar buy keflex online viagra clonidine colchicine abilify atenolol

Angie (no verificado)

Sáb, 29/03/2025 - 16:33

What's up, I log on to your blog daily. Your story-telling style is
witty, keep doing what you're doing!

Here is my webpage: sex việt nam gái xinh múp nõn

CoreyElada (no verificado)

Sáb, 13/04/2019 - 16:28

canadiantousapharmacy.com northwest pharmacies in canada
canadian mail order pharmacies http://canadiantousapharmacy.com/
canada drugs http://canadiantousapharmacy.com/#viagra-uk
drugs for sale on internet
canadian online pharmacies legal

Saben aquel que... (no verificado)

Sáb, 18/11/2023 - 10:25

Hi! I've been reading your web site for some

time now and finally got the bravery to go ahead and give you a shout out from Kingwood

Texas! Just wanted to mention keep up the good

work!

My website; Jogue Sweet Bonanza

Jesse (no verificado)

Mar, 25/03/2025 - 05:47

Hi there this is kinda of off topic but I was wondering if blogs use WYSIWYG editors or if
you have to manually code with HTML. I'm starting a
blog soon but have no coding experience so I wanted to get guidance from
someone with experience. Any help would be enormously appreciated!

Feel free to visit my site - bet88com1.com

CoreyElada (no verificado)

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

ukcanadianpharmacy.com prescriptions from canada without
no 1 canadian pharcharmy online http://ukcanadianpharmacy.com/
canada online pharmacy http://ukcanadianpharmacy.com/#viagra-from-canada
pharmacy canada 24
canadian pharmacys

CoreyElada (no verificado)

Sáb, 13/04/2019 - 16:51

canadianorderpharmacy.com canadian online pharmacies legitimate
canada medication pharmacy http://canadianorderpharmacy.com/
north west pharmacies canada http://canadianorderpharmacy.com/#buy-viagra-online
canada medications information
canadian pharmacies shipping to usa

CoreyElada (no verificado)

Sáb, 13/04/2019 - 16:57

canadianpharmacyes.com canadian medications by mail
aarp recommended canadian online pharmacies http://canadianpharmacyes.com/
canadian prescriptions online serc 24 mg http://canadianpharmacyes.com/#viagra-generic
pharmacy canada best
canadian online pharmacies reviews

CoreyElada (no verificado)

Sáb, 13/04/2019 - 17:26

canadianpharmacyonl.com canadian pharmacys
northwest pharmacies http://canadianpharmacyonl.com/
canadian pharmaceuticals stocks http://canadianpharmacyonl.com/#low-cost-viagra-20mg
northwest pharmacies mail order
drugstore online canada

Oscar (no verificado)

Sáb, 29/03/2025 - 15:01

I enjoy what you guys are up too. This type of clever work and
coverage! Keep up the wonderful works guys I've incorporated you guys
to my personal blogroll.

Here is my homepage; sex việt nam gái xinh múp nõn

CoreyElada (no verificado)

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

canadianorderpharmacy.com canada pharmacies account
canadian pharmaceuticals online http://canadianorderpharmacy.com/
buy viagrow pro http://canadianorderpharmacy.com/#low-cost-viagra-20mg
canada viagra
drugs for sale on internet

CoreyElada (no verificado)

Sáb, 13/04/2019 - 17:54

canadiantousapharmacy.com canada drugs online
canadian pharmaceuticals companies http://canadiantousapharmacy.com/
canada vagra http://canadiantousapharmacy.com/#viagra-uk
drugs for sale on internet
canadian online pharmacies legal

CoreyElada (no verificado)

Sáb, 13/04/2019 - 17:55

canadianorderpharmacy.com online pharmacies legitimate
drugstore online shopping reviews http://canadianorderpharmacy.com/
online pharmacies http://canadianorderpharmacy.com/#buy-viagra-online
canadian medications 247
pharmacy canada plus

CoreyElada (no verificado)

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

canadianpharmacyes.com the best canadian online pharmacies
trust pharmacy canada http://canadianpharmacyes.com/
canadian pharmaceuticals http://canadianpharmacyes.com/#tadalafil-5mg
canada drug
buy viagra online usa

CoreyElada (no verificado)

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

canadianpharmacyes.com northwest pharmacies online
canadian prescriptions online serc 24 mg http://canadianpharmacyes.com/
northwest pharmacy canada http://canadianpharmacyes.com/#viagra-uk
trusted pharmacy canada
canadian government approved pharmacies

CoreyElada (no verificado)

Sáb, 13/04/2019 - 18:44

canadiantousapharmacy.com online canadian discount pharmacies
northwest pharmacies in canada http://canadiantousapharmacy.com/
canada online pharmacies reviews http://canadiantousapharmacy.com/#viagra-5mg
canadian medications, liraglutide
how safe are canadian online pharmacies

CoreyElada (no verificado)

Sáb, 13/04/2019 - 18:51

canadianorderpharmacy.com canadian medications list
pharmacy http://canadianorderpharmacy.com/
drugs for sale online http://canadianorderpharmacy.com/#viagra-levitra
canadianpharmacy
canada drugs online

Maxwell (no verificado)

Lun, 24/03/2025 - 18:23

hello there and thank you for your information – I've certainly
picked up something new from right here. I did
however expertise a few technical issues using this
website, as I experienced to reload the web site lots of times previous
to I could get it to load properly. I had been wondering if
your web hosting is OK? Not that I am complaining, but sluggish loading instances times will
very frequently affect your placement in google and could damage your high quality score if ads and marketing with Adwords.

Anyway I'm adding this RSS to my email and could look out for much more of your respective
intriguing content. Make sure you update this again very soon.

Feel free to visit my webpage; sex việt nam gái xinh múp nõn

CoreyElada (no verificado)

Sáb, 13/04/2019 - 18:53

canadianorderpharmacy.com viagra canadiense
canadian online pharmacies http://canadianorderpharmacy.com/
canadian medications http://canadianorderpharmacy.com/#low-cost-viagra-20mg
canada viagra
drugs for sale on internet

CoreyElada (no verificado)

Sáb, 13/04/2019 - 18:57

ukcanadianpharmacy.com aarp recommended canadian online pharmacies
canadianpharmacyusa24h is it legal http://ukcanadianpharmacy.com/
canada pharmacies online prescriptions http://ukcanadianpharmacy.com/#buy-generic-viagra
buy viagra 25mg
buy viagra usa

CoreyElada (no verificado)

Sáb, 13/04/2019 - 19:05

canadiantousapharmacy.com canadian medications 247
canadian government approved pharmacies http://canadiantousapharmacy.com/
canadian pharmacy online 24 http://canadiantousapharmacy.com/#viagra-5-mg
safe canadian online pharmacies
drugs for sale deep web

CoreyElada (no verificado)

Sáb, 13/04/2019 - 19:17

ukcanadianpharmacy.com canadian pharmacies without an rx
canada viagra [url=http://ukcanadianpharmacy.com/#]http://ukcanadianpharmacy.com/[/url]
are canadian online pharmacies safe http://ukcanadianpharmacy.com/#viagra-20mg
Northwest Pharmacy
prescription drugs without prior prescription

CoreyElada (no verificado)

Sáb, 13/04/2019 - 19:28

canadianorderpharmacy.com canadianpharmacyusa24h
canada pharmacies account http://canadianorderpharmacy.com/
canadian pharmacies online prescriptions http://canadianorderpharmacy.com/#viagra-5-mg
trust pharmacy canada reviews
drugstore online shopping

CoreyElada (no verificado)

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

canadianpharmacyonl.com pharmacy canada 24
canadian prescriptions online serc 24 mg http://canadianpharmacyonl.com/
order canadian prescriptions online http://canadianpharmacyonl.com/#viagra-20mg
online pharmacies of canada
canadian medications

Napoleon (no verificado)

Mar, 25/03/2025 - 10:11

Thanks for finally talking about > Añadir nuevo comentario | avanzalia.info < Liked it!

Here is my blog: 789p.com

CoreyElada (no verificado)

Sáb, 13/04/2019 - 19:44

canadianorderpharmacy.com reputable canadian prescriptions online
is trust pharmacy in canada legitimate http://canadianorderpharmacy.com/
order canadian prescriptions online http://canadianorderpharmacy.com/#low-cost-viagra-20mg
trusted pharmacy canada scam
canada pharmaceuticals online

CoreyElada (no verificado)

Sáb, 13/04/2019 - 19:48

ukcanadianpharmacy.com canada online pharmacies
canada drugs online http://ukcanadianpharmacy.com/
canadian cialis http://ukcanadianpharmacy.com/#viagra-tablets-australia
online pharmacies tech school
canadian drugs

CoreyElada (no verificado)

Sáb, 13/04/2019 - 19:53

canadianpharmacyonl.com canada medications buy
canadian pharmacies without an rx [url=http://canadianpharmacyonl.com/#]http://canadianpharmacyonl.com/[/url]
pharmacy onesource http://canadianpharmacyonl.com/#viagra-20mg
canadian viagra
online canadian discount pharmacies

CoreyElada (no verificado)

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

canadianpharmacyonl.com canadian pharmacy online 24
canadian rx world pharmacy http://canadianpharmacyonl.com/
pharmacy canada online prescriptions http://canadianpharmacyonl.com/#viagra-5-mg
online pharmacy
canada drugs

CoreyElada (no verificado)

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

canadiantousapharmacy.com buy viagrow
prescriptions from canada without http://canadiantousapharmacy.com/
no 1 canadian pharcharmy online http://canadiantousapharmacy.com/#viagra-5-mg
drugs for sale in canada
reputable canadian prescriptions online

CoreyElada (no verificado)

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

canadianpharmacyes.com northwest pharmacies in canada
prescription drugs without prior prescription http://canadianpharmacyes.com/
aarp recommended canadian online pharmacies http://canadianpharmacyes.com/#tadalafil-20-mg
canada medications buy
canadian rxlist

CoreyElada (no verificado)

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

canadianorderpharmacy.com how safe are canadian online pharmacies
safe canadian online pharmacies [url=http://canadianorderpharmacy.com/#]http://canadianorderpharmacy.com/[/url]
canadian pharmacy world http://canadianorderpharmacy.com/#buy-generic-viagra
canadian online pharmacies rated
canadian rx world pharmacy

CoreyElada (no verificado)

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

canadianpharmacyonl.com buy viagrow pro
pharmacy times http://canadianpharmacyonl.com/
top rated canadian pharmacies online http://canadianpharmacyonl.com/#low-cost-viagra-20mg
canada medication prices
trust pharmacy canada reviews

CoreyElada (no verificado)

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

canadianorderpharmacy.com most reliable canadian online pharmacies
north west pharmacies canada http://canadianorderpharmacy.com/
the best canadian online pharmacies http://canadianorderpharmacy.com/#viagra-uk
legitimate canadian mail order pharmacies
canadian pharmacy king

CoreyElada (no verificado)

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

ukcanadianpharmacy.com canadian medications
canadian pharmacycanadian pharmacy http://ukcanadianpharmacy.com/
drugstore online reviews http://ukcanadianpharmacy.com/#buy-viagra-online
online pharmacy canada
canada medication prices

CoreyElada (no verificado)

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

canadianpharmacyonl.com aarp recommended canadian online pharmacies
canadian pharmacy king http://canadianpharmacyonl.com/
canadian pharmaceuticals reviews http://canadianpharmacyonl.com/#discount-viagra
canadian pharcharmy online24
drugs for sale in uk

CoreyElada (no verificado)

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

canadianorderpharmacy.com canadian pharmaceuticals nafta
canada medications buy http://canadianorderpharmacy.com/
northwest pharmacies mail order http://canadianorderpharmacy.com/#generic-for-viagra
trust pharmacy canada
aarp recommended canadian online pharmacies

CoreyElada (no verificado)

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

canadianorderpharmacy.com good canadian online pharmacies
canadian pharmacy meds http://canadianorderpharmacy.com/
canadian pharmacy no prescription http://canadianorderpharmacy.com/#viagra-levitra
northwestpharmacy
drugs for sale in canada

CoreyElada (no verificado)

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

ukcanadianpharmacy.com canada vagra
canada online pharmacies medication http://ukcanadianpharmacy.com/
canadian pharmacies that are legit http://ukcanadianpharmacy.com/#viagra-levitra
canadian pharmaceuticals for usa sales
cialis from canada

CoreyElada (no verificado)

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

canadianorderpharmacy.com canada drugs online
canadian medications list http://canadianorderpharmacy.com/
canadian pharmacies online prescriptions http://canadianorderpharmacy.com/#viagra-uk
top rated canadian pharmacies online
canadian pharmacies that are legit

CoreyElada (no verificado)

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

canadiantousapharmacy.com canadianpharmacy
canadian pharmaceuticals online http://canadiantousapharmacy.com/
canadianpharmacyusa24h is it legal http://canadiantousapharmacy.com/#viagra-20mg
canadian pharmacies that are legit
canadian discount pharmacies in ocala fl

CoreyElada (no verificado)

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

ukcanadianpharmacy.com canadian online pharmacies legitimate
canadian online pharmacies [url=http://ukcanadianpharmacy.com/#]http://ukcanadianpharmacy.com/[/url]
canada online pharmacies surrey http://ukcanadianpharmacy.com/#low-cost-viagra-20mg
cialis canadian pharmacy
aarp recommended canadian pharmacies

CoreyElada (no verificado)

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

canadianpharmacyes.com canada online pharmacies
the best canadian online pharmacies http://canadianpharmacyes.com/
drugs for sale usa http://canadianpharmacyes.com/#tadalafil-5mg
buy vistagra online safe
canadian pharmaceuticals online

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.