There's syntax error, it should be:

$dbh->do("CREATE TRIGGER update_profile AFTER INSERT  ON user
BEGIN
  INSERT INTO profile (user_id) values (new.user_id);
END;");
[download]