Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

PASSWORD() was removed in mysql 8 #154

Open
bwanakweli4ever opened this issue Jan 20, 2022 · 3 comments
Open

PASSWORD() was removed in mysql 8 #154

bwanakweli4ever opened this issue Jan 20, 2022 · 3 comments

Comments

@bwanakweli4ever
Copy link

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

m-faraz commented Sep 2, 2022

Same question! We cant compile because of it!

@bwanakweli4ever
Copy link
Author

bwanakweli4ever commented Sep 2, 2022 •
edited
Loading

@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
Copy link

m-faraz commented Sep 2, 2022

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

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@m-faraz @bwanakweli4ever