MySQL - cannot load <mcrypt> extension

[johngoodman]

I get the following error when logging into MySQL. I used the windows installer:

xampp-win32-1.6.2-installer.exe

ERROR MSG:

Cannot load mcrypt extension. Please check your PHP configuration.

Any ideas?

[Codesmith]

Did you do anything else other than run the installer?

Is this the only version of apache installed on your system?

[rowbearto]

I also get this error. I found a way to get rid of it from a comment in this forum: http://us2.php.net/mcrypt . I don't know if it is the best way to fix the problem however. I would appreciate feedback on this issue.

The only thing that I changed after the xampp install (this is for version 1.6.1) was that I went to the security page and created a login for phpMyAdmin using "cookie" based authentification. Before creating that password, I didn't get the mcrypt error in phpMyAdmin, but it did complain about me not having a password. After creating the password, when I go to phpMyAdmin, I get the error.

This is the only version of Apache installed on my system.

The comment from the above website which fixed my problem was this:

To enable mcrypt extension under Windows you need to:
1) uncomment line "extension=php_mcrypt.dll" in php.ini
2) download libmcrypt.dll from http://files.edin.dk/php/win32/mcrypt/ and put it to System32 directory (for example C:\Windows\System32).
Tested on Windows XP+Apache 1.3.37+PHP 4.4.6 (as SAPI module!!!)

P.S.
I wrote this because I got "Cannot load mcrypt extension. Please check your PHP configuration." from phpMyAdmin when I simply uncommented "extension=php_mcrypt.dll" line.

Rob
http://robsnotebook.com

[SKv]

I also get this error. I found a way to get rid of it from a comment in this forum: http://us2.php.net/mcrypt . I don't know if it is the best way to fix the problem however. I would appreciate feedback on this issue.

All that I did was to uncomment mentioned line in php.ini
php_mcrypt.dll is coming by default and it is placed in xampp\php\ext by defaul.
I have to admit that I didn't used installer but zip files.

[rowbearto]

Based on your message, I just uncommented the line in php.ini and did not copy over the .dll from the website (actually, since I already had it, I deleted it).

This worked fine.

And I used the installer, so it works for that too.

I checked the directory that you mentioned, and indeed the right .dll file was there.

[rowbearto]

I forgot to say Thank you, so Thank You.

[SKv]

I forgot to say Thank you, so Thank You.

LOL! You are most welcome!

[raid2005]

Mine is different, I setup complex installation, separate from the package,

I installed first from php, apache, mysql. now in my phpMyAdmin, I stop the apache and uncomment the said extension through php.ini:

extension=php_mbstring.dll
extension=php_mcrypt.dll

then restart the apache.

the php_mbstring worked but the php_mcrypt @ phpMyAdmin didn't.

Any other clue?

[SKv]

Mine is different, I setup complex installation, separate from the package

I have no idea what you did but it sounds as if your extension directory is not in the system path.
Dirty solution would be one mentioned above to copy libmcrypt.dll to system32 folder but that would make any future updates a nightmare. If you by any chance would like to do it properly you should put extension extension directory to the system path. You can find how to do it on apache.org
Off course the best option is to forget about "complex installation" and use package but I guess that you have good reasons why you didn't do it at the first place.

[raid2005]

Mine is different, I setup complex installation, separate from the package

I have no idea what you did but it sounds as if your extension directory is not in the system path.
Dirty solution would be one mentioned above to copy libmcrypt.dll to system32 folder but that would make any future updates a nightmare. If you by any chance would like to do it properly you should put extension extension directory to the system path. You can find how to do it on apache.org
Off course the best option is to forget about "complex installation" and use package but I guess that you have good reasons why you didn't do it at the first place.

problem solved... thanks

[SKv]

problem solved... thanks

You are welcome if it was I who helped you. Otherwise it would be great if you could let us (community) know how you solved the problem.
Ciao,
Goran