Connecting to MySQL database from the command line?

To connect MySQL from the command line, firstly open command prompt. You can do this with the help of shortcut key “Windows + R”. On clicking, a panel will open and you need to type CMD and need to press OK button as shown below −

After pressing the OK button, you will get command line window.

Reach the MySQL Server “bin” directory as shown in the following screenshot −

Now you have reached the bin directory. Type the following statement in order to connect with MySQL.

mysql -u yourUserName -p

Apply the above statement to connect with MySQL. The snapshot is as follows with username “Manish” and password −

George John

Published on 21-Dec-2018 12:14:58