Here we go again--another question about connecting using Dreamweaver to a working Mysql database on a linux server.

I've tried adding the % (any remote ip), and am sure I'm using the correct user_username and user_password and user_databasename; I'm using a Connections file connection--do I also need to use a "script" to connect? I don't think so. I think that's what the Connections file is all about. So it's set up properly in Dreamweaver, but on lunarpages, I get the error:

'I cannot connect to the database because: ' . mysql_error());
        mysql_select_db ("user_contacts");

Any help would really be appreciated. Support won't help me.
Thanks,
Tedra

Nobody responded to my question, but with a little inside help, I did finally get the answer to my  question. If anyone else is having trouble with this, here's what you do:

Don't use the prepended identifier (the 5-character plus underscore domain name identifier that's added when you create a database and user) with your password. Let's say the prepended name is cinem2_ (for domain name cinema.com). Set your username to cinem2_annie, set your database to cinem2_movies, but set your password to simply openup. Don't set it up as cinem2_openup. Isn't that easy. Why has this been so hard to explain? It isn't.

The other option is to use your cpanel username as it is (without the prepended identifier and underscore) and the cpanel password (again, without the prepended identifier). The only thing is, that's the same thing as using root username and password into your databases, and you may want to have individual users and individual accesses to your databases. That's why you'd use the first option.

You'll also need to set up your mysql databases on your own computer (as your testing computer) to  database name cinem2_movies, and username cinem2_annie. OR database name (cpanel name) and username (cpanel username).

Hope that helps everyone with this problem!
Best wishes,
Tedra

Thanks for the update, hopefully somebody will get some good use out of it.