Unable to change mysql user password using update statement

Question

I am able to change mysql user password using set password method and alter user statement. But, failed with update user command.

mysql> UPDATE USER SET PASSWORD=PASSWORD('George$987') where USER = 'george' and host='localhost'; 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 '('George$987') where USER = 'george' and host='localhost'' at line 1

What is the error in my below statement:

UPDATE USER SET PASSWORD=PASSWORD('George$987') where USER = 'george' and host='localhost';

Bill Karwin · Accepted Answer · 2019-05-01 15:52:30Z

3

I'm guessing you are using MySQL 8.0. You must use SET PASSWORD in MySQL 8.0.

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

PASSWORD(str)

This function was removed in MySQL 8.0.11.

answered May 1, 2019 at 15:52

Bill Karwin

567k87 gold badges710 silver badges870 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Unable to change mysql user password using update statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related