Hello Sunil
Step by step Instruction to Install MySQL on Windows 10

Step by step Instructions to Install MySQL on Windows 11

Step 1: Go to Windows start menu and search for “MySQL Shell”, then click to open the application.

Start MySQL Shell from start menu - Install MySQL on Windows

Step 2: Change JavaScript mode to SQL mode by typing the following command:

\sql

Change mode to SQL from JavaScript - Install MySQL on Windows

Step 3: To connect with your localhost root user account, type the following command on MySQL Shell command line:

\connect root@localhost:3306

It creates a session for root user and prompt to enter root password. Enter the password and hit enter.

Connect to your localhost root user - Install MySQL on Windows

Now you can start working with MySQL, to show all databases available currently on MySQL server type the following command:

show databases;

Show all databases on local MySQL server - Install MySQL on Windows

If you are interested to know more about MySQL Shell and how its command works then you can read its official documentation from here.

MySQL Command Line Client (Unicode)

Default “MySQL Command Line Client” comes with two flavors such as:

  • MySQL Command Line Client
  • MySQL Command Line Client (Unicode)

Unicode version of command line is better than old version of MySQL command line so that we are recommending you should use Unicode version.

Here are steps which you need to follow to get started with “MySQL Command Line Client (Unicode)”:

Step 1: Go to Windows start menu and search for “MySQL Command Line Client (Unicode)”, then click to open the application.

Start MySQL Command Line Client (Unicode) from start menu - Install MySQL on Windows

Step 2: Enter your root user password and hit enter.

Enter password - MySQL Command Line Client (Unicode) - Install MySQL on Windows

Step 3: Now you can start working with MySQL, to show all databases available currently on MySQL server type the following command:

SHOW DATABASES;

Show all databases on local MySQL server - MySQL Command Line Client (Unicode) - Install MySQL on Windows

Windows Command Prompt

You can also work with MySQL server through Windows built in command line tool such as command prompt, but it requires a bit of work.

Sunil Pradhan

Hi there 👋 I am a front-end developer passionate about cutting-edge, semantic, pixel-perfect design. Writing helps me to understand things better.

Add comment

Stay Updated

Want to be notified when our article is published? Enter your email address below to be the first to know.

Sunil Pradhan

Hi there 👋 I am a front-end developer passionate about cutting-edge, semantic, pixel-perfect design. Writing helps me to understand things better.