Apache Friends Support Forum

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.

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

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 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.

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?

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

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.

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.

I, myself didn't set the access level for mysql. It was set by XAMPP, I guess. So where is it defined?

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.

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 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.

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.

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"?

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. =(