Where is the syntax error in this MySQL command -> update user set authentication_string=PASSWORD("") where User='root';

Question

Am trying to change my settings but I keep getting stuck here! Inside PASSWORD("") brackets is double quotes without white space.

Answer 1

UPDATE mysql.user SET Password=PASSWORD('') WHERE User='root';

Answer 2

Try to use '' instead of ""?!

Answer 3

Programador Autodidacta did work?

Answer 4

CHERIEF Houcine Abdelkader , I tried it too. Same problemo!!!

Answer 5

Is there an attribute which is named User?

Answer 6

Maybe password() doesn't accept a empty string?!