Can"t get MySQL connection

I am not having any luck connecting to the MySQL server on my XP Pro /
Apache 2.2.3 / PHP 5.2.0 developmental server. Apache and PHP are
working fine. I had to create a ext directory on the PHP install and
placed php_mysql.dll in it and th libmysql.dll. I updated the php.ini
file to un rem out the mysql extension (verified it was indeed the mysql
extension). Made sure the PHP directory is in the startup path, rebooted
and then even restarted Apache. I cannot get the MySQL server to be
recognized through PHP. Here is the error log (section) from my restart:

[Sat Mar 10 08:11:49 2007] [notice] Apache/2.2.3 (Win32) PHP/5.2.0
configured -- resuming normal operations
[Sat Mar 10 08:11:49 2007] [notice] Server built: Jul 27 2006 16:49:49
[Sat Mar 10 08:11:49 2007] [notice] Parent: Created child process 1520
PHP Warning: PHP Startup: Unable to load dynamic library
'C:\\PHP\\ext\\php_mysql.dll' - Invalid access to memory location.\r\n
in Unknown on line 0
[Sat Mar 10 08:11:49 2007] [notice] Child 1520: Child process is running
[Sat Mar 10 08:11:49 2007] [notice] Child 1520: Acquired the start mutex.
[Sat Mar 10 08:11:49 2007] [notice] Child 1520: Starting 250 worker threads.
[Sat Mar 10 08:11:50 2007] [notice] Child 1520: Starting thread to
listen on port 80.

Any ideas what I am doing wrong?

--
Vince Bravdica
President
Virtual Web Resources
www.vwebr.net



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Can"t get MySQL connection

Try the following:

1 )libmysql.dll is in the windows/system32 directory. It doesn't need to
be in the PHP directory.
2) Your php.ini extensions directory path looks like this (note the
backslashes and not double forward slashes (where x: is the drive it's
installed on):

x:/path/to/php/ext

I also added the PHP directory to my Windows PATH environment variable,
though am not sure that is necessary. One of these days I'll remove it
and check :) Cheers.

Armando

Vince Bravdica wrote:
> I am not having any luck connecting to the MySQL server on my XP Pro /
> Apache 2.2.3 / PHP 5.2.0 developmental server. Apache and PHP are
> working fine. I had to create a ext directory on the PHP install and
> placed php_mysql.dll in it and th libmysql.dll. I updated the php.ini
> file to un rem out the mysql extension (verified it was indeed the mysql
> extension). Made sure the PHP directory is in the startup path, rebooted
> and then even restarted Apache. I cannot get the MySQL server to be
> recognized through PHP. Here is the error log (section) from my restart:
>
> [Sat Mar 10 08:11:49 2007] [notice] Apache/2.2.3 (Win32) PHP/5.2.0
> configured -- resuming normal operations
> [Sat Mar 10 08:11:49 2007] [notice] Server built: Jul 27 2006 16:49:49
> [Sat Mar 10 08:11:49 2007] [notice] Parent: Created child process 1520
> PHP Warning: PHP Startup: Unable to load dynamic library
> 'C:\\PHP\\ext\\php_mysql.dll' - Invalid access to memory location.\r\n
> in Unknown on line 0
> [Sat Mar 10 08:11:49 2007] [notice] Child 1520: Child process is running
> [Sat Mar 10 08:11:49 2007] [notice] Child 1520: Acquired the start mutex.
> [Sat Mar 10 08:11:49 2007] [notice] Child 1520: Starting 250 worker
> threads.
> [Sat Mar 10 08:11:50 2007] [notice] Child 1520: Starting thread to
> listen on port 80.
>
> Any ideas what I am doing wrong?
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org