Tried adding a password to MySQL Console, now it won't let me login.

[livingagain75]

Hello I have some html experience but am a newbie to the world of php and mysql. I was following along with the tutorial on Lynda.com (PHP with MySQL Essential Training) So I downloaded Wampserver2.2 withApache, MySql, PHP SQL Buddy, and Xdebug.

I went to add a password to MySql Console and now it wont let me in.

Here are my steps:

Enter password>
Use my sql>
UPDATE user>
SET password= Password("******" >
WHERE user='root';>
(Query updated 3 rows affected)
mysql>
FLUSH PRIVILEGES>
quit

I am running windows 7
Apache 2.2.22
MySQL 5.5.24
SQL Buddy 1.3.3
XDebug 2.2.0

Thanks in advance.

[livingagain75]

I think I got it figured out. Rookie mistake.

Last night I had accidentally downloaded the 32 bit version to my computer, and today when i installed it I used that version.

Long story short, I installed the 64bit now and I'm okay.

For now anyway, ha ha.