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...<br /><br />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 (TCH)...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 through a help desk ticket!! (See below post by matman for instructions on how to do this yourself.)<br /><br />2) After your account is set, there may be some settings that you have to put in place such as, "host access". Putting "%" allows access from anywhere.<br /><br />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:<br /><br />Remote Info:<br />Access: FTP<br />FTP Host: ftp.naturalimagesweb.com<br />Host Directory: public_html<br />(this is the folder that your site loads to)<br />Login: *********<br />Password: *********<br />Passive FTP Box is checked!<br /><br />Testing Server:<br />Server Model: PHP/MySQL<br />Access: FTP<br />FTP Host: ftp.naturalimagesweb.com<br />Host Directory: public_html<br />Login: *********<br />Password: *********<br />Passive FTP box is checked!<br />Url Prefix: <a href="http://www.naturalimagesweb.com" target="_blank">http://www.naturalimagesweb.com</a><br /><br />MySQL Connections Dialog Box:<br />Connection Name: (whatever you name your connection)<br />MySQL Server: IP address<br />(see notes below)<br />User Name: (a user that has access to MySQL)<br />Password: *******<br />Database: (you have to specify one of your DBs)<br /><br />**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!<br /><br />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!<br /><br />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!!<br /><br />Good day...<br />Tracy<!--content-->
Tracy,<br /><br />Thanks for taking the time to post your findings. Glad you were eventually successful. With your permission, I'd be happy to include the details of your post in <a href="http://www.totalchoicehosting.com/help/" target="_blank">TCH's Help Web Site.</a><br /><br />-kw<!--content-->
Hi,<br /><br />It is no problem at all if you'd like to post it to the help site. Hopefully it will help another TCH customer somewhere down the road!!<br /><br />Thanks and have a great day!<br />Tracy <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/cool.gif" style="vertical-align:middle" emoid="B)" border="0" alt="cool.gif" /><!--content-->
You should be able to enable remote access to your mysql database yourself in cpanel.<br /><br />Click on the "manage MySQL" link/button, then scroll to the bottom. You'll see this:<br /><br /><!--fonto:Courier--><span style="font-family:Courier"><!--/fonto--><u>Access Hosts</u><br /><br />localhost<br /><br />Host (% wildcard is allowed): <!--fontc--></span><!--/fontc--><br /><br /><br />Just add the hostname/IP address of the computer from which you plan to access the database, or the % wildcard will allow access from any host.<br /><br />The way the security model of MySQL works, every user is actually a host/user combination, so each user has a specific host they can access the database from (or, again, the wildcard).<!--content-->
Yep thats brand new with this release of cPanel.<br /><br />Pretty cool huh?<!--content-->
I didn't know I could have done it myself to begin with (setup the server). The online help operator said I had to submit a help ticket!!!<br /><br />And I also was not sure that what I was supposed to put in "host access" was the IP of the computer I'd be connecting from!!<br /><br />Thanks for the tidbits! <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="
" border="0" alt="biggrin.gif" /><!--content-->
Tracy,<br /><br />Thanks for taking the time to post your findings. Glad you were eventually successful. With your permission, I'd be happy to include the details of your post in <a href="http://www.totalchoicehosting.com/help/" target="_blank">TCH's Help Web Site.</a><br /><br />-kw<!--content-->
Hi,<br /><br />It is no problem at all if you'd like to post it to the help site. Hopefully it will help another TCH customer somewhere down the road!!<br /><br />Thanks and have a great day!<br />Tracy <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/cool.gif" style="vertical-align:middle" emoid="B)" border="0" alt="cool.gif" /><!--content-->
You should be able to enable remote access to your mysql database yourself in cpanel.<br /><br />Click on the "manage MySQL" link/button, then scroll to the bottom. You'll see this:<br /><br /><!--fonto:Courier--><span style="font-family:Courier"><!--/fonto--><u>Access Hosts</u><br /><br />localhost<br /><br />Host (% wildcard is allowed): <!--fontc--></span><!--/fontc--><br /><br /><br />Just add the hostname/IP address of the computer from which you plan to access the database, or the % wildcard will allow access from any host.<br /><br />The way the security model of MySQL works, every user is actually a host/user combination, so each user has a specific host they can access the database from (or, again, the wildcard).<!--content-->
Yep thats brand new with this release of cPanel.<br /><br />Pretty cool huh?<!--content-->
I didn't know I could have done it myself to begin with (setup the server). The online help operator said I had to submit a help ticket!!!<br /><br />And I also was not sure that what I was supposed to put in "host access" was the IP of the computer I'd be connecting from!!<br /><br />Thanks for the tidbits! <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="
" border="0" alt="biggrin.gif" /><!--content-->