1. download the zip format from http://mysql.com
2. unzip Mysql to a folder
3. open the folder and copy a “my-*.ini” file as “my.ini”
4. open cmd and cd to the “bin” under the folder
5. run “mysqld –install” as administrator (must go into the bin before install it as a service even if bin folder is in the Path)
6.start the service “net start mysql”
7. add the mysql “bin” in the system’s Path
8. run “mysqladmin -u root -p password” to change the root’s password (the default one is empty)
9. restart the service “net stop mysql” “net start mysql”
10. login the mysql by “mysql -uroot -p”
11. create a new user:
CREATE USER 'new-username'@'localhost' IDENTIFIED BY 'new-password'; GRANT ALL ON *.* TO 'new-username'@'localhost' WITH GRANT OPTION; FLUSH PRIVILEGES;