Need help with Apache...

[Matt_d]

I installed Apache on my local PC a few months ago for testing PHP pages. But I never really used it since I did most of my work at school. Well now I’m out of school and I need to test stuff on my local server. If I put a php file into my htdocs folder, and try to view it in my browser, it works fine. However, if I, for example click a button thet runs a query and trys to connect to a database I get an error saying something along the lines of "Access denied for user 'root'@'localhost'"

Now, I have no idea what is causing this problem. All I’m using is Apache as a local server, trying to connect with a simple PHP, and a Database made with Microsoft Access. The Database is in the same directory as the php file, which are both inside my htdocs folder.

The only problem I can see is that since I installed Apache a while ago, maybe I have forgotten my admin username and password. I'm pretty sure the username was 'root' and password was 'abc123', any way I can make sure that’s the correct info?

And if that’s not causing the problem, do I need some sort of software installed on my PC to be able to run SQL Querys on my localhost? I don't have MySQL or anything like that installed on my machine.

Any help would be great, thanks.

[Toxeia]

It sounds more as though it were a problem with how you're connecting to the db. You're using localhost, but maybe MS Access doesn't prefer localhost. Have you tried 127.0.0.1? It's a loop, just like localhost. Any reason as to why they'd prefer 127.0.0.1 would be because you don't need a webserver to use it, but localhost needs something to interpret it.

By the way, why haven't you installed MySQL? It's easy to do, and I've preferred it since I first used it. Nice and clean.

[maxpup979]

if you are just looking for a generic (easy to setup) environment, give xampp a try.

[cyb0rg51]

i had the same problem when I used PHP4, MYSQL and apache on my home lan with linux.

To fix it i think what i did was create a password for root access to mysql then configured php to with my root password. Hope that helped you, im still a newbie at all of this