Mysql Doesn't Ask for Root Password When Installing

MySQL by default sets the username to root and there’s no password. You can now run mysql -u root -p and be logged in without a password. Unfortunately, some applications and services that depend on MySQL will fail if a root password is needed for authentication.

The following method will allow you set a password, or reset it if one was defined and forgotten.

• Run the Services applet (services.msc)

• Find the MySQL service, right-click that entry, then click Stop

• Create a text file containing this one line with any name, but here I will call it mysql-init.txt (replace "NewPassword" but keep everything else):

    ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';
  

• Run the Command Prompt (cmd.exe) as Administrator

• Navigate to the MySQL folder by a command similar to the following (version number may change):

    cd "C:\Program Files\MySQL\MySQL Server 8.0\bin"
  

• Enter the following using two slashes for each slash (\\):

    mysqld --init-file=C:\\path\\mysql-init.txt
  

• Now you may log into the MySQL server as root using the new password, after restarting the MySQL service. The file mysql-init.txt is no longer needed.

For more details see the article How to Reset or Change MySQL Root Password on Linux or Windows.