Closed

Mysql AES_DECRYPT problem. Not being able to decrypt the password

A freelancer developed for me a wordpress plugin that let users input some data, and the data is then ecrypted using AES and then saved on my database.

He used phpseclib.

The plugin he made is able to decrypt the passwords for me, but the thing is, I need to be able to decrypt them using MySQL queries.

I'm using mysql 5.6.

When I execute queries like this:

SELECT AES_DECRYPT(FROM_BASE64(`password`), MD5('encryption)_key')) FROM sometable;

It returns a null value.

I need you to look on the source code and figure out what's going on, or provide me a way to decrypt the passwords using mysql queries.

Skills: MySQL, PHP

See more: aes_decrypt, what i need to be a freelancer, password freelancer, freelancer wordpress database, freelancer problem, freelancer being a freelancer, being freelancer, being a freelancer, wordpress database freelancer, mysql freelancer, aes, aes source code, decrypt source, md5 wordpress, decrypt aes, md5 decrypt wordpress, wordpress mysql data, php code input mysql data, null plugin, code md5, decrypt md5 password wordpress, decrypt password wordpress, decrypt wordpress md5, wordpress md5 decrypt, decrypt md5 wordpress

About the Employer:
( 22 reviews ) Boston, United States

Project ID: #5423943

6 freelancers are bidding on average $23 for this job

hvtuananh

A proposal has not yet been provided

$30 USD in 1 day
(127 Reviews)
6.1
jorgovan

Hello. Could you send exported table from database with at least one row inside... and key . Thanks Koran

$20 USD in 1 day
(17 Reviews)
4.3
carivera

Hello, In 5+ year of experience working with PHP & MySql, HTML5, Jquery, CSS, ASP.NET, VB.Net, MS SQL Server I have acquired a good set of skills that might be of help for your project. I'm a very hard-working prof More

$30 USD in 1 day
(7 Reviews)
4.3
maurojosipovic

hi, please send me your file source code so i can check it out whats wrong with it; i work all the time with 3th party maded scripts for someone who cant get in contact with person who made script; thanks

$20 USD in 2 days
(7 Reviews)
1.8
yasir196

Hashing is not encryption (it is hashing), so we do not "decrypt" MD5 hashes, since they were not "encrypted" in the first place. Hashing is one-way, but deterministic: hash twice the same value, and you get twice t More

$25 USD in 1 day
(2 Reviews)
1.6
johnrocks01

he i am a web developer i have 3 year experience in web development. i can do this work right now. so give me ftp lets start

$15 USD in 1 day
(1 Review)
0.4