mysql -h remote.host.com -u remoteuser -p

grant all privileges on {database_name}.* to {database_user}@'%' identified by 'their_password';

revoke usage on {databse_name}.* from {database_user}@'%';

drop user {database_user}@'%';

create trigger {trigger_name} before [update|insert|delete] on {table_name}
	for each row begin
		insert into {new_table} (col1, col2, col3) values (OLD.col1, OLD.col2, OLD.col3)
	end

create trigger {trigger_name} after [update|insert|delete] on {table_name}
	for each row begin
		insert into {new_table} (col1, col2, col3) values (OLD.col1, NEW.col2, OLD.col3)
	end

load data local infile 'file_name.csv' into table table_name
	fields terminated by ',' enclosed by '"'
	lines terminated by '\n'

	(col1, col2, coln, ...)