c_pattle Posted September 29, 2012 Share Posted September 29, 2012 I've began work on a project recently and all of the password in the database have been encryped using the mysql password function. I was just wonder if there is a PHP function that is equalivalent to that. So the PHP function will return the same result as they mysql function? Thanks for any help Quote Link to comment https://forums.phpfreaks.com/topic/268913-php-enquivalent-to-mysql-password-function/ Share on other sites More sharing options...
Christian F. Posted September 29, 2012 Share Posted September 29, 2012 I recommend reading this article about secure login systems, as it should give you all the information you need to complete your project. As you probably have discovered yourself, using the MySQL function is not recommended, and you will not want to use a PHP function that returns the same result. As that would be a simple SHA1 hash, which is insufficient for new systems today. Quote Link to comment https://forums.phpfreaks.com/topic/268913-php-enquivalent-to-mysql-password-function/#findComment-1381769 Share on other sites More sharing options...
Pikachu2000 Posted September 29, 2012 Share Posted September 29, 2012 The MySQL PASSWORD() function uses SHA1(UNHEX(SHA1('string being hashed'))). Quote Link to comment https://forums.phpfreaks.com/topic/268913-php-enquivalent-to-mysql-password-function/#findComment-1381772 Share on other sites More sharing options...
jazzman1 Posted September 29, 2012 Share Posted September 29, 2012 I've began work on a project recently and all of the password in the database have been encryped using the mysql password function I'm not sure that you know differences between encryption and hashing. Quote Link to comment https://forums.phpfreaks.com/topic/268913-php-enquivalent-to-mysql-password-function/#findComment-1381779 Share on other sites More sharing options...
Barand Posted September 29, 2012 Share Posted September 29, 2012 Also, note this extract from the MySQL manual/PASSWORD() function Note The PASSWORD() function is used by the authentication system in MySQL Server; you should not use it in your own applications. Quote Link to comment https://forums.phpfreaks.com/topic/268913-php-enquivalent-to-mysql-password-function/#findComment-1381781 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.