[root@cdh1 linuxidc]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connectionid is 3
Server version:5.1.73 Source distribution
Copyright (c)2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use mysql;
Reading table informationfor 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=password('123') where user='root';
Query OK,3 rows affected (0.02 sec)
Rows matched:3 Changed: 3 Warnings: 0
mysql> flush privileges;
Query OK,0 rows affected (0.02 sec)
mysql> \q
Bye
12、重启mysql服务
[root@cdh1 linuxidc]# service mysqld restart Stopping mysqld: [ OK ] Starting mysqld: [ OK ]