is there any way you can decrypt the data your encrypt using password() insertted into mysql
coz from inserting data i use insert into table (password) values (password('test'))
RTFM
http://dev.mysql.com/doc/mysql/en/Encryption_functions.html#IDX1466 PASSWORD() encryption is one-way (not reversible).