Problem While Learning PHP

Hello,

I am currently trying to learn PHP. I downloaded the training dvd from lynda.com and started learning. I have installed WAMP server 2. The problem starts when i open MySql console. It asks for the password.. I hit enter. (As trainer asks me to do).
Now the trainer in the video enter following code to set a password in mysql console
CODE;
=============
use mysql
database changed
UPDATE user
Password=PASSWORD<'zyz'>
WHERE user='root';
After that mysql accepts it and do the task but when i try it following happens . I hope i have explained my prblem.

 

You have forgotten the command "SET". Try this:

UPDATE user SET password=PASSWORD("polizelyaseen") WHERE user='root';

 

Also, you need to use password() and not password<>. That is, use parentheses, not angle brackets.

 

Thankyou it helps thx again

 

i reccomend using xampp.

also, why are u in the command line, there are other ways to do this. (atleas on xampp, so im not rlly sure on wampp)

I use xampp because afterwards i always deploy to linux servers.

if im not mistaking wampp installs iis ? wich i dont need .

 

yes, i dont know too why you are prefering to work on command link.. i will recommend you xampp, wamp, or easyphp.. easyphp is the easiest to use if you are new to php programming.