I have connected to mysql client. I try to set the password for mysql. However, everytime when I typed in SET PASSWORD FOR 'root'@'localhost' = PASSWORD('WENG');
It shows me "access denied for user''@'localhost' to database 'mysql'. I am really confused where I got wrong.