Need help with MySQL connections.

Jan 2, 2003
12
0
151
Lake Arrowhead, CA.
I want to be able to connect to MySQL databases that I install using CPanel.

I'm designing in php and would like to have the Live Data function in Dreamweaver MX working.

Can someone guide me to an explination of how this is done?

I don't want it via root access, I want it via shared access.

You see I am creating a lesson on how to do design in php and MySQL with Dreamweaver MX, using CPanel as the back end control panel.

I'm also willing to pay a consultant to walk me through this so that I can start this course soon.

My email is [email protected]

Thanks,

John Patrick
 
Jan 2, 2003
12
0
151
Lake Arrowhead, CA.
Been There, done that, but still dosn't connect.

I placed the wildcard, I've put in my IP, I've used ip with wild card, but I still get the following error.

HTTP Error code 404 File No t Found
_mmserverscripts/MMHTTPDB.php

Any idea where I can get that file?
 

rfonseca

Member
Feb 14, 2003
21
0
151
From the Macromedia Site ->

*********paste**************

Re-deploy the script files in the _mmServerScripts folder

Dreamweaver uses two PHP scripts when testing the MySQL database connection. Upon clicking the Test button in the MySQL connection dialog box, the mysql.php and MMHTTPDB.php files are copied to the web server and placed in the _mmServerScripts directory.

Sometimes it is necessary to completely delete these two files from the web server and allow Dreamweaver to re-deploy the files to the web server. Alternatively, you can manually copy these two files to the web server and place them in the _mmServerScripts directory. The original versions of these two files can be found in the following locations:

Windows: C:\Program Files\Macromedia\Dreamweaver MX\Configuration\Connections\Scripts\PHP_MySQL\_mmDBScripts
Mac OS X: Hard Drive:Applications:Macromedia Dreamweaver MX:Configuration:Connections:Scripts:PHP_MySQL:_mmDBScripts

************/paste****************

Full article here:
http://www.macromedia.com/support/dreamweaver/ts/documents/unidentified_error_mysql.htm#updater

Also, update to 6.1 if you haven't yet.

hth
 
Jan 2, 2003
12
0
151
Lake Arrowhead, CA.
Thanks for finding that, however....

I had just finished trying that, plus I tried to change the include command.

Looked in my php.ini and found no include= statement, so I added it there just to be sure, and still get the same error.

I'll keep searching, thanks for your help.

JP
 

rfonseca

Member
Feb 14, 2003
21
0
151
how about connections.php? check it on the server and make sure the connection info is correct.
 

rfonseca

Member
Feb 14, 2003
21
0
151
Originally posted by rfonseca
how about connections.php? check it on the server and make sure the connection info is correct.
doh! nevermind!

I found that the mmserverscripts/MMHTTPDB.php was above the public_html so that's why it could not be found (404). After I moved the folder down below public_html everything worked fine. Maybe this is ocurring with you too?
 
Jan 2, 2003
12
0
151
Lake Arrowhead, CA.
You are a genius!

That was it, Thanks for your help rfonseca. Your dedication to my problem was much appriciated.
 

myusername

Well-Known Member
PartnerNOC
Mar 6, 2003
693
1
168
chown -R us.*yourbase*
cPanel Access Level
DataCenter Provider
Twitter
I have a similar issue.

The _mmServerScripts is located in public_html , I see this via ws_ftp. However when I refresh the site in Dreamweavers internal site manager, that folder does not appear. I removed its contents from the remote server via ftp and redeployed it via "test connection" for sql. The folder and its contents re-appear in public_html.

However running the test connection for mysql gives:

the 404 error.....

Anyone have any suggestions?

*************
Edit
*************

Okay I switched everyting to public_html/ from www/ and that at least gets me to connect, however it now says access denied.

I setup a remote access host in cpanel for my ip 111.222.333% and also just %

And then use both the server main IP or localhost for the server

user: user_dbname
pass: pass
dbname: db_user

Any thoughts on what I may be doing wrong?

The actual error is:

1045 Access denied for user [email protected] (using password: Yes)
 
Last edited: