problem connecting to mysql database with dreamweaver

[Demon]

i have been using dreamweaver to develop my php pages. now that i go to set up a new connection to my mysql database i get and error 1045 access denied for user :"jcox3_test@skyline.websitewelcome.com' using password: yes.

now i have done this before when i 1st joined hostgator about 3 weeks ago and it worked. i have checked my cpanel setting with the mysql hosts and it has my ip address and localhost in it.

not really sure what it happening but i hope it is nothing big.

[GatorJustin]

Demon, does the info in this thread help at all?

http://forums.hostgator.com/showthre...ht=dreamweaver

[Demon]

it did and it didn't. i not entirely shure but when i 1st set up my account at hostgator i had private name servers and with moving my web site had to use your name servers and just noticed that i never switched them back so i will give it another try in a few days after the domain name repropgerates with my name servers

[Demon]

my cpanel is now showing the following error: [Sun Sep 19 13:17:12 2004] [error] PHP Warning: mysql_connect(): Access denied for user: 'jcox3_test@skyline.websitewelcome.com' (Using password: YES) in /home/jcox3/public_html/_mmServerScripts/mysql.php on line 49

i'm not sure if that means that there is something worng with the flie it is looking at or if there is some sort of problem with my dreamweaver mx 2004 setup

[Demon]

sorry to seem like a pain in the rear but is there anything that can be checked on hostgators end. only asking becuase i really wanted to get to do some work on my sites this weekend witht he database backend but really don't want to have to intstall a server on my local machine and have different copies of my databases all over the place.

[Stef]

Demon,

can you confirm that you added an Access Host?
To do this go to your cPanel, select "MySQL Databases" and near the bottom of that screen add an Access Host. Easiest is to use a wildcard (%) in combination with the domain of your ISP like: %.yourprovider.com

Stef.

[Demon]

sorry about that yes i do have both my isp and my outside static ip address in the access host.
i have pcp02004166pcs.plmthm01.pa.comcast.net
and my i ip 68.83.162.115

[Stef]

Demon,

I think there still must be some misconfiguration in your DW settings. I tested this and it works fine for me.
My site definition for 'testing server' has these settings (fake values):

Server model: PHP MySQL
Access: FTP
FTP Host: www.domain.com
Host Dir: <empty>
Login: username@domain.com (or an ftp user you created)
URL Prefix: http://www.domain.com/

Fill out the correct values and press 'Test' to verify this is OK.

The MySQL connection settings are like this:

Connection name: test1
MySQL server: localhost
User name: username_dbuser
Password: <the correct passwd as defined for this dbuser>
Database: username_db

Again, press the 'test' button after filling out the correct values.

Also, try to add this in your access host list (just to be sure): %.comcast.net
You can always remove this afterwards when things are working.

Good luck,
Stef.

[Demon]

You are the man. this is one of my reason that hostgator rocks. i have a problem they help fix it and not just give links to sites with no answer to my questio/problem.

Thanks again

[comage]

I have all the settings correct, that's no problem. But when I click "test" DW squawks that "There is no testing server running on the server machine."

I have authorized my IP, all the names are correct??? What am I missing?

[Stef]

Originally Posted by comage

What am I missing?

I'm not sure. With the settings described above it should work if you use the correct values for Testing server and Database connection.
Do you have another tool to test the connection to your MySQL database, like MySQL Administrator? You don't have a firewall blocking 3306?

Stef.

[getkingnow]

Thanks for all of the inputs I finally got this working using the following settings...First of all my DreamWeaver site is on a virtual domain instead of my primary domain, which complicated the issue.

Assume the following domains www.primarydomain.com and www.virtualdomain.com

In DreamWeaver...
Remote Info:
Access: FTP
FTP Host: www.primarydomain.com
Host Directory: /public_html/virtualdomain/
Login: your cpaneluser
Password: your cpanel password

Testing Server:
Server Model: PHP MySQL
Access: FTP
FTP Host: www.primarydomain.com
Host Directory: <leave blank>
Login: your cpaneluser
Password: your cpanel password
URL Prefix: http://www.primarydomain/virtualdomain

MySQL Connection:
MySQL Server: localhost
UserName: cpaneluser_dbuser
Password: dbuser password
Database: cpaneluser_dbname

Key issue seemed to be with proper use of primary and virtual domain and using localhost for the MySQL connection since DreamWeaver references what you define for the Site settings.

[srush]

Originally Posted by getkingnow

Thanks for all of the inputs I finally got this working using the following settings...First of all my DreamWeaver site is on a virtual domain instead of my primary domain, which complicated the issue.

Assume the following domains www.primarydomain.com and www.virtualdomain.com

In DreamWeaver...
Remote Info:
Access: FTP
FTP Host: www.primarydomain.com
Host Directory: /public_html/virtualdomain/
Login: your cpaneluser
Password: your cpanel password

Testing Server:
Server Model: PHP MySQL
Access: FTP
FTP Host: www.primarydomain.com
Host Directory: <leave blank>
Login: your cpaneluser
Password: your cpanel password
URL Prefix: http://www.primarydomain/virtualdomain

MySQL Connection:
MySQL Server: localhost
UserName: cpaneluser_dbuser
Password: dbuser password
Database: cpaneluser_dbname

Key issue seemed to be with proper use of primary and virtual domain and using localhost for the MySQL connection since DreamWeaver references what you define for the Site settings.

This is the only thing that worked for me. 4 hours of reading posts all over the net including this site. What woked for me... MySQL Server:localhost.

Thanks for replying back with the answer. Most people just fix it and are never heard from again.