Answers for "how to install mysql community server on windows 10"

mysql install windows 10

Just go to 
https://dev.mysql.com/downloads/installer/
Choose your os and version

Follow the  instaler steps and install.

Its actually easy if you install Xamp or Wamp.
I don't know if this helped.

Good Luck :)

how to use mysql in windows offline

UPDATE mysql.user SET password=PASSWORD("my-new-password") WHERE User='root';
FLUSH PRIVILEGES;