that's the thing. i'm not using my default cPanel username/password to connect to the database. i am using different names to my cPanel name.
all permissions are set correctly and i am setting up the configuration details correctly (it works fine on my localhost). i have edited the username...