I can’t seem to get my database working properly. Yesterday evening (about 22 hours ago), I added the database through Goodies>MySQL, then added the user, then added the hostname (mysql.projects.redliontech.com).
It looks like you did #3 (adding it as a subdomain). You do not want to do that. It will cause you problems. You should remove the subdomain under “domains -> manage”, and wait a few hours for the DNS to update again.