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:… Continue reading mysql update delete