Thanks so much!
I made a user with full access but still getting the same error. I was able to set up a local version on my computer and installation worked.
I am now thinking the problem is setting up the database on my hosts server. I am not sure that I have access so will contact them. I am hosted through my school’s website so unfortunately it doesn’t seem to be as easy to access as using bluehost etc.
