The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Need help with MySQL connections.

Discussion in 'General Discussion' started by howtobeawebmaster, May 13, 2003.

  1. howtobeawebmaster

    Joined:
    Jan 2, 2003
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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 learn@howtobeawebmaster.com

    Thanks,

    John Patrick
     
  2. howtobeawebmaster

    Joined:
    Jan 2, 2003
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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?
     
  3. rfonseca

    rfonseca Member

    Joined:
    Feb 14, 2003
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  4. howtobeawebmaster

    Joined:
    Jan 2, 2003
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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
     
  5. rfonseca

    rfonseca Member

    Joined:
    Feb 14, 2003
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    how about connections.php? check it on the server and make sure the connection info is correct.
     
  6. rfonseca

    rfonseca Member

    Joined:
    Feb 14, 2003
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    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?
     
  7. howtobeawebmaster

    Joined:
    Jan 2, 2003
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Lake Arrowhead, CA.
    You are a genius!

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

    myusername Well-Known Member
    PartnerNOC

    Joined:
    Mar 6, 2003
    Messages:
    691
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    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 user_dbname@name.domain.com (using password: Yes)
     
    #9 myusername, Apr 14, 2004
    Last edited: Apr 14, 2004
  9. internetfab

    internetfab Well-Known Member
    PartnerNOC

    Joined:
    Feb 20, 2003
    Messages:
    336
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Gothenburg, Sweden
    cPanel Access Level:
    DataCenter Provider
Loading...

Share This Page