to change password to null

use mysql; update user set password=PASSWORD("") where User='root';

FLUSH PRIVILEGES;