search

kneodev / ksmppd

Kurt's SMPP Daemon (SMPP Server for Kannel)
Other
56 stars 38 forks source link

PASSWORD() was removed in mysql 8 #154

Open bwanakweli4ever opened 2 years ago

bwanakweli4ever commented 2 years ago

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

m-faraz commented 2 years ago

Same question! We cant compile because of it!

bwanakweli4ever commented 2 years ago

@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

m-faraz commented 2 years ago

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

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