install mysql 8 windows code example

Example 1: how to install mysql 8.0 windows service

Press CTRL+C to copy C:\> "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld"
          --install MySQL --defaults-file=C:\my-opts.cnf

Example 2: how to use mysql in windows offline

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