[dw2720]

1. Type CREATE DATABASE databasename CHARACTER SET latin1;
(replace databasename with the name of the database you wish to
create)
2. Press Enter/Return.
3. CREATE USER username@localhost; (Change username to the
username you want, keep @localhost)
4. Press Enter/Return.
5. SET PASSWORD FOR username@localhost =
PASSWORD('newpassword'); (Change username and newpassword to your
selected username and password, again keep @localhost)
6. Press Enter/Return.
7. Type GRANT ALL on databasename.* TO username@localhost;
(Again, change username, keep @localhost)
8. Press Enter/Return.
9. Type quit then Enter/Return to exit the MySQL Monitor.
For some reason unknown I get stuck on step 5. when I type in it looks like this
SET PASSWORD FOR blahblah@localhost =
PASSWORD('mypassword');
When I hit the enter button I get error 1064 <42000>: You have an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET PASSWORD FOR blahblah@localhost=PASSWORD('mypassword')' at line 2 How do I fix this error? any help is greatly appreciated