I Can't Log in as Admin
My internet went down last night while I was working on my website so I was forced to stop working on it. I started it up this morning to try and get started, and now I can't login to my website. I'm new to drupal, but I've been doing website design for a few years now.
Set-Up:
= Drupal 6x
= Using the 'Energetic' theme, while using the Admin Module with included admin theme.
= cck, filefield, installed
My Problem:
When I try logging in with either the login block on the home screen, or the ?q=user screen, I get nothing. I type in my username/password, click login, and it refreshes the screen with the blank forms. The blank forms have a red star indication that I have entered an invalid username/password. My other user that I created get's the same results.
I found this topic that relates to a very similar problem: http://drupal.org/node/474912
I attempted the following to fix my problem:
----------
"You are lucky. Go to your drupal db via PMA.
1. Scroll to the end, find check all. From the dropdown menu, Check tables. See what crashed. If all is fine, refresh browser. Try login.
2. If fails, go back, some tables are probably crashed, recheck the tables, now select Repair tables. Try log in. If fails again, I'll have to hear from you first before:)"
----------
I still couldn't log in after completing those two steps, so I tried to complete step three as well, but I do not understand what "pass" row I'm supposed to change. All I see is a 'uid'. Once I click the edit, I don't have any "pass" row?
----------
"3. No, j/k, go on. Only if above fails. Open table "users". You see uid: 0, 1. So 0 is anonymous, 1 is admin. Click the pencil (edit button). Change the "pass" row to your password, and pick MD5 under Function."
----------
The latest thing that I have tried was to enter the following code in MySQL query/queries:
UPDATE `users` SET pass = MD5('newpwd') WHERE uid=1;
Still nothing is working. Any help would be great.

Fixed it!
OK, I finally found the fix after doing some more digging through older topics: http://drupal.org/node/205848
It turns out that while I was toying around with the video_uploads module for Youtube(which isn't compatible with my version of Drupal) I had failed to delete the php.ini file that I was using to up the max file size. Once I cleared the code it worked fine.
I'm happily Logged in!!