I'm running Windows XP Professional and Apache. I'm not planning to host any major site or anything but i'm just real interested in getting it to work. So far i've installed cgi and php4, and the last thing i need to do is install MySQL. I have it installed and everything but how do I make it so that Apache knows it's there? For instance, I was trying to install phpBB (a message board) and it told me that it can't connect to the database. How do I tell it where the database is at (C:\mysql) ?

Thanks for the help
-Costas

    mysql has nothing to do with apache, it's just another server. you have to tell the php script (or perl script etc.) about mysql (your username/password/path/port), apache doesn't need to know. so if you try to install the phpbb forum, there certainly is some file called install or configure.php or something where you have to insert info about your mysql database. read the readme.
    also, of course you have to start the mysql server before you try to connect to it. have you started it? start the mysql daemon, it will start the mysql database automatically, and create a basic config file, which you should update afterwards (e.g. adding the innodb instructions etc.)

      Hmm.. when i try to install phpBB, it asks me for the name of the database. I have MySQL open but it doesn't give me the name of any database nor an option to create one.

        hi there,

        i use phpBB on my website if you use the latest version 2.0 unzip phpBB in a subdirectory in your www root directory then run if it's locally on your own pc

        http://127.0.0.1/phpBB/install.php

        where phpBB is the installation directory of the forum software and follow the instructions you need to give

        1)your mysql username
        2)your mysql pass
        3)your mysql database

        just download mysql from http://ww.mysql.com install it and run "winmysqladmin.exe" when you run this the first time it will asl you to setup a username and a password these are your mysql username &pass you need a good program to create databases i use phpMyAdmin
        http://phpwizard.net/projects/phpmyadmin
        you should .htaccess this directory otherwise the whole internet can add or even whorse drop your databases this program has no build in security .

          Write a Reply...