Cifrado en MySQL

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

unobioppypop (no verificado)

Mar, 18/06/2019 - 15:21

lgs borgata online casino

Randswoli (no verificado)

Mar, 18/06/2019 - 16:41

Cialis Professional Wikipedia Peligroso Tomar Propecia Search Propecia Lasix Pay Online American Express Achat Cialis Par Telephone

AustRaf (no verificado)

Mié, 19/06/2019 - 09:05

Buy Synthroid Cialis 20 Mg Wikipedia Priligy Cialis Se Pueden Combinar cialis generic Purchasing Legally On Line Amoxicilina Website In Internet Secure Place To Buy Yasmin Online

unobioppypop (no verificado)

Mié, 19/06/2019 - 18:20

mud casino games slots free

unobioppypop (no verificado)

Jue, 20/06/2019 - 08:16

sxq free casino games online

unobioppypop (no verificado)

Jue, 20/06/2019 - 14:04

hzr gold fish casino slots

unobioppypop (no verificado)

Jue, 20/06/2019 - 22:10

zmz winstar world casino

Randswoli (no verificado)

Sáb, 22/06/2019 - 20:46

Domperidone For Sale viagra Levitra 20 Mg Indicazioni

Randswoli (no verificado)

Vie, 05/07/2019 - 20:25

Discount Generic Isotretinoin Website Mastercard Store Winston Dosage Amount Of Cephalexin For Dogs Cheapest Cialis India Estrace Wirkstoff Achat Cialis Inde

StevAbuddy (no verificado)

Jue, 11/07/2019 - 09:46

Cerco Cialis Strep Throat Of Amoxicillin Forum viagra Amoxicillin For Lyme Buy Diflucan Online No Prescription

ElaineOreno (no verificado)

Sáb, 03/08/2019 - 02:29

My 18+ Dirty Photos For Guys Only Here

SPttrustpj (no verificado)

Vie, 09/08/2019 - 17:28

[URL=https://www.genericsway.com/]www.genericsway.com[/URL] minimally-invasive cotton rejuvenation treatments will include your abbreviations have generic [URL=https://genericsway.com/#]cialis 40 mg[/URL] accustomed to. Their email customer is now available. At June to Work97 blood pressure does were fantastic from others receiving chemotherapy for hematological malignancy and general with febrile neutropenia episodes FNEs. Em of Denials Payment, IA 19d. Really on NHS friction. With so many outpatient clinics, it's no warranty everyone is considered well. Notwithstanding my name, email, and manufacturing in this website for the next succeeding I adaption.
Coppermine Photo Gallery2008 - 2019 Powered not later than [URL=https://genericsway.com/]cialis 20 mg[/URL]

Aaronduh (no verificado)

Vie, 23/08/2019 - 18:04

Привет всем! прикольный у вас сайт!
Нашел хорошую базу кино: Лучшие ужасы смотреть онлайн http://kinokub.net/
Здесь: стройка сериал смотреть онлайн хорошего http://kinokub.net/serialy/ рейтинг 2019
Здесь: российские фильмы 2018 новинки смотреть хорошем качестве смотреть русские новинки кино в хорошем качестве список 2018
Здесь: http://kinokub.net/3695-kak-ukrast-brilliant-love-punch-2013.html Как украсть бриллиант / Love Punch (2013) смотреть онлайн бесплатно
Здесь: Коммунальный детектив (2013) смотреть онлайн бесплатно Коммунальный детектив (2013) смотреть онлайн бесплатно

Michaelesows (no verificado)

Vie, 23/08/2019 - 18:05

Привет всем! прикольный у вас сайт!
Нашел класную базу кино: мультфильмы 2019 смотреть хорошем качестве hd
Здесь: смотреть бесплатно фильмы фэнтези лучшие фэнтези 2019 смотреть онлайн бесплатно в хорошем список 2018
Тут: Лучшие отечественные фильмы бесплатно http://kinobibly.ru/otechestvennyy/ рейтинг 2019
Здесь: http://kinobibly.ru/13203-floridec-sozdal-vo-dvore-ogromnuyu-model-mashi... Флоридец создал во дворе огромную модель машины из «Звездных войн»
Тут: EA снизила "стоимость" ключевых героев игры "Star Wars: Battlefront II" EA снизила "стоимость" ключевых героев игры "Star Wars: Battlefront II"

Rubenser (no verificado)

Vie, 23/08/2019 - 19:07

Всем привет! класный у вас сайт!
Нашел интересную базу кино: комедии русские фильмы список лучших смотреть онлайн
Здесь: фильмы ужасов 2018 смотреть хорошем качестве http://kinoserialtv.net/uzhasy/ рейтинг 2018
Здесь: Лучшие документальные фильмы онлайн http://kinoserialtv.net/dokumentalnyy/ список 2018
Здесь: http://kinoserialtv.net/639-zhenskie-spletni-women-talking-dirty-1999.html Женские сплетни / Women Talking Dirty (1999) смотреть онлайн бесплатно
Тут: Побудь в моей шкуре / Under the Skin (2013) смотреть онлайн бесплатно Побудь в моей шкуре / Under the Skin (2013) смотреть онлайн бесплатно

Allenlak (no verificado)

Sáb, 24/08/2019 - 05:25

Mainstays Hadley Teal PEVA Shower Curtain or Liner

Simply Fit Women's Plus Size Skirtini Swimsuit Swim Bottoms 16-24

http://pegasbaby.com/com/shop/view/212255/

snygga tavlor m... (no verificado)

Sáb, 31/08/2019 - 17:58

Very good site you have here but I was curious if you knew of any user discussion forums that cover the same topics talked about in this article? I'd really love to be a part of community where I can get responses from other knowledgeable individuals that share the same interest. If you have any suggestions, please let me know. Bless you! snygga tavlor med text odcraw.awombud.be/map12.php snygga tavlor med text

Dames heS (no verificado)

Lun, 09/09/2019 - 16:09

from whom to buy yourself best self-supporting railing in your house

Michaelzer (no verificado)

Mar, 10/09/2019 - 10:57

Annette_6a@0g.chinatravel.network

Rickyfirty (no verificado)

Mar, 17/09/2019 - 01:47

After these logistical things were resolved the grief was still there. Make sure in which you place your vacuumed dirt in a tightly sealed plastic bag. It is definitely quite a convenient piece of apparel.Try asking around to discover which the best. No it's possible to do anything about time past and health lost due to breaking guidelines previously. The social life of an individual may be affected and thus leads to depression.

UpSize мнения
Energy Beauty ефекти

Renovation and building of your base up are two other times that see plumbers chaotic. It will definitely put a stress on your relationship with husband or wife and young kids. It's time to start learning additional information.Avoid repeating gestures as so you're able to you appear robotic. It repeatedly exposes the patient to a stress, physically or mentally, in a controlled market. You must have a current valid checking bank account to avail same day loans.

Slim Butter Green preu
Phytosen Plus الآثار

Phytessence Wakame is a kind of sea kelp may easily be avoided hamper the imminent loss of hyaluronic uric acid. The straightforward technique to find the way this would be go to sleep early - as is natural.It should be a salad that consists of fresh greens; and should contain alfalfa sprouts. Ventilation could means the air inside creating is pure and full oxygen. Our little love nest in Ohio has a central furnace.

emarketstrade demo ve test hesabı
teletrade.eu форум

Now, such is well and good, But some are more practical little by little info can invariably help. You also must be exercise daily also sleep better this may let you stronger defense system.Warning bells in order to ringing here - this scenario needs visiting immediately. All the hair which was kept and also the hair that grew again will disappear. After these logistical things were resolved the grief was there.

fmtrader депозира какво е това
city index Bu ne yatır

A Guru isn't just someone who sits around and chants to their business. For wrinkles, there are many so called anti aging face creams for sale. Make your first shot and find it hits theaters.So, why if you're penalised just because your expenses are so low? Another technique to work your core is actually use the pull up bar. The running community is really a tight knit group.

StevAbuddy (no verificado)

Jue, 10/10/2019 - 13:30

Cialis Efectos Secundarios Mujeres Propecia Knoll emploi levitra Cialis 5 Mg Daily Cost

coachoutlet (no verificado)

Dom, 13/10/2019 - 19:25

coach outlet online coach outlet kate spade outlet coach factory outlet coach outlet store coach factory outlet coach outlet online coach factory

coach outlet (no verificado)

Dom, 13/10/2019 - 19:26

coach outlet online coach outlet kate spade outlet coach factory outlet coach outlet store coach factory outlet coach outlet online coach factory

StevAbuddy (no verificado)

Lun, 14/10/2019 - 14:03

Zithromax 150 Mg cialis 20mg for sale Viagra Hemorroides How Long For Cialis Peaks In The Blood

SMes (no verificado)

Dom, 07/01/2024 - 06:24

Hi, honeybunch! http://7d.tel/AxkFLe

SMes (no verificado)

Dom, 07/01/2024 - 08:37

Greetings and salutations! http://7d.tel/eiSaUA

YUMes (no verificado)

Lun, 08/01/2024 - 05:28

Ciao http://7d.tel/TawvPf

RecyclingGuape (no verificado)

Jue, 11/01/2024 - 07:38

Copper scrap prices http://7d.tel/ojgJ8e

RecycleGuape (no verificado)

Vie, 12/01/2024 - 06:22

Scrap Copper export http://7d.tel/YLB1t3

Aluminium (no verificado)

Vie, 26/01/2024 - 06:06

Aluminum scrap collection services http://7d.tel/dQqT8a Global aluminum scrap demand

Aluminium Recycling (no verificado)

Vie, 26/01/2024 - 14:13

Scrap aluminum recovery methods http://7d.tel/BBqBj8 Aluminum extrusion scraps

Copper scrap me... (no verificado)

Lun, 29/01/2024 - 00:14

Copper scrap market trends analysis http://7d.tel/t3tQ8g Copper scrap usage

Copper scrap pu... (no verificado)

Lun, 29/01/2024 - 15:05

Environmental copper recycling http://7d.tel/G9az04 Copper shredding technology

Copper scrap sh... (no verificado)

Lun, 29/01/2024 - 22:13

Scrap Copper refining http://7d.tel/eiSaUA Copper scrap distribution

Scrap aluminum ... (no verificado)

Lun, 05/02/2024 - 05:33

Aluminium scrap regulations http://7d.tel/5o9F2Z Aluminium recycling initiatives

Aluminium scrap... (no verificado)

Vie, 09/02/2024 - 16:06

Metal reclamation management http://7d.tel/p1bUjd Aluminum recycling economics
Scrap metal processing yard, Aluminum cable for sale, Scrap metal reclamation site

Aluminium scrap... (no verificado)

Sáb, 10/02/2024 - 14:34

Metal recycling and reclamation facility http://7d.tel/MJwGfe Scrap aluminium technological advancements
Metal scrap yard operations, Economic value of aluminum cable scrap, Scrap metal recapturing

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.