Connecting to a mysql database

I am trying to connect to a mysql database that is hosted.
Using my Cpanel i created the database and tables and now I am trying to connect to it from Macromedia MX 2004. I followed all the instructions and I get the acces denied error message. If not at times i get the message that my testing server is not pointing to the root.
I check the configuration at it seems fine.
What am I missing?