Not the answer you need?
Register and ask your own question!

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

lokesh123lokesh123 Current User Role Patron
mysql> UPDATE mysql.user SET password=PASSWORD("[email protected]!") 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 '("[email protected]!") WHERE User='root'' at line 1
mysql>


mysql> SET PASSWORD=PASSWORD('[email protected]!');
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('[email protected]!')' at line 1
mysql>

Best Answer

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.