and follow the prompts from the script to create a password for the mysql user, remove the public test database, etc.

Next, let's fix the startup scripts, because right now only MySQL is running, Apache is stopped. If you reboot the machine, neither will start by default:
cd /etc/rc.d/rc3.d
sudo rm K15httpd
sudo rm K36mysqld

You can adjust the start priorities if you want, this is just a suggestion.

You will probably need to make a few changes to the Apache config file before your website is ready to start up, so:
sudo vi /etc/httpd/conf/httpd.conf

and make any changes you need. Always test your config file before trying to run Apache, it will save you downtime and heartache: just run httpd -t and it will check your syntax.

I always move my web directories and logfiles, etc to a /www directory. If you do this, make sure you update logrotate appropriately. A busy server can run out of space if you don't watch your logfile growth.
sudo vi /etc/logrotate.d/httpd