This Mac OS X FAQ article explains how to run programs at start up, including GUI applications, Unix applications, and starting up Unix applications as "root." Running a MySQL server is explicitly listed as an example.