WampServer

Hello I have 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

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.

32bit vs 64 bit .... that was not your problem.

To be honest you are probably better off using the 32bit.

After adding a password to the 'root' userid you have to tell myphpadmin what you have done, as it uses 'root' to connect to MySQL.

So when you do that again, just edit this file afterward.

edit c:\wamp\apps\phpmyadmin3.x.y\config.inc.php

If you change it to this, when you run phpmyadmin the browser will throw a credentials challenge dialog and you can enter your userid/password.

$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['Servers'][$i]['LogoutURL'] = 'http://localhost/';

Thanks for the help RiggsFolley, sorry I was distracted. Actually running this whole thing on my designing computer has really slowed me down. I have an old laptop that I am loading Ubuntu on that I will use a a dedicated server. I will try this again next week.

When i do I will try as you suggested.

Thanks, Bill