need help with mysql

3 posts · originally from https://geek.digit.in/community/threads/need-help-with-mysql.135774/

i hav been tryin to place a password for my mysql database,bt i awlways gets this error

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 'use mysql

the code is:
mysql> use mysql
Database changed
mysql> UPDATE user
-> SET Password=PASSWORD<'nanana'>
-> WHERE user='root' ;

can any one tell whts wrong???

try using

mysql> UPDATE mysql.user SET Password = PASSWORD('newpwd')
-> WHERE User = '';
mysql> FLUSH PRIVILEGES;

ref: *dev.mysql.com/doc/refman/5.0/en/default-privileges.html

tried that too,doesnt seem to work

i was learning mysql from a tutorial(lynda.com),in thw video the guy changes his password,but when i try to do the same it gives the error

thnks for the effort