niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » MySQL
Help: PHP won't connect to MySQL
Post new topic   Reply to topic Page 1 of 1 [9 Posts] View previous topic :: View next topic
Author Message
Kay C. Tien
*nix forums beginner


Joined: 15 Jun 2006
Posts: 7

PostPosted: Sun Jul 16, 2006 10:22 pm    Post subject: Help: PHP won't connect to MySQL Reply with quote

Hi All,

The simple script I'm testing works on a Linux server. I got tired
of having to upload and test them, so I decided to install MySQL on
my computer, which is running Win XP.

MySQL works fine on it's own, I've set the the database and etc., but
nothing happened when I tested the page. So I googled online and
found out that I was missing php_mysql.dll and libmysql.dll. So I
copied them into the C:\WINDOWS\SYSTEM32 folder. Then modified
php.ini in the C:\WINDOWS by uncommented the php_mysql.dll extension
and changed to extension_dir to C:\WINDOWS\SYSTEM32. Rebooted and
now I'm getting the following error:
PHP Warning: PHP Startup: Unable to load dynamic library
'C:\WINDOWS\SYSTEM32\php_mysql.dll' - The specified procedure could
not be found. in Unknown on line 0

I've checked the PATH in the System also, C:\WINDOWS\SYSTEM32 is
there. So why does it work?? It's been a very frustrating day.

Help anyone?

Thanks.
Kay
Back to top
Chris
*nix forums Guru Wannabe


Joined: 29 Jan 2006
Posts: 137

PostPosted: Mon Jul 17, 2006 7:37 am    Post subject: Re: Help: PHP won't connect to MySQL Reply with quote

Kay C. Tien wrote:
Quote:
Hi All,

The simple script I'm testing works on a Linux server. I got tired of
having to upload and test them, so I decided to install MySQL on my
computer, which is running Win XP.

MySQL works fine on it's own, I've set the the database and etc., but
nothing happened when I tested the page. So I googled online and found
out that I was missing php_mysql.dll and libmysql.dll. So I copied
them into the C:\WINDOWS\SYSTEM32 folder. Then modified php.ini in the
C:\WINDOWS by uncommented the php_mysql.dll extension and changed to
extension_dir to C:\WINDOWS\SYSTEM32. Rebooted and now I'm getting the
following error:
PHP Warning: PHP Startup: Unable to load dynamic library
'C:\WINDOWS\SYSTEM32\php_mysql.dll' - The specified procedure could not
be found. in Unknown on line 0

You have a version mismatch in your dll's.

One of them will be a dll for mysql 4 and one will be for mysql 5.

You installed php5 right? The dll included with that probably won't talk
to mysql 4, only mysql 5..

I'd suggest removing both and installing php5 and mysql5 from scratch.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
Back to top
João Cândido de Souza Net
*nix forums beginner


Joined: 24 Mar 2006
Posts: 19

PostPosted: Mon Jul 17, 2006 12:12 pm    Post subject: Re: PHP won't connect to MySQL Reply with quote

I´m having the same trouble a long time ago and still looking for the
solution.


""Kay C. Tien"" <kct1986@gmail.com> escreveu na mensagem
news:7.0.1.0.2.20060716181207.05c0f6b8@clarityconnect.com...
Quote:
Hi All,

The simple script I'm testing works on a Linux server. I got tired
of having to upload and test them, so I decided to install MySQL on
my computer, which is running Win XP.

MySQL works fine on it's own, I've set the the database and etc., but
nothing happened when I tested the page. So I googled online and
found out that I was missing php_mysql.dll and libmysql.dll. So I
copied them into the C:\WINDOWS\SYSTEM32 folder. Then modified
php.ini in the C:\WINDOWS by uncommented the php_mysql.dll extension
and changed to extension_dir to C:\WINDOWS\SYSTEM32. Rebooted and
now I'm getting the following error:
PHP Warning: PHP Startup: Unable to load dynamic library
'C:\WINDOWS\SYSTEM32\php_mysql.dll' - The specified procedure could
not be found. in Unknown on line 0

I've checked the PATH in the System also, C:\WINDOWS\SYSTEM32 is
there. So why does it work?? It's been a very frustrating day.

Help anyone?

Thanks.
Kay



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
Back to top
Kay C. Tien
*nix forums beginner


Joined: 15 Jun 2006
Posts: 7

PostPosted: Mon Jul 17, 2006 12:56 pm    Post subject: Re: Help: PHP won't connect to MySQL Reply with quote

At 05:37 PM 7/17/2006 Monday, Chris wrote:
Quote:
Kay C. Tien wrote:
Hi All,
The simple script I'm testing works on a Linux server. I got tired
of having to upload and test them, so I decided to install MySQL on
my computer, which is running Win XP.
MySQL works fine on it's own, I've set the the database and etc.,
but nothing happened when I tested the page. So I googled online
and found out that I was missing php_mysql.dll and
libmysql.dll. So I copied them into the C:\WINDOWS\SYSTEM32
folder. Then modified php.ini in the C:\WINDOWS by uncommented the
php_mysql.dll extension and changed to extension_dir to
C:\WINDOWS\SYSTEM32. Rebooted and now I'm getting the following error:
PHP Warning: PHP Startup: Unable to load dynamic library
'C:\WINDOWS\SYSTEM32\php_mysql.dll' - The specified procedure could
not be found. in Unknown on line 0

You have a version mismatch in your dll's.

One of them will be a dll for mysql 4 and one will be for mysql 5.

You installed php5 right? The dll included with that probably won't
talk to mysql 4, only mysql 5..

I'd suggest removing both and installing php5 and mysql5 from scratch.

That would explain it. I'll try that.

Thanks.
Kay



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
Back to top
Kay C. Tien
*nix forums beginner


Joined: 15 Jun 2006
Posts: 7

PostPosted: Mon Jul 17, 2006 5:26 pm    Post subject: Re: Help: PHP won't connect to MySQL Reply with quote

At 05:37 PM 7/17/2006 Monday, Chris wrote:
Quote:
Kay C. Tien wrote:
Hi All,
The simple script I'm testing works on a Linux server. I got tired
of having to upload and test them, so I decided to install MySQL on
my computer, which is running Win XP.
MySQL works fine on it's own, I've set the the database and etc.,
but nothing happened when I tested the page. So I googled online
and found out that I was missing php_mysql.dll and
libmysql.dll. So I copied them into the C:\WINDOWS\SYSTEM32
folder. Then modified php.ini in the C:\WINDOWS by uncommented the
php_mysql.dll extension and changed to extension_dir to
C:\WINDOWS\SYSTEM32. Rebooted and now I'm getting the following error:
PHP Warning: PHP Startup: Unable to load dynamic library
'C:\WINDOWS\SYSTEM32\php_mysql.dll' - The specified procedure could
not be found. in Unknown on line 0

You have a version mismatch in your dll's.

One of them will be a dll for mysql 4 and one will be for mysql 5.

You installed php5 right? The dll included with that probably won't
talk to mysql 4, only mysql 5..

I'd suggest removing both and installing php5 and mysql5 from scratch.



Well, I reloaded both new versions. Still the same error! What
gives?! <sigh>

Kay






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
Back to top
Chris
*nix forums Guru Wannabe


Joined: 29 Jan 2006
Posts: 137

PostPosted: Mon Jul 17, 2006 11:56 pm    Post subject: Re: Help: PHP won't connect to MySQL Reply with quote

Kay C. Tien wrote:
Quote:
At 05:37 PM 7/17/2006 Monday, Chris wrote:
Kay C. Tien wrote:
Hi All,
The simple script I'm testing works on a Linux server. I got tired
of having to upload and test them, so I decided to install MySQL on
my computer, which is running Win XP.
MySQL works fine on it's own, I've set the the database and etc., but
nothing happened when I tested the page. So I googled online and
found out that I was missing php_mysql.dll and libmysql.dll. So I
copied them into the C:\WINDOWS\SYSTEM32 folder. Then modified
php.ini in the C:\WINDOWS by uncommented the php_mysql.dll extension
and changed to extension_dir to C:\WINDOWS\SYSTEM32. Rebooted and
now I'm getting the following error:
PHP Warning: PHP Startup: Unable to load dynamic library
'C:\WINDOWS\SYSTEM32\php_mysql.dll' - The specified procedure could
not be found. in Unknown on line 0

You have a version mismatch in your dll's.

One of them will be a dll for mysql 4 and one will be for mysql 5.

You installed php5 right? The dll included with that probably won't
talk to mysql 4, only mysql 5..

I'd suggest removing both and installing php5 and mysql5 from scratch.



Well, I reloaded both new versions. Still the same error! What
gives?! <sigh

Did you make sure there were no dll's left after the uninstall? ie look
for libmysql.dll and php_mysql.dll in all folders in your path.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
Back to top
João Cândido de Souza Net
*nix forums beginner


Joined: 24 Mar 2006
Posts: 19

PostPosted: Tue Jul 18, 2006 12:57 pm    Post subject: Re: PHP won't connect to MySQL Reply with quote

I found the solution in my case.

I just copy libmysql.dll from the php folder do \windows\system32 folder and
everything works fine.


""Kay C. Tien"" <kct1986@gmail.com> escreveu na mensagem
news:7.0.1.0.2.20060716181207.05c0f6b8@clarityconnect.com...
Quote:
Hi All,

The simple script I'm testing works on a Linux server. I got tired
of having to upload and test them, so I decided to install MySQL on
my computer, which is running Win XP.

MySQL works fine on it's own, I've set the the database and etc., but
nothing happened when I tested the page. So I googled online and
found out that I was missing php_mysql.dll and libmysql.dll. So I
copied them into the C:\WINDOWS\SYSTEM32 folder. Then modified
php.ini in the C:\WINDOWS by uncommented the php_mysql.dll extension
and changed to extension_dir to C:\WINDOWS\SYSTEM32. Rebooted and
now I'm getting the following error:
PHP Warning: PHP Startup: Unable to load dynamic library
'C:\WINDOWS\SYSTEM32\php_mysql.dll' - The specified procedure could
not be found. in Unknown on line 0

I've checked the PATH in the System also, C:\WINDOWS\SYSTEM32 is
there. So why does it work?? It's been a very frustrating day.

Help anyone?

Thanks.
Kay



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
Back to top
Kay C. Tien
*nix forums beginner


Joined: 15 Jun 2006
Posts: 7

PostPosted: Tue Jul 18, 2006 6:31 pm    Post subject: Re: PHP won't connect to MySQL Reply with quote

I have that copied in there. Even tried a
different version from the most recent MySQL
download. Still getting the same error -

PHP Warning: PHP Startup: Unable to load dynamic
library 'C:\WINDOWS\SYSTEM32\php_mysql.dll' - The
specified procedure could not be found. in Unknown on line 0

I don't get it!

Kay



At 09:57 AM 7/18/2006 Tuesday, João Cândido de Souza Neto wrote:
Quote:
I found the solution in my case.

I just copy libmysql.dll from the php folder do \windows\system32 folder and
everything works fine.


""Kay C. Tien"" <kct1986@gmail.com> escreveu na mensagem
news:7.0.1.0.2.20060716181207.05c0f6b8@clarityconnect.com...
Hi All,

The simple script I'm testing works on a Linux server. I got tired
of having to upload and test them, so I decided to install MySQL on
my computer, which is running Win XP.

MySQL works fine on it's own, I've set the the database and etc., but
nothing happened when I tested the page. So I googled online and
found out that I was missing php_mysql.dll and libmysql.dll. So I
copied them into the C:\WINDOWS\SYSTEM32 folder. Then modified
php.ini in the C:\WINDOWS by uncommented the php_mysql.dll extension
and changed to extension_dir to C:\WINDOWS\SYSTEM32. Rebooted and
now I'm getting the following error:
PHP Warning: PHP Startup: Unable to load dynamic library
'C:\WINDOWS\SYSTEM32\php_mysql.dll' - The specified procedure could
not be found. in Unknown on line 0

I've checked the PATH in the System also, C:\WINDOWS\SYSTEM32 is
there. So why does it work?? It's been a very frustrating day.

Help anyone?

Thanks.
Kay



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=kct1986@gmail.com
Back to top
Kay C. Tien
*nix forums beginner


Joined: 15 Jun 2006
Posts: 7

PostPosted: Wed Jul 19, 2006 11:45 pm    Post subject: Re: PHP won't connect to MySQL - resolved Reply with quote

Andre,

Yes, I sort of bypassed the problem by installing
XAMPP. Works like a charm now.

Thanks.
Kay

At 03:32 PM 7/19/2006 Wednesday, Andre Matos wrote:
Quote:
Hello Kay,

Have you solved the issue or you are still not ablle running MySQL and PHP
on Windows XP?

Which version are you running for PHP, MySQL, and Apache?

Andre


On 7/18/06 2:31 PM, "Kay C. Tien" <kct1986@gmail.com> wrote:

I have that copied in there. Even tried a
different version from the most recent MySQL
download. Still getting the same error -

PHP Warning: PHP Startup: Unable to load dynamic
library 'C:\WINDOWS\SYSTEM32\php_mysql.dll' - The
specified procedure could not be found. in Unknown on line 0

I don't get it!

Kay



At 09:57 AM 7/18/2006 Tuesday, João Cândido de Souza Neto wrote:
I found the solution in my case.

I just copy libmysql.dll from the php folder
do \windows\system32 folder and
everything works fine.


""Kay C. Tien"" <kct1986@gmail.com> escreveu na mensagem
news:7.0.1.0.2.20060716181207.05c0f6b8@clarityconnect.com...
Hi All,

The simple script I'm testing works on a Linux server. I got tired
of having to upload and test them, so I decided to install MySQL on
my computer, which is running Win XP.

MySQL works fine on it's own, I've set the the database and etc., but
nothing happened when I tested the page. So I googled online and
found out that I was missing php_mysql.dll and libmysql.dll. So I
copied them into the C:\WINDOWS\SYSTEM32 folder. Then modified
php.ini in the C:\WINDOWS by uncommented the php_mysql.dll extension
and changed to extension_dir to C:\WINDOWS\SYSTEM32. Rebooted and
now I'm getting the following error:
PHP Warning: PHP Startup: Unable to load dynamic library
'C:\WINDOWS\SYSTEM32\php_mysql.dll' - The specified procedure could
not be found. in Unknown on line 0

I've checked the PATH in the System also, C:\WINDOWS\SYSTEM32 is
there. So why does it work?? It's been a very frustrating day.

Help anyone?

Thanks.
Kay



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=kct1986@gmail.com


--
Andre Matos
amatos@neurorx.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
Back to top
Google

Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [9 Posts] View previous topic :: View next topic
The time now is Thu Dec 04, 2008 3:17 am | All times are GMT
navigation Forum index » Databases » MySQL
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts postfix smtp authentication using mysql stored user/pass rtresidd Postfix 0 Fri Oct 03, 2008 5:58 am
No new posts Postfix + MySQL error: very strange variable %s iWarior Postfix 0 Mon Aug 25, 2008 2:01 pm
No new posts Anyone managed to install policyd on x86_64 and mySQL 5.0x? SupaDucta Postfix 5 Mon Nov 13, 2006 3:18 am
No new posts postfix dovecot mysql issues gnetcon Postfix 0 Thu Aug 03, 2006 9:19 pm
No new posts MySQL Max Build Policy Kaj Arnö MySQL 0 Fri Jul 21, 2006 2:08 pm

Credit Card Consolidation | Credit Cards | Loans | Loans | Loans
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 1.9503s ][ Queries: 16 (1.7760s) ][ GZIP on - Debug on ]