Remote Access to MySQL Server

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Re: Remote Access to MySQL Server

Postby Narrowboyy » 12. April 2010 01:21

That's better now it is much clearer to see your issues.


The confusion you are experiencing seems to be caused by the terms local and remote.

Local and remote in your case are the same because you have selected to edit and test locally then upload the finished site - mysite.net does not come into the equation until you are ready to upload your site to a hosting provider.
(I found the Advanced Tab was easier to figure out).


Editing Files
The address should be:
http://localhost/mysite
Because you will edit and test locally and then upload the completed web site to your hosting provider.


Editing Files Part 2 and Part 3 are correct.


Testing Files
Because you are testing locally...
The folder should be:
C:\xampp\htdocs\mysite\

Testing Files Part 2
The address should be
http://localhost/mysite
and should be tested when Apache and MySQL in XAMPP are started - you should get the success window.

(Unless, of course, you have a VirtualHost configuration set up in xampp\apache\conf\extra\httpd-vhosts.conf file for your mysite.net domain to run locally which would require a different configuration in DW).

The reason you are getting a success window testing the mysite.net:80 address is DW is going to your domain name mysite.net hosting provider web site and not to your testing server site which is localhost in XAMPP.

The above is one of those confusion issues - forget about mysite.net in this configuration because you are editing and testing locally then uploading a completed and tested web site to your mysite.net hosting provided service (via FTP perhaps).



MySQL Image 1
In all these DW MySQL Windows the Help button has a detailed explanation for the entries required.
(you can leave the database settings in phpMyAdmin to Any host or you can revert them to localhost, your choice).

Connection name: accers
Only a DW requirement

MySQL server: localhost
You don't have a server defined in XAMPP for mysite.net even though Any host is configured.
Stick to localhost for this exercise or use the loop back IP 127.0.0.1

Username: webmaster
Make sure this and the password are correct for the database name you will provide below.

Password: *****

Database: db
This has to be the name of the database you created for your website in phpMyAdmin.
If MySQL is started then when you click on Select a database and if the above credentials are correct then DW should be able to connect and give a list of databases to select from that the above Username and Password are associated with.

If the details in the MySQL windows are incorrect then you will be presented with a 2003 error, which you have already experienced.



Anything you don't understand after trying the above then I will see if I can clear the fog - I have DW and can simulate you issues.

Now you can realize that to help you, all we need is clear and concise details, as no one here can see your screen or know what you have done or what you intend to do unless you give as much detail as possible about an issue.

Another tip.
Try and brake up your post into readable sections by separating each sentence with a carriage return, instead of, like your first post, just one big jumbled up paragraph which is very difficult to read.

I hope this is helpful and you get it working and can move forward but please realize that topics related to DreamWeaver are not 'on topic' in these XAMPP forums and may be deleted by any competent forum Moderator.
Narrowboyy
 
Posts: 64
Joined: 16. February 2009 02:56

Re: Remote Access to MySQL Server

Postby pvtryan » 12. April 2010 02:08

No, you're misunderstanding.

In the third picture it says "Edit locally, then upload to remote testing server," not "Edit and test locally." The testing server is NOT on my computer - I already know how to (and have before) set up XAMPP on localhost. The server I want to test on is remote.
pvtryan
 
Posts: 16
Joined: 10. April 2010 21:57

Re: Remote Access to MySQL Server

Postby Narrowboyy » 12. April 2010 02:25

Then images 3 and 4 are incorrect as you are telling DW to connect locally and to the c:\xampp\htdocs folder not your remote testing server and its site location directory also as is your database connection for the remote testing server.

Please read the DW documentation (Help files) and visit the DW forums to ask more questions about configuring a simple wizard like the one in DW because you obviously don't know what you are doing.

This forum is for XAMPP for Windows issues only and as far as I can tell XAMPP is working as it should.
Narrowboyy
 
Posts: 64
Joined: 16. February 2009 02:56

Re: Remote Access to MySQL Server

Postby pvtryan » 12. April 2010 03:11

I'm sorry for wasting your time, but I was desperate to finish my site. I've been unable to contact the owner of the server for two days and he just came on - it turns out the server was sitting behind not one, but two router/firewalls. He just forwarded port 3306 for me and everything's working fine. Once again, sorry.
pvtryan
 
Posts: 16
Joined: 10. April 2010 21:57

Previous

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 77 guests