Can MySQL 5.0 do ACID Transactions?

Yes. MySQL has supported transactions for years now, since 3.23-Max and all versions 4.0 and above. The InnoDB storage engine offers full ACID transactions with row-level locking, multi-versioning, non-locking repeatable reads, and all four SQL standard isolation levels.