When you finish installing phpMyAdmin on your windows OS, you may see this error msg below your phpMyAdmin screen after you logging in. I try googling for solution and none of them working on my windows system. But i get a conclusion from those articles i read and Yes i get the solution.
First there aren’t MySQL or PhpMyAdmin prolems. it’s PHP problem that can’t load this extension. Now you can open your php initialization file “php.ini” it’s ono your php installation directory (i.e c:\program files\php\). You must make sure that php extension directory is set up at the right place, on my pc it’s on”C:\Program Files\PHP\ext”. then you can open comment on this line “;extension=php_mcrypt.dll”.
Until this step actualy i have done the right things and surely this must work, after i restart my Apache Server this isn’t progress at all . I try googling and googling but none of them solved my problem until i read article on install mysql that must put the libray on to the windows directory than i realize this is must be the solution.
I put the library on windows system (c:\windows\) not the php_mcrypt.dll but libmcrypt.dll (mine in c:\program files\php\) , restart the Apache and ….. this is SOLVED…
Phew after a night and a half day ….
June 2, 2008 at 7:21 am |
thanks for your help .
June 2, 2008 at 11:51 am |
I can’t believe it. You’ve solved my problem. They don’t make things easy for us do they? LOL
June 25, 2008 at 3:32 pm |
Thank you! I’ve been searching for hours but this totally worked!
December 25, 2008 at 4:35 am |
Had the same problem.
This helped me a lot.
I had both php_mcrypt.dll and libmcrypt.dll under System32 as I tried first with php_mcrypt.dll and then putting libmcrypt.dll as it still didn’t work.
After reading this I removed php_mcrypt.dll from that folder, restarted apache , and it works.
Thanks!
December 25, 2008 at 7:53 am |
Well, it still didn’t work after all, better but not perfectly.
I have removed them all from windows\system32. I have removed libmcrypt.dll, php_mcrypt.dll, libmysql.dll, php_mysql.dll, php_mysqli.dll as I tried different combination. I just made sure they were back as original in their respective folders, that is c:\apache64\php5 and c:\apache64\php5\ext in my case.
All is in configuring php.ini properly, leaving it there under your php folder and going into Control Panel, System, Advanced System Settings, Environment Variables, System variables, Path, Edit and added at the end of the line “;C:\apache64\php5\” without the ” characters.
In php.in, I made sure the extensions I needed were uncommented, they are “extension=php_mcrypt.dll”, “extension=php_msql.dll”, “extension=php_mysqli.dll” for Mysql5 with PHP5, “extension=php_bz2.dll
” for compression (needed with phpMyAdmin for instance), “extension=php_mbstring.dll” for phpMyAdmin, “extension=php_zip.dll” for phpMyadmin.
In php.ini still, “session.save_path = “C:/tmp”, creating the folder and making it share to everyone as it was coming back all the time as read only on my Vista system. Needed also for phpMyadmin 3.1.1 is to create a folder config and make it readable. See http:\\localhost\phpMyAdmin\setup for more info.
In php.ini, “mysqli.default_port = 3306” and “mysqli.default_host = localhost” as well as “mysql.default_port = 3306” and “mysql.default_host = localhost”. Correct me on this latest if I am wrong but that’s how it is on my seemingly working web server at this stage.
Hope this will spare you a night of digging.
December 27, 2008 at 6:41 pm |
well Olivier if it’s better than what message / error still appear when you run phpMyAdmin?
April 15, 2009 at 4:40 am |
I had the exact same problem with the mcrypt error. My solution was the same as Olivier’s I think. The reason the System32 folder wants the dll’s is because it is in the System Path search list. Just adding a semicolon and “c:\php” (or whatever your php folder is called) to the list of folders that are in the Path fixes everything. You have to reboot Windows for it to take effect. Here are some steps for how to do this in detail:
http://blog.eukhost.com/webhosting/how-do-i-add-my-php-directory-to-the-path-on-windows/
April 20, 2009 at 3:51 am |
Outstanding, much obliged!
June 1, 2009 at 10:43 am |
Hi,
Don’t comment that, it’s a missing plugin.
Just run for debian:
apt-get install php-mcrypt
Fedora
yum install php-mcrypt
That will solve your problem 🙂
June 4, 2009 at 6:57 pm |
Thanks Oliver! You guys are all saints. I realized reading this that this PATH stuff is a holdover from the DOS days and the PATH was an issue every installed application needed to address.
Final note, the syntax for the PATH string needs to include the final “\” as in “c:\php5\” but NOT “c:\php5” OR “c:\php5\ext\” (which would have the system looking for the extension file “php_mcrypt.dll” in a directory one level lower.)
Now if I can just find that piece of paper with my database password on it….
June 29, 2009 at 12:43 am |
Thanks!!!!!!!! I spent hours and hours with this issue! (K) (K) (K)
I (L) U !!!
July 16, 2009 at 9:05 am |
Extremely grateful, thanks.
July 17, 2009 at 2:45 am |
happy this post can help all of us
July 22, 2009 at 9:40 pm |
Thanks 😉
July 28, 2009 at 4:26 pm |
Hey, thanks a lot. This worked great.
July 31, 2009 at 9:40 pm |
THANKS A LOT!!!!
Saved me hours/days !
I think there should be a master PHP/MySQL/Apache Help WEB PAGE with all helps stuff like these!
August 3, 2009 at 4:07 pm |
Thanks!!!!
After looking for a couple of hours, this was the solution.
August 24, 2009 at 4:23 pm |
Hi
Thans a lot:)
August 31, 2009 at 5:16 am |
Thanks alot..
it magically worked for me.
September 10, 2009 at 10:51 am |
works great!
thanks a lot
October 2, 2009 at 1:24 am |
Very useful article, thanks for sharing.
October 5, 2009 at 9:41 pm |
Thanks for sharing, it works… keep up the good work!
October 20, 2009 at 12:48 pm |
Thanks for this topic. It helpd remove this error.
December 11, 2009 at 8:28 pm |
Thanks – you’re a star!
December 16, 2009 at 2:23 pm |
It works for me thanks
January 8, 2010 at 10:21 am |
___THANKS__A__LOT___!!!