Hey everyone. Newbie here.
I decided to install a local server on my computer, so I could effectively learn PHP. When I started CMD to do a password, heres the result I got.
Yes.. you must leave the space between the cd & ..
Then ...
mysql -uroot (if this is a new install, root will be open to all).
At the mysql> prompt:
set password for root@localhost = PASSWORD ("passwordforyourchosing");
Replace passwordforyourchosing with a password for your root SQL user (which you should NEVER use to connect to db's. Only ever use the root account to create new db's & administer privileges).
Then type:
exit;
and it will say "bye" and you are returned to the C:/mysql/bin prompt.
----