To start the server
C:\mysql\bin\mysqld-nt.exe –console
To stop the server
c:\mysql\bin> mysqladmin --user=root --password=yourPasswordHere shutdown
c:\mysql\bin> mysqladmin --user=root shutdown
To setup the root with a password
On Windows, the grant tables do not have to be created. MySQL Windows distributions include the grant tables already set up in the mysql database under the `data' directory. However, you should assign passwords to the accounts. 
The default privileges on Windows give all local users full privileges to all databases without specifying a password. To make MySQL more secure, you should set a password for all users and remove the row in the mysql.user table that has Host='localhost' and User=''. 
You should also add a password for the root user. The following example starts by removing the anonymous user that has all privileges, then sets a root user password: 

C:\> C:\mysql\bin\mysql mysql
mysql> DELETE FROM user WHERE Host='localhost' AND User='';
mysql> FLUSH PRIVILEGES;
mysql> QUIT
C:\> C:\mysql\bin\mysqladmin -u root password yourPasswordHere
To get onto mysql with root and password
c:\mysql\bin>mysql --user=root --password=yourPasswordHere mysql
To Create a User
mysql> GRANT ALL PRIVILEGES ON *.* TO dwight@'%' IDENTIFIED BY 'yourPasswordHere' WITH GRANT OPTION;
Test setup
Run some simple tests to verify that the server is working. The output should be similar to what is shown here: 
c:\mysql\bin > mysqlshow
+-----------+
| Databases |
+-----------+
| mysql     |
+-----------+

c:\mysql\bin > mysqlshow mysql
Database: mysql
+--------------+
|    Tables    |
+--------------+
| columns_priv |
| db           |
| func         |
| host         |
| tables_priv  |
| user         |
+--------------+

c:\mysql\bin > mysql -e "SELECT host,db,user FROM db" mysql
+------+--------+------+
| host | db     | user |
+------+--------+------+
| %    | test   |      |
| %    | test_% |      |
+------+--------+------+

Create a database
c:\mysql\bin>mysql --user=root --password=yourPasswordHere 
CREATE DATABASE survey;

Show Databases or tables
c:\mysql\bin>mysql --user=root --password=yourPasswordHere survey
show databases;
show tables;
drop table client;
select * from client;
describe survey;

create table CLIENT(CLIENT_ID char(32) primary key,
FIRSTNAME tinytext,
LASTNAME tinytext,
EMAILADDRESS tinytext,
PASSWORD tinytext,
ADDRESS tinytext,
PHONE tinytext,
CCTYPE tinytext,
CCNUMBER tinytext,
CCXMONTH varchar(2),
CCXYEAR varchar(4));

create table SURVEY(SURVEY_ID char(32) primary key,
XML mediumtext,
TITLE tinytext,
PASSWORD tinytext,
BANNERIMAGEURL tinytext,
HTML mediumtext,
ENTRYHEADER tinytext,
STARTDATE tinytext,
ENDDATE tinytext,
BACKGROUNDCOLOR tinytext,
FOREGROUNDCOLOR tinytext,
CLIENT_ID char(32));

create table SURVEYRESPONSE(SURVEY_ID char(32),
RESPONSE mediumtext,
I integer );