On Windows we can run MySQL in following steps:
- Open Console Window->Type "mysqld -u root". This means we start the mysql server with username root. This program will handle all the communications between our console window and the actual data;
- After starting the server, we need to use a client to connect to the server and communicate with it. the mysql program is right for this. Next in the command console, we type "mysql -u root -p" to connect the server. By default, after the installation,the default password for user root is blank. If you have changed the password, please enter your new password after the prompt "Enter password:";
- If all go well, congratulations, you have successfully connected to the server and next you can use some commands from this link to handle subsequent database processing. http://pixelstech.net/article/index.php?id=1306747097