ksmppd icon indicating copy to clipboard operation
ksmppd copied to clipboard

Published 20 hours ago • verified publisher icon kneodev

PASSWORD() was removed in mysql 8

Open bwanakweli4ever opened this issue 3 years ago • 3 comments

Hi Team, i was struggling with PASSWORD() with mysql 8, can i change password hashing or there is a way to adapt ?

bwanakweli4ever avatar Jan 20 '22 11:01 bwanakweli4ever

Same question! We cant compile because of it!

m-faraz avatar Sep 02 '22 11:09 m-faraz

@m-faraz thank you for highlighting that as well, i got stack on this and i haven't got any solution yet , Now trying to use old version of MYSQL

bwanakweli4ever avatar Sep 02 '22 11:09 bwanakweli4ever

select CONCAT('*', UPPER(SHA1(UNHEX(SHA1('mypass')))))

as a replacement for PASSWORD function in users.sql Source: https://stackoverflow.com/a/60243956

m-faraz avatar Sep 02 '22 11:09 m-faraz