MySQL Forums
Forum List  »  Newbie

Re: mysql query not working in 8.0
Posted by: Zach Ellis
Date: October 02, 2023 12:12PM

Hello Tax

I'm new to mysql dba so if someone more experienced comes go with them

here are some threads about the same problem you have might have the answer

https://stackoverflow.com/questions/52320576/in-mysql-server-8-0-the-password-function-not-working

https://stackoverflow.com/questions/58732542/recover-the-passwords-created-using-password-in-mysql-8


the password() encryption function is deprecated in 8.0 it suggests SHA2()

here are some manual links

https://dev.mysql.com/doc/refman/8.0/en/set-password.html

https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#function_password

regards
Zach Ellis

Options: ReplyQuote


Subject
Written By
Posted
Re: mysql query not working in 8.0
October 02, 2023 12:12PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.