MySQL Help, can somebody move this thread if it does not belong here

richm8026

New Member
Messages
138
Reaction score
0
Points
0
I have just installed MySQL on Windows and cannot find the Document Root, where would that be??? At least if I write some PHP Codes, I can do it offline before I upload then, thanks for the help..
 

compwhizii

Banned
Messages
779
Reaction score
0
Points
0
First, MySQL is a Database engine, not a Web Server. For a web server I would recommend Apache. Also make sure you get the PHP module.
 

richm8026

New Member
Messages
138
Reaction score
0
Points
0
Oooooooooooh, thanks, I had no idea, so I just need to install Apache2 then??? And then that'll compile PHP Source???
 

dickey

New Member
Messages
128
Reaction score
0
Points
0
yes and no...

Yes you have to install apache, but NO it will not compile PHP source, (and if I want to be strict the reason would be becaus PHP is not a compiled language).

given that reason above you need to install apache, php, and mysql. Since you have mysql already you need to install apache and php. then you have to modify the apache config file to link it with php.

But I think if you install apache first then the installation will detect the php and automatically configure your settings.

Things to check would be firewall settings and php configurations. There is (I think) a package for that called the wampserver or something which you can install and it will give you less problems as it also includes phpMyAdmin and some other useful stuff.
 

richm8026

New Member
Messages
138
Reaction score
0
Points
0
Thanks, I installed Apache 2.2.x and then PHP, but, PHP kept throwing an error about something about line 127 having a Syntax Error and can't complete installation..
 

freecrm

New Member
Messages
629
Reaction score
0
Points
0
It depends on what you are trying to achieve.

A full installation requires all 3 parts (MySQL, Apache, PHP) but for testing purposes, there is a simple "lite" version that you can install which covers it all. This isn't a full version but it does allow local testing with a good set of functionality.

I use this because my full site is hosted on-line but I also like to test locally before ftp'ing.
 

mephis

New Member
Messages
39
Reaction score
0
Points
0
it might be easier for you to just install WAMP (assuming you're running a windows OS), it just about configures everything for you
you can get it from http://www.wampserver.com/en/

it's also a good idea (if you do this WAMP thingy) to uninstall the MySQL, Apache and PHP installations you already have before installing WAMP
 

Scoochi2

New Member
Messages
185
Reaction score
0
Points
0
Further to what mephis said, the simplest way to get PHP and MySQL working is to use a package. If you're on Windows, use a WAMP.
There are two I can personally recommend and still use, and can help you set up if needed.

If you are using Windows XP, give Apache2Triad a go. In addition to PHP, it will also enable you to use Perl and Python, and several databases (including MySQL), with GUIs and control panels. It is also easy to use once it is set up. All you need to do is to go to http://localhost and you will find your own personal web server (nobody else can see it though).

For any other version of Windows, you should try EasyPHP. It's a lot simpler than Apache2Triad and as it's name implies, a lot easier to set up and get going from the start. It doesn't have Perl or Python and the only database is MySQL. But it does have GUIs.
If I remember rightly, it comes with PHP4, and you have to upgrade it to PHP5 yourself (which can get complicated if you're new to it). But like I said, if you need help then I'm familiar to it.


If you do choose the WAMP path, then uninstall Apache, PHP and MySQL first if you already tried installing them!
 
Last edited:

dickey

New Member
Messages
128
Reaction score
0
Points
0
I would also suggest wampserver as installing the three individually can waste like 2 hours of your time trying to figure out what went wrong and googling for answers. But if you are like me then just try to figure it out anyway we are here to help.
 
Top