How to set MySQL password for the first time. ... Next, when you log into MySQL with the command mysql -u root -p, you will be prompted to enter the newly configured password.

Open a command line by opening the Start menu, typing "cmd" into the search bar, then clicking "Command Prompt" from the results. Log in to the MySQL server by typing "mysql -u MySQLuser -p ...