mysql> update user set password=password(‘123456′) where user=’root’ and host=’root’ or host=’localhost’;
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2 Changed: 2 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> update mysql.user set host=’10.168.1.115′ where user=’root’ and host=’localhost’;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
MySQL [mysql]> select host,user,password from user;
+————–+——+——————————————-+
| host | user | password |
+————–+——+——————————————-+
| 10.168.1.115 | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| 127.0.0.1 | root | |
+————–+——+——————————————-+
2 rows in set (0.088 sec)
MySQL [mysql]> update user set password=password(‘123456′) where user=’root’ and host=’127.0.0.1′;
Query OK, 1 row affected (0.088 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MySQL [mysql]> select host,user,password from user;
+————–+——+——————————————-+
| host | user | password |
+————–+——+——————————————-+
| 10.168.1.115 | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| 127.0.0.1 | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+————–+——+——————————————-+
2 rows in set (0.089 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
MySQL [mysql]> delete from user where host=’localhost’;
Query OK, 1 row affected (0.086 sec)
MySQL [mysql]> delete from user where user=”;
Query OK, 1 row affected (0.086 sec)
MySQL [mysql]> select user,host from user;
+——+————–+
| user | host |
+——+————–+
| root | 10.168.1.115 |
| root | 115 |
| root | 127.0.0.1 |
+——+————–+
3 rows in set (0.086 sec)
MySQL [mysql]> delete from user where host=’115′;
Query OK, 1 row affected (0.086 sec)
MySQL [mysql]> select user,host from user;
+——+————–+
| user | host |
+——+————–+
| root | 10.168.1.115 |
| root | 127.0.0.1 |
+——+————–+
2 rows in set (0.086 sec)
MySQL [mysql]> flush privileges;
Query OK, 0 rows affected (0.087 sec)