MySQL的系统库的user数据表如下所示Ysql> select user,host,password from mysql.user;
+-----------+-----------------+---------------------------------------------------+
| user | host | password |
+-----------+-----------------+---------------------------------------------------+
| root | localhost | ∗E56A114692FE0DE073F9A1DD68A00EE |
| root | 127.0.0.1 | |
| root | ::1 | |
| yunjisuan | 192.168.200.173 | ∗B2B366CA5C4697F31D4C55D61 |
+-----------+-----------------+--------------------------------------------------+
1,如何删除passwd字段里,空白的数据行?
( )
2,我想要修改yunjisuan账户的密码,如何操作?
( )