phpMyAdmin, Centos 6 and mcrypt

If you use phpMyAdmin You know that annoying message that comes up all the time about mcrypt?  mcrypt, I beleive, is used my phpMyAdmin to encrypt it’s cookies so it’s a really good idea to have it switched on.

After searching high and low I finally realised I needed the EPEL repo to get it,  this is a repo by the Fedora team of all kinds of goodies RH in their wisdom don’t provide.

This is the RPM for Redhat / Centos 6:  http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-5.noarch.rpm

And for Redhat Centos 5: http://download.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm

For anything else, and a better description check out their page. http://fedoraproject.org/wiki/EPEL

Install your repo rpm (up there), run “yum install php-mcrypt” and “service httpd restart” – you should be good to go.

Thanks Fedora Project!

Reset an MD5 hashed password in a MySQL database

To reset a MD5 hashed password in a MySQL database use this SQL – either in phpMyAdmin or command line MySQL. 

This example works exactly for Joomla, but you can change it to match your application’s tables and fields of course.

 

UPDATE example_users SET password=MD5(‘new password’) WHERE usertype = "Super Administrator";