I decided to learn php, mysql and installed WAMP to "C:\wamp" and tried to define a password according to a CD tutorial that I obtained recently. but when i write the last line "WHERE user=.'root'..." on mysql console there shows up an ERROR message. I don't understand why this is happening. (using on Vista.) I appreciate your helps.
I suggest to give XAMPP a try. In XAMPP, a single installer contains bundled PHP, Apache and mysql applications but an excellent user friendly admin page that you can customize your PHP and MySQL settings. This means you do not need to set complicated syntax like what you do in WAMP. About the error you receive, it is a mysql syntax error, in MySQL i use: Try using different style of quoting a variable:, one way to test besides number 1 in your keyboard that gives this: ` If not try this: ' (single quote below double quotation in your keyboard). Try to see what works for you