[SOLVED] Error while changing off mysql password

jayakumar01 · 01-10-2012, 10:09 AM

[root@bmw ~]# mysql -uroot -pecare2@
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> UPDATE user SET Password=PASSWORD(‘newrootpassword’) WHERE User=’root’;
ERROR 1046 (3D000): No database selected
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> UPDATE user SET Password=(‘welcome2@’) 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 '��newrootpassword’) WHERE User=’root’' at line 1
mysql>

TenTenths · 01-10-2012, 10:18 AM

RTFS Error:

Yours - WRONG

Code:

UPDATE user SET Password=(‘welcome2@’) WHERE User=’root’;

Right

Code:

UPDATE user SET Password=PASSWORD(‘welcome2@’) WHERE User=’root’;

RTFM - http://dev.mysql.com/doc/refman/5.0/...-password.html