mysql server install windows code example

Example 1: how to start mysql server in windows 10

option 1: Launch the MySQL Command-Line Client. To launch the client, enter the following command in a Command Prompt window: mysql -u root -p . The -p option is needed only if a root password is defined for MySQL. Enter the password when prompted.


Option 2:
Start MySQL Server on Windows

On Windows, you can start the MySQL Server using the mysqld program as follows:

First, open the Run dialog by pressing Windows+R keyboards:

Second, type cmd and press Enter:

Third, type mysqld and press Enter:

mysqld

If the bin folder is not in the Windows path environment, you can navigate to the bin folder e.g., C:\Program Files\MySQL\MySQL Server 8.0\bin\ and use the mysqld command.

Example 2: how to use mysql in windows offline

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