Remote Access to MySQL Server

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

Remote Access to MySQL Server

Postby pvtryan » 10. April 2010 22:11

Firstly, I DID try searching the forums, didn't really get me anywhere (sorry).
The problem is that I can't connect remotely to the MySQL server through Dreamweaver (it kept giving me 403 errors), which I need to do so that I can finish creating my site. I have a remote desktop connection to the server, so I can do anything that is necessary. I also have FTP, and I can access the XAMPP and PHPMyAdmin control panels remotely. I was previously blocked from getting to the XAMPP and PHPMyAdmin CP's, but it let me in after I edited the xampp-httpd.conf file (or something like that, don't quite remember the name), however, I still can't get to the MySQL server through Dreamweaver. I, of course, already created a new user with a password, and set it to be able to connect from "Any Host" in PHPMyAdmin. So I'm assuming that there is a file somewhere pertaining to the MySQL server that I have to edit for it to let me in. Oh and I know that I put the correct information into Dreamweaver, except maybe one thing: in the "MySQL server" field I put mydomain.com (obiously not what I actually put), and I was wondering if I need to do MySQL.mydomain.com or mydomain.com:3306 (MySQL server port) or something like that. Thanks.
pvtryan
 
Posts: 16
Joined: 10. April 2010 21:57

Re: Remote Access to MySQL Server

Postby Narrowboyy » 11. April 2010 01:45

When ever you get a server error like a 403 always check the \xampp\apache\logs\error.log file for clues.

To access your database from another location other than localhost then you need to change the database host from "localhost" (accessible only from the PC it is installed on) to "any host".

See here:
viewtopic.php?f=16&t=40130&p=159061#p159061
Narrowboyy
 
Posts: 64
Joined: 16. February 2009 02:56

Re: Remote Access to MySQL Server

Postby pvtryan » 11. April 2010 02:02

The error log didn't help, and unless you mean something other than what I did in PHPMyAdmin ("I, of course, already created a new user with a password, and set it to be able to connect from "Any Host" in PHPMyAdmin.") then I already did that too.
pvtryan
 
Posts: 16
Joined: 10. April 2010 21:57

Re: Remote Access to MySQL Server

Postby Nobbie » 11. April 2010 12:10

pvtryan wrote:The problem is that I can't connect remotely to the MySQL server through Dreamweaver (it kept giving me 403 errors)


You are barking up the wrong tree - Error 403 is not a MySQL Error, but an Apache Error (403 = "Forbidden").

This error occurs if you are trying to call a document which is stored in folder which has an unsufficient "Allow From ..." clause (see httpd.conf) or what is protected by userid/password (via .htaccess for example) and you do not apply the right credentials.
Nobbie
 
Posts: 8770
Joined: 09. March 2008 13:04

Re: Remote Access to MySQL Server

Postby pvtryan » 11. April 2010 17:26

YES, some help! So which of those files do I need to look at?
There's httpd.conf, .htaccess, and inside the Conf folder there's even more files that start with httpd and then end in some other word.conf
(example: httpd-xampp.conf).
Why do all these files start with ht (htdocs, htaccess httpd)? Does it stand for HyperText like HTML?
pvtryan
 
Posts: 16
Joined: 10. April 2010 21:57

Re: Remote Access to MySQL Server

Postby Altrea » 11. April 2010 17:32

Depends where you have defined your access rules for this directory.

Most common they are defined in your
- httpd.conf inside the Directory block
- .htaccess file inside this directory (if the allowOverride rule is set to a correct value)
- your virtual host definitions
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8293
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Remote Access to MySQL Server

Postby pvtryan » 11. April 2010 17:56

Thanks, I found the virtual hosts file, but I could not find an htaccess file, even with a search, inside the Apache folder. Is that the problem I've been having this whole time? If I create an htaccess file in the Apache folder will it solve my problem? Oh and in case anyone comes on here and says it's an invisible file and you have to...blah, blah, blah; I already have hidden files and folders visible.
pvtryan
 
Posts: 16
Joined: 10. April 2010 21:57

Re: Remote Access to MySQL Server

Postby Altrea » 11. April 2010 18:43

no. the htaccess file is just another way of setting directory attributes.
they are very helpful if you want to create password protection for directorys.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8293
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Remote Access to MySQL Server

Postby pvtryan » 11. April 2010 19:59

I, myself didn't set the access level for mysql. It was set by XAMPP, I guess. So where is it defined?
pvtryan
 
Posts: 16
Joined: 10. April 2010 21:57

Re: Remote Access to MySQL Server

Postby Nobbie » 11. April 2010 20:30

There is no "access level" for MySQL.

You have to find out, why Apache denys the requested document. THIS IS STILL NOT AN MYSQL ISSUE.

Its extremely difficult to "debug remotely", especially without any knowlegde about your environment, without any knowledge about your application, without any knowledge about your configuration, without any code, whithout any URLs, we simply know NOTHING. That is quite impossible. If even dont know Dreamweaver (I know what it is, but I have no installation and I dont use it).

If you need further help, you have to tell us everything, really everything, what you are doing, What is your local domain (or IP), what do you provide to Dreamweaver in order to "connect" to your Webserver and and and.
Nobbie
 
Posts: 8770
Joined: 09. March 2008 13:04

Re: Remote Access to MySQL Server

Postby pvtryan » 11. April 2010 21:16

Everything is default. When I installed XAMPP I left all the options at default and haven't changed anything. All I did is create a new user for MySQL using PHPMyAdmin and gave it a password, and set the host to "Any Host." If everything is at default and untouched, what more could you need?
pvtryan
 
Posts: 16
Joined: 10. April 2010 21:57

Re: Remote Access to MySQL Server

Postby Nobbie » 11. April 2010 21:59

pvtryan wrote: If everything is at default and untouched, what more could you need?


You (still) did not mention anything about Dreamweaver. I am not interested in Xampp, your problem is the communication between Dreamweaver and Xampp. And as long as we dont know anything about Dreamweaver and your Dreamweaver configuration, we cannot answer any single question.
Nobbie
 
Posts: 8770
Joined: 09. March 2008 13:04

Re: Remote Access to MySQL Server

Postby pvtryan » 11. April 2010 22:35

To connect remotely to databases (in order to work on and retrieve the tables in them, used to develop the php content) Dreamweaver asks for an arbitrary connection name, the "MySQL server," the "Username," and "Password." Those are in quotes because that's exactly what it says next to the input field. It also says "Database," but that's unnecessary because Dreamweaver can find the databases once it's established the connection and from there you can just select it.
pvtryan
 
Posts: 16
Joined: 10. April 2010 21:57

Re: Remote Access to MySQL Server

Postby Nobbie » 11. April 2010 23:01

My God - IT IS NOT A DATABASE ISSUE.

Last try (if you dont answer sufficiently, i'll give up). What do you enter in Dreamweaver in order to "call" files from Xampp's htdocs folder? How do you start an application, that needs a webserver? Dont you supply any servername? At which point do you receive the "error 403"? What are you trying to do there? DONT ANSWSER: I try to connect to MySQL. A connection to a database without an application is USELESS. Which application do want to trigger? Does Dreamweaver know so called "projects"? If yes: which credentials do you apply for a "project"?
Nobbie
 
Posts: 8770
Joined: 09. March 2008 13:04

Re: Remote Access to MySQL Server

Postby pvtryan » 11. April 2010 23:56

Here is everything that I have to put into Dreamweaver to set up a testing server and connect to a database. Also, I'm not getting the 403 error anymore. Now I'm getting a 2003 error. I'm sorry for my misunderstanding. =(
Image
Image
Image
Image
Image
Image
Image
Image
pvtryan
 
Posts: 16
Joined: 10. April 2010 21:57

Next

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 55 guests