MySQL is driving me nuts!

OK, so I have my Apache 2.0.5 setup and I have PHP running with it. I
also installed mysql 4.0.2 and... well theres nothing much after that.
MySQL is running completely seperate from the server and the server
doesn't recognize it. Is there some setting I need to change on the
server to let it see MySQL? Or could it be MySQL that needs changing.
Heh I made progress with Apache today, I got it + php installed, and I
figured out the directory to put web files! Sadly this really has got
me stumped and has for a few hours. -Dave

<undrgrnd59@gmail.com> wrote in message
news:1109381132.708480.239270@z14g2000cwz.googlegr oups.com...
> OK, so I have my Apache 2.0.5 setup and I have PHP running with it. I
> also installed mysql 4.0.2 and... well theres nothing much after that.
> MySQL is running completely seperate from the server and the server
> doesn't recognize it. Is there some setting I need to change on the
> server to let it see MySQL? Or could it be MySQL that needs changing.
> Heh I made progress with Apache today, I got it + php installed, and I
> figured out the directory to put web files! Sadly this really has got
> me stumped and has for a few hours. -Dave

What does phpinfo show you? My first thought is that you need to enable
mysql support in php.ini. PHP supposedly comes with it enabled, but often it
isn't.

Ehhh boy I feel like a newbie. Anyway I looked into the php.ini and
discovered I wasn't even using it. So I renamed php.ini-recomended to
php.ini (which I am assuming was supossed to be done), but now I am
getting some other error. Oh well I've decided to give it up so no
need to reply, but thankyou for the support you gave me.

<undrgrnd59@gmail.com> wrote in message
news:1109491919.604940.304730@f14g2000cwb.googlegr oups.com...
> Ehhh boy I feel like a newbie. Anyway I looked into the php.ini and
> discovered I wasn't even using it. So I renamed php.ini-recomended to
> php.ini (which I am assuming was supossed to be done), but now I am
> getting some other error. Oh well I've decided to give it up so no
> need to reply, but thankyou for the support you gave me.

I'll bet I can guess what the error might be: When you start your server,
you get a message saying that a file can't be found (IIRC it's
libmysql.dll) - that's because it's not in the default path. Try adding your
PHP directory to your default path - that should do the trick.

Hey - don't sweat it. I just went through the exact same thing about 2 weeks
ago. It can be a bit frustrating, but no reason to give up.

GL with it al...

OK, I made some progress and discovered that its not apache running
mysql I have to worry about its php, lol. Anyway I looked in php.ini
and removed the ; from extension=php_mysql.dll . Also I changed the
directory to look for them in to 'C:\php\ext' . But for some reason
unknown to be it won't find it. I keep getting

PHP Startup: Unable to load dynamic library 'C:\php\ext\php_mysql.dll'
- The specified module could not be found.

Its strange because I checked that dir and its sitting right there...
Is that how I am supossed to be doing it anyway?

MySQL is supported "out of the box" in PHP an extension .DLL does not need
to be loaded. my php.ini-recommended did not even contain a line. What
version of PHP are you using. Also did you follow the instructions in
install.txt for installing PHP under Apache. I run Apache/2.0.53 (Win32)
PHP/4.3.10 and did not have any problems with PHP.

<undrgrnd59@gmail.com> wrote in message
news:1109717108.218291.269180@g14g2000cwa.googlegr oups.com...
> OK, I made some progress and discovered that its not apache running
> mysql I have to worry about its php, lol. Anyway I looked in php.ini
> and removed the ; from extension=php_mysql.dll . Also I changed the
> directory to look for them in to 'C:\php\ext' . But for some reason
> unknown to be it won't find it. I keep getting
>
> PHP Startup: Unable to load dynamic library 'C:\php\ext\php_mysql.dll'
> - The specified module could not be found.
>
> Its strange because I checked that dir and its sitting right there...
> Is that how I am supossed to be doing it anyway?
>

I have no problems with php really, its just getting mysql to work with
php lol. My php-recommended did have an include line for like 50
different things. I have apache 2.0.53 (win32) and PHP 4.3.1 also :\
Well when I run apache should it say that im running mysql at the
bottom (like it says with php)? I know php works because I can goto
the test page but I am almost positive mysql isn't.

"Brian K. White" <nospam@foxfire74.com> wrote in message
news:mI7Vd.19$J14.2@fe1.columbus.rr.com...
> MySQL is supported "out of the box" in PHP an extension .DLL does not need
> to be loaded. my php.ini-recommended did not even contain a line. What
> version of PHP are you using. Also did you follow the instructions in
> install.txt for installing PHP under Apache. I run Apache/2.0.53 (Win32)
> PHP/4.3.10 and did not have any problems with PHP.

This is the claim, but it's not necessarily true.

From the install instructions for PHP in "PHP 5/MySQL Programming":
"The php.ini file that comes with PHP 5.0 has a note that says mySQL support
is built in. I found this was NOT the case in my installation."

The author found this to be the case, and so did I.

> <undrgrnd59@gmail.com> wrote in message
> news:1109717108.218291.269180@g14g2000cwa.googlegr oups.com...
> > OK, I made some progress and discovered that its not apache running
> > mysql I have to worry about its php, lol. Anyway I looked in php.ini
> > and removed the ; from extension=php_mysql.dll . Also I changed the
> > directory to look for them in to 'C:\php\ext' . But for some reason
> > unknown to be it won't find it. I keep getting
> >
> > PHP Startup: Unable to load dynamic library 'C:\php\ext\php_mysql.dll'
> > - The specified module could not be found.
> >
> > Its strange because I checked that dir and its sitting right there...
> > Is that how I am supossed to be doing it anyway?

I had the same problem. I fixed it by moving php_mysql.dll to the php folder
(not php/ext). I have heard that the better way to fix this is to add the
php/ext folder to your PATH.

After doing this, you will probably have a problem loading 'libmysql.dll' -
copy this to the C:\WINDOWS or C:\WINNT directory and everything should be
working ok.

....at least, that's what worked for me...;)

Well I know how to fix the path but in a different sense I don't lol.
First thing I did was search for the php_mysql.dll and I found it and
put it in various directorys, included the php folder. Then I changed
the path so that its pointing at the ext folder, but when I restart
apache I get the error saying its not there, although it is in that
exact directory.

I'm running phpBB so I am pretty sure that MySQL is working from PHP.
another question I have is if you copied everything from the ext
subdirectory to its parent folder (e.g. C:\PHP)? I seem to recall reading
somewhere that was one of the steps that was required for PHP 4.X. PHP 5.X
has the new directory structure already in the distribution archive so
re-arrangement of files is not necessary.


"Tony23" <nobody@nowhere.not> wrote in message
news:112brqoq45ikebf@corp.supernews.com...
> "Brian K. White" <nospam@foxfire74.com> wrote in message
> news:mI7Vd.19$J14.2@fe1.columbus.rr.com...
> > MySQL is supported "out of the box" in PHP an extension .DLL does not
need
> > to be loaded. my php.ini-recommended did not even contain a line. What
> > version of PHP are you using. Also did you follow the instructions in
> > install.txt for installing PHP under Apache. I run Apache/2.0.53
(Win32)
> > PHP/4.3.10 and did not have any problems with PHP.
>
> This is the claim, but it's not necessarily true.
>
> From the install instructions for PHP in "PHP 5/MySQL Programming":
> "The php.ini file that comes with PHP 5.0 has a note that says mySQL
support
> is built in. I found this was NOT the case in my installation."
>
> The author found this to be the case, and so did I.
>
> > <undrgrnd59@gmail.com> wrote in message
> > news:1109717108.218291.269180@g14g2000cwa.googlegr oups.com...
> > > OK, I made some progress and discovered that its not apache running
> > > mysql I have to worry about its php, lol. Anyway I looked in php.ini
> > > and removed the ; from extension=php_mysql.dll . Also I changed the
> > > directory to look for them in to 'C:\php\ext' . But for some reason
> > > unknown to be it won't find it. I keep getting
> > >
> > > PHP Startup: Unable to load dynamic library 'C:\php\ext\php_mysql.dll'
> > > - The specified module could not be found.
> > >
> > > Its strange because I checked that dir and its sitting right there...
> > > Is that how I am supossed to be doing it anyway?
>
> I had the same problem. I fixed it by moving php_mysql.dll to the php
folder
> (not php/ext). I have heard that the better way to fix this is to add the
> php/ext folder to your PATH.
>
> After doing this, you will probably have a problem loading
'libmysql.dll' -
> copy this to the C:\WINDOWS or C:\WINNT directory and everything should be
> working ok.
>
> ...at least, that's what worked for me...;)
>
>