mysql how to encrypt and decrypt a column using aes

1.8k views Asked by At

I have the following the table named MYTABLE with following columns

  `idMdP` int(11) NOT NULL AUTO_INCREMENT, 
  `login` varchar(255) NOT NULL, 
  `password` varchar(255) NOT NULL,  
  `url` varchar(255) NOT NULL,

I use it only via PHPMYADMIN.

My aim is to :

  • encrypt (AES 256 or AES 512) the password column with a unique key
  • using the key to decrypt the column and visualise all columns via a sql query

Is it possible?

0

There are 0 answers