Mysql on subdomain

I’m trying to utilize a mysql database in a subdomain. The only way I can get it to connect is to add the main domain as a target (located in public_html) but I would rather have the subdomain as it’s own project