Once again, I hope this helps out someone else as I've seen similar problems mentioned below.
I found that I could only start and run the mySQL server if I was logged in as the mySQL user. I was having problems with the chown statement. If I logged out, then back in again everything would work, but if I shutdown first, then logged in as a user other than the mySQL user I was back at square one.
To fix the problem I logged back in as the mySQL user, started up the mySQL server, logged out and back in again as another user, downloaded and ran Lyniage's StartupItem package, and everything has worked just fine since.
Hope this helps someone.