how to enable pdo_mysql for windows

numerical25

Hello everyone. Im trying to install an application called magento on my computer. When I run through the installation it says I need to have

pdo_mysql
mcrypt
curl

well I did a phpinfo() to see if it was there and it wasnt, the only PDO file I saw was PDO mysqlite... BUT!! when i look in my extensions I see this.

php_mcrypt.dll
php_pdo_mysql.dll
php_curl.dll

Im using easy php 5 and im running it off my windows machine. How do I go about enabling it

Drakla

Find your php.ini file and then remove the semicolons from the front of the lines of the extensions you want to install extension=php_pdo_mysql.dll should do the trick.

But I'm a bit worried if it's already listing it. In phpinfo() does it list mysql in the pdo drivers list?

numerical25

It only list mysqlite in the PDO drivers list.

But here is another problem.

When i went to remove the ; from in front of php_mcrypt.dll, php_pdo_mysql.dll and php_curl.dll . I found the mcrypt one and the curl one, but i didnt find the pdo_mysql one ?? does that mean anything ??

Its in my extensions so should i just try to add it and see ???

Drakla

Yeah, add to php.ini

extension=php_pdo_mysql.dll

You don't need to enable php_mysql or php_mysqli if you don't want to, unlike sqlite.

I've got libmysql.dll in the same directory as my php.exe and it's all working fine running with apache.

numerical25

Well here is the thing. I did that and restart the server but phpinfo() is still not showing it. I have no clue to what it maybe now.

Drakla

I'm running as CGI on Apache, you might be using it as a module, so I'm wondering if this from the php site might help:

practicegoodtheory at gmail dot com
19-Jun-2008 07:56
On Windows, with Apache, it would not load php_pdo_mysql.dll until I put libmysql.dll in Apache's dll path (e.g. apache/bin)

From http://uk3.php.net/manual/en/ref.pdo-mysql.php

I'm all out of ideas apart from that.

numerical25

where can i get libmysql.dlll at ?? and once I get it I put it in apache/bin ????

nevermind I got it.... all im guessing is i drop it into the directory. im guessing i dont have to write any paths so php has to look for it or anything ???

numerical25

well I dropped the mysql.dll into apache/bin . still didnt work 🙁 Im just having terrible luck. this isnt working for the world

Drakla

Just did some tinkering as I'm actually benchmarking sqlite with PDO and then switched to mysql for a laugh - the standard pdo extension must be before the mysql one for it to work - so in php.ini

extension=php_pdo.dll
extension=php_pdo_mysql.dll

But this will cause a startup error

extension=php_pdo_mysql.dll
extension=php_pdo.dll

Can you give that a go? Don't just wack the mysql line in at the top of the ini file, which you might have done.

bradgrafelman

Also note that no DLL files should be moved outside of the main PHP installation directory (e.g. c:\php). If you originally found libmysql.dll in c:\php\ (or wherever PHP is installed), as you should have, moved it back there and delete any other copies of it you may have placed elsewhere.

Then, add the main PHP directory to your system's PATH environment variable. Then, restart the machine (complete restart of Windows, not just stop/start Apache).

rm_phpbuilder

reinstall the php...and select those...libraries...that you need...

select mysql...to get the libmysql.dll

those are FUNCTION REFERENCES in php help.

Dr_Flink

I just stumbled over the exact same problem concerning the mysql_pdo extension and googled my self to this thread.
I'm also using EasyPHP and Drakla had the answer in his last post.

This is what I did:
1. Copied following files from 'php\ext' to 'php\extensions':
php_pdo.dll
php_pdo_mysql.dll
2. Opened 'conf_files\php.ini' and added following rows (I did it alphabetically, after the php_pdf.dll):
extension=php_pdo.dll
extension=php_pdo_mysql.dll

Remember that you might need to restart the server.
Hope this works for you also.

//Rickard

bradgrafelman

Dr.Flink wrote:
Copied following files from 'php\ext' to 'php\extensions'

Why do this when leaving them in the 'ext' directory will work just fine?

Dr_Flink

bradgrafelman;10878328 wrote:
Why do this when leaving them in the 'ext' directory will work just fine?

Well, in my case I had to move the two .dll files to the extension directory (don't know why). Only adding the lines too the .ini-file didn't do the trick.
But, doing this I realised that my phpMyAdmin stoped working. I had to add php_mysql.dll to the extension list and copy the mysql.dll file from 'ext' too 'extension' -directory.

Now, knock on wood, everythings working allright.

bradgrafelman

Why not just change the extension_dir setting from the "extension" to "ext" directory?

kweathe

Thanks for all the info in this post. This was a big help in solving a server issue. And since I am not a PHP expert... I was able to solve the problem in minutes rather than days. THANKS To Drakla!

One side note: If you have a windows server running Plesk there are at least 3 php.ini files. Getting the right one makes all the difference.

kweathe

Thanks for all the info in this post. This was a big help in solving a server issue. And since I am not a PHP expert... I was able to solve the problem in minutes rather than days. THANKS To Drakla!

One side note: If you have a windows server running Plesk there are at least 3 php.ini files. Getting the right one makes all the difference.