Apache Webserver

[PCTech]

Does anyone know of a module I can download for mysql access in apache 2.0? I finally got PHP to work! I'm running windows xp and would like any information I can get on getting Apache and mysql to work on windows xp!

Thanks,
~PCTech

[Thankbot]

1 User already said Thank You!

war59312

[JacKDynne]

Not sure what you mean by a module to get mysql access in apache, apache typically just serves the webpages, but you can use myphpadmin for a nice gui to administer mysql. Get it here:
http://www.phpmyadmin.net/home_page/

Hope this helps some

/JD

/JD

[PCTech]

http://24.88.244.29/xcart/install.php

The above url is to my server and after you click next it gives a failed message for mysql support. the webserver is windows based apache2. There is supposedly a way to turn mysql support on with apache, but I dont know how! Yes, mysql is running, its a service so its always running! Anyone know why mysql support is off? HOw do i turn it on?

Thanks,
~PCTech

[CARTMAN]

You use mysql through PHP or Perl in Apache. There is no sql module needed afaik.

[PCTech]

i've enabled php in apache! why doesn't the mysql work? I am using php5 w/ apache2. I've also installed perl. What do I need to do to make sure i've got it all enabled right?

Thanks,
~PCTech

[war59312]

Well site is down so I cant see the error but anyways...

Just go to your mysql folder and then bin and run mysqladmin in a dos promt and then type in mysqladmin create "databasename".

Might be this if u need user name and pw like me. Super secure mode.

mysqladmin create "databasename" -u "username" -P "port number" -h "ip address or hostname" -p

and to drop if your wondering:

mysqladmin drop "databasename" -u "username" -P "port number" -h "ip address or hostname" -p

and then it asks for pw and type in pw and it should work then. Thats one way of how u login into mysql remotely as well like i am doign right now from work...

If that dont work just download and setup phpmyadmin and use it instead.

Simple as that. You should have already setup mysql itself through winmysqladmin (some file name like that in bin directory as well) that setsup user name and pw. If not then delete my.ini in your system32 folder or just edit the user name and pw stored in it.

If u want just give me access and i'll do it for u.

Also, I advise u to install Zend Optimizer which should speed up php very much.

cya,
Will

[war59312]

BTW if u want it really easy just install easyphp.http://www.easyphp.org/

Its very easy to install (30secs) and includes everything u need like phpmyadmin mysql and php, etc.

Very easy to config and supports everything. Just not the latest version of php and mysq and phpmyadmin but current enough.

See very easy and everything seems to work great.

[PCTech]

War, I did what you said, and it worked beautifully! Thanks for your help and thank you everyone for helping me!

Thanks,
~PCTech

[war59312]

Your welcome!!

Take Care,
Will