Re: mysql query not working in 8.0

[Zach Ellis]

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