> We are on the Basic plan with an upgrade to the Enhanced plan. This will doble the amount of memory available.
$ 80.-/month for 512 MB RAM, $ 110.-/month for 1 GB, both only 10 GB disk space? Whereas the CPU is not even specified? I'm skeptical.
> AT&T set up the Apache and PHP, they also started the MySQL and I had to configure it. I downloaded Moodle and followed the install instructions to get everything up and running.
OK. Must be these instructions http://docs.moodle.org/20/en/Installing_Moodle.
> The Red Hat Enterpise Linux 4 ES has the Linux 2.6.18 and Red Hat 3.4.6N running on a 32 bit system.
Yes, for low memory 32 bit is more suitable.
> As far as the 512 Mb of memory, that is what they offered on their plan. I guess they pretty much sold me a bill of goods, as they also told me they hosted multiple Moodle sites and would be able to give me some help getting problems ironed out, but now they're not as helpfull.
> When I asked them about my MySQL errors, they basically said the it was on me to figure it out and get them resolved.
I hope a MySQL person from the community would help you there.