Not able to change percona mysql 8 password in Fresh install redhat 8.

mysql> UPDATE mysql.user SET password=PASSWORD(“A$d@123!”) WHERE User=‘root’;ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘(“A$d@123!”) WHERE User=‘root’’ at line 1mysql>

mysql> SET PASSWORD=PASSWORD(‘A$d@123!’);ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘PASSWORD(‘A$d@123!’)’ at line 1mysql>

you should use

SET PASSWORD = 'auth_string';


or

ALTER USER user IDENTIFIED BY 'auth_string';