修改mysql数据库root密码为空

use mysql
update user set authentication_string='' where user='root';

 

USE mysql;
UPDATE user SET authentication_string=PASSWORD('新密码') WHERE User='root';
FLUSH PRIVILEGES;