Advanced Search

Return to Snippet

Revision: 37330
at December 8, 2010 12:48 by kidmizere
Initial Code 
## Adding and testing AES encrypted password field

DROP TABLE IF EXISTS `testGKAES`;


create table `testGKAES`(
`uid` int(15) not null AUTO_INCREMENT,
`ufname` varchar(15),
`upassword` BLOB,
primary key(`uid`)
);

INSERT INTO testGKAES VALUES('1','user', AES_ENCRYPT('password', 'key') );
INSERT INTO testGKAES VALUES('2','mere', AES_ENCRYPT('balloon', 'key') );
INSERT INTO testGKAES VALUES('3','kurtasg', AES_ENCRYPT('zebra', 'key') );

SELECT * FROM testGKAES WHERE ufname='user' AND upassword=AES_ENCRYPT('password','key');
SELECT * FROM testGKAES WHERE ufname='mere' AND upassword=AES_ENCRYPT('balloon','key');
SELECT * FROM testGKAES WHERE ufname='kurtasg' AND upassword=AES_ENCRYPT('zebra','key');

SELECT AES_DECRYPT(upassword,'key') FROM testGKAES;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Adding and testing AES encrypted password field

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL