mysql how to encrypt and decrypt a column using aes

1.8k Views Asked by S12000 At 20 October 2024 at 00:43

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?

There are 0 best solutions below