So I want to make an update in MySQL where a value is updated if two conditions are true. So I have data in columns name and status. If the name and status match foo and d, then I want to change ...

Securing your MySQL installation isn't difficult. Find out how to easily harden MySQL with one command.