请问linux 下这连接到mysql后,要修改root用户的密码,应用这个命令:
mysql> mysqladmin -uroot -p123456 password abcd123;
出现下面的错误提示,该怎么改呢?谢谢您了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 'mysqladmin -uroot -p123456 password abcd123' at line 1
mysql> Aborted
mysql> mysqladmin -uroot -p123456 password abcd123;
出现下面的错误提示,该怎么改呢?谢谢您了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 'mysqladmin -uroot -p123456 password abcd123' at line 1
mysql> Aborted
mysql> SET PASSWORD FOR 'bob'@'%.loc.gov' = PASSWORD('newpass');
mysql> SET PASSWORD = PASSWORD('biscuit'); -- 改当前用户的密码
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
退出后还不对啊!
liusi@ubuntu:~$ mysqladmin -u root -p 123456 password abcd123;
Enter password:
mysqladmin: Unknown command: '123456'
还出现这个错误
mysql> set password for 'root '@'%.loc.gov' = password( 'abcd123' );
ERROR 1133 (42000): Can't find any matching row in the user table