SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member natimage's Avatar
    Join Date
    Apr 2003
    Location
    Colorado
    Posts
    16
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Talking A DWMX Remote MySQL connection that works

    I have been fighting with my Dreamweaver MX connection to remote MySQL host for a couple of weeks now, and finally got it to work last night. Thought I would post a couple of the things I learned through the process. Hope this helps someone out there...

    1) MAKE SURE...BY CONTACTING YOUR HOST (several times if necessary)...that your site account is set to receive remote connections. I could access MySQL through my host...I could set priveleges, users and create databases...however, the account was not set to receive remote connections. They set this up for me within a day of requesting it.

    2) After your account is set, there may be some settings that you have to put in place such as, "host access". I never got a clear answer as to what I needed to put here as a "host address". However, putting "%" allows access from anywhere.

    3) Getting the settings correct!! I read SOOO many things while trying to fix this. Different things. So, I can't guarantee these settings will work for you either. But, I will list my site settings below:

    Remote Info:
    Access: FTP
    FTP Host: ftp.naturalimagesweb.com
    Host Directory: public_html
    (this is the folder that your site loads to)
    Login: *********
    Password: *********
    Passive FTP Box is checked!

    Testing Server:
    Server Model: PHP/MySQL
    Access: FTP
    FTP Host: ftp.naturalimagesweb.com
    Host Directory: public_html
    Login: *********
    Password: *********
    Passive FTP box is checked!
    Url Prefix: http://www.naturalimagesweb.com

    MySQL Connections Dialog Box:
    Connection Name: (whatever you name your connection)
    MySQL Server: IP address
    (see notes below)
    User Name: (a user that has access to MySQL)
    Password: *******
    Database: (you have to specify one of your DBs)

    **note on the MySQL server: some hosts have the MySQL server on the same server as your site. Some hosts have it on a separate server. Some hosts use the same username and password to access MySQL, and some hosts use different usernames and passwords. These are very important things to find out from your host. If they don't want to give you the answers, I would write to them everyday until they get tired of it and answer!! Most importantly, "localhost" DID NOT work for me with this remote connection when I put it in for the MySQL Server. Putting the IP address in was the last change I made that got me the connection!

    4) If you haven't made a connection through any other program, try downloading MySQL Front and make a connection through that program. It's not a big program and is fairly easy to figure out. One hint...leave the port number at the default unless your host tells you that you will have to change it!

    I am CERTAINLY not an expert on the topic of PHP/MySQL or on the topic of Dreamweaver. However, if anyone reads this and has any specific questions...feel free to contact me!! I couldn't have done it without the help of others, so I will gladly give back!!

    Good day...
    Tracy

  2. #2
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks, Tracy. Good tips. The key is that these are MySQL settings not DWMX settings. You should always check with your host about settings like these. For security reasons, many hosts do not permit remote connections. For more information, you should check www.mysql.com and also check your hosting providers FAQ or support center for details.

    Aaron
    Aaron Brazell
    Technosailor



  3. #3
    SitePoint Member natimage's Avatar
    Join Date
    Apr 2003
    Location
    Colorado
    Posts
    16
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Very true...however, it was also VERY important that I had all of those DWMX settings correct!! DW did not prompt me as to any specific setting that was incorrect...I got the same error code everytime, no matter which setting was incorrect! The Url Prefix and the MySQL Server proved especially important! I agree with everything you said though!

    Thanks for the comments!

  4. #4
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by natimage
    Very true...however, it was also VERY important that I had all of those DWMX settings correct!! DW did not prompt me as to any specific setting that was incorrect...I got the same error code everytime, no matter which setting was incorrect! The Url Prefix and the MySQL Server proved especially important! I agree with everything you said though!

    Thanks for the comments!
    Of course it wouldn't! Dreamweaver's job is not to check your data settings. It has no way of knowing what is correct. That's why you need to check with your host. This may sound hard, but don't use DW as a crutch for MySQL. It has MySQL support but you will sell yourself short if you don't understand MySQL on it's own. DW merely gives you a gateway to MySQL and should not be expected to hand-feed you your MySQL. Sorry if I'm coming down hard, I just don't want you to back yourself into a corner. Seen it too many times. Glad you have it working, though.

    Aaron
    Aaron Brazell
    Technosailor




Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •