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

• Related Questions & Answers
• Connect to MySQL database from command line
• After connecting to MySQL server how can we select a database from command prompt?
• Command Options for Connecting to the MySQL Server
• Connecting to the MySQL Server Using Command Options
• How to repair MySQL tables from the command line?
• How to create a database on command line in MySQL?
• How do I drop a MongoDB database from the command line?
• The MySQL Command-Line Client
• How to upgrade MySQL server from command line?
• Connecting to a MySQL database with Java
• How can we analyze the tables of a particular database from MySQL Server command line?
• MySQL query to discover current default database collation (via command line client)?
• How can we return to windows command shell from MySQL command line tool?
• How can we get the list of tables in a particular database from MySQL Server command line?
• Connecting to and Disconnecting from the MySQL Server