Source: Accidental Chic, http://goo.gl/nJRxv
Image Source: http://www.civicore.com/images%5Csolutions1.jpg
The first time I couldn't login to my Moodle, I almost panicked. Before I pulled the plug and reinstalled everything, conceding defeat--a temptation when something like this happens--I decided on a simple trick. Login to the MySQL database, copy the encrypted password (that's how they are stored in the MySQL database) of a user I knew and then paste it into the admin's password. After that, login as admin using the other user's password. Did it work? Yes.
But what happens when you can't even login to MySQL? What do you do? This is the exact problem that faced Austin when he wanted his students to login to Moodle recently. This is what Austin wrote--via the MoodleMayhem.org email list--to describe the problem:
The localhost Moodle user account--the one account that Moodle uses to access the MySQL database--wasn't working. In fact, the root user--the most powerful one--couldn't login. Something had gone wrong, but how to fix it?
One of the powerful aspects of a community of users is that someone knows the answer, or can provide a hint to the solution. While there are a million answers to questions like these on the web, every problem is subtly different. Here's my response to Austin's question, which gave him enough information to solve the issue himself with the right customization:
Austin took the response above and customized it for his own server:
Powerful conversations that lead to solutions...that's what folks are able to accomplish when they are willing to share their failures and challenges.
On another note, Austin made another suggestion that I wasn't aware of when I asked him about how he had setup his Windows server:
I'll be trying out this package to see how it works.
Get Blog Updates via Email!
Everything posted on Miguel Guhlin's blogs/wikis are his personal opinion and do not necessarily represent the views of his employer(s) or its clients. Read Full Disclosure