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

**URL:** <https://forums.percona.com/t/not-able-to-change-percona-mysql-8-password-in-fresh-install-redhat-8/7847>\
**Category:** Percona Server for MySQL 8.0\
**Created:** [August 5, 2020, 7:03am UTC](https://forums.percona.com/t/not-able-to-change-percona-mysql-8-password-in-fresh-install-redhat-8/7847 "2020-08-05T07:03:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![lokesh123](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lokesh123/32/5519_2.png) [@lokesh123](https://forums.percona.com/u/lokesh123)\
**Post date:** [August 5, 2020, 7:03am UTC](https://forums.percona.com/t/not-able-to-change-percona-mysql-8-password-in-fresh-install-redhat-8/7847/1 "2020-08-05T07:03:26Z")

</div>

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\>

---

<div class="post-metadata">

**Author:** ![vadimtk](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadimtk/32/9528_2.png) [@vadimtk](https://forums.percona.com/u/vadimtk)\
**Post date:** [August 5, 2020, 2:07pm UTC](https://forums.percona.com/t/not-able-to-change-percona-mysql-8-password-in-fresh-install-redhat-8/7847/2 "2020-08-05T14:07:21Z")

</div>

you should use

```auto
SET PASSWORD = 'auth_string';

```

or

```auto
ALTER USER user IDENTIFIED BY 'auth_string';

```