Jiri George Moudry has taken the time to put together a Linq provider for MySql. It looks like it is still pretty raw, and needs a lot more work, but its a great start, and a preview of where we are heading.
I am looking forward to full Linq searching in MOSS 2007.