Connecting to MySQL database from the command line?

MySQLMySQLi Database

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 −

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