I agree that a great project for a beginner to PHP and MySQL would be to make a simple CMS. If you want a good tutorial, here is one.

When building it, try to make sure that you understand how everything works and how it all goes together. And then when you're finished, spend some time coming up with new features and trying to add them in.