How to Send SQL Queries to MySQL from the Command Line

Last Updated: July 12, 2023 Tested

A simple text-based program called MySQL should have been part of your MySQL installation. It lets you send SQL queries directly to the MySQL server and output the results in text format. It is a quick and easy way to test your MySQL installation.

Steps

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c7\/Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-1.jpg\/v4-460px-Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-1.jpg","bigUrl":"\/images\/thumb\/c\/c7\/Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-1.jpg\/aid258060-v4-728px-Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}

1
Find the MySQL program (Should be in a subdirectory called bin under the directory where MySQL was installed)
- E.g. Windows users: C:\mysql\bin\mysql.exe
- E.g. Linux/Unix users: /usr/local/mysql/bin/mysql
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/25\/Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-2-Version-2.jpg\/v4-460px-Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-2-Version-2.jpg","bigUrl":"\/images\/thumb\/2\/25\/Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-2-Version-2.jpg\/aid258060-v4-728px-Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-2-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}

2
Start MySQL - At the command prompt, type: mysql -h hostname -u username -p,
- where
  - host is the machine where the MySQL server is running
  - username is the MySQL account you want to use
  - -p will make MySQL prompt you for the MySQL account password.
Advertisement
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/44\/Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-3-Version-2.jpg\/v4-460px-Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-3-Version-2.jpg","bigUrl":"\/images\/thumb\/4\/44\/Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-3-Version-2.jpg\/aid258060-v4-728px-Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-3-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2b\/Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-4-Version-2.jpg\/v4-460px-Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-4-Version-2.jpg","bigUrl":"\/images\/thumb\/2\/2b\/Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-4-Version-2.jpg\/aid258060-v4-728px-Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-4-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}

4
Type your SQL command followed by a semi-colon (;) and press the Enter key. The response from the server should be displayed on your screen.
- Get out of MySQL, type quit at the prompt and press the Enter key.
  
  {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bd\/Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-5-Version-2.jpg\/v4-460px-Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-5-Version-2.jpg","bigUrl":"\/images\/thumb\/b\/bd\/Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-5-Version-2.jpg\/aid258060-v4-728px-Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-5-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}

Method 1

Method 1 of 1:

Running without the console.

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bf\/Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-6.jpg\/v4-460px-Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-6.jpg","bigUrl":"\/images\/thumb\/b\/bf\/Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-6.jpg\/aid258060-v4-728px-Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}

1
Find the MySQL program (Should be in a subdirectory called bin under the directory where MySQL was installed)
- E.g. Windows users: C:\mysql\bin\mysql.exe
- E.g. Linux/Unix users: /usr/local/mysql/bin/mysql
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e9\/Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-7-Version-2.jpg\/v4-460px-Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-7-Version-2.jpg","bigUrl":"\/images\/thumb\/e\/e9\/Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-7-Version-2.jpg\/aid258060-v4-728px-Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-7-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}

2
Start MySQL. At the command prompt, type: mysql -h hostname -u username -p db_name -e " query "
- where
  - host is the machine where the MySQL server is running
  - username is the MySQL account you want to use
  - -p will make MySQL prompt you for the MySQL account password.
  - db_name is the name of the database to run the query in, and,
  - query is the query that you want to run.
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/80\/Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-8-Version-2.jpg\/v4-460px-Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-8-Version-2.jpg","bigUrl":"\/images\/thumb\/8\/80\/Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-8-Version-2.jpg\/aid258060-v4-728px-Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-8-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}

3
Enter your password when prompted.
- MySQL should return the result of your query.
  
  {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a0\/Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-9-Version-2.jpg\/v4-460px-Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-9-Version-2.jpg","bigUrl":"\/images\/thumb\/a\/a0\/Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-9-Version-2.jpg\/aid258060-v4-728px-Send-Sql-Queries-to-Mysql-from-the-Command-Line-Step-9-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}

Expert Q&A

Search

Add New Question

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Tips

Be sure to include; at the end of your query if you are using the console so it knows you are done with the query.

Thanks
Helpful 0 Not Helpful 0
You can specify the password on the command line by putting it directly after the -p, e.g. mysql -u username -h host -p password . Notice there is no space between the -p and the password.

Thanks
Helpful 0 Not Helpful 0
If you are running it from the command line and not using the shell, you can use the -B flag (e.g., mysql -u username' -h host -p db_name -Be " query ") to get the output in batch mode, instead of in the default MySQL tabular mode, for further processing.

Thanks
Helpful 0 Not Helpful 0

Submit a Tip

All tip submissions are carefully reviewed before being published

Submit

Thanks for submitting a tip for review!

Warnings

Be sure you check what queries you run before you run them, as you don't want to accidentally drop a whole database!

Thanks
Helpful 0 Not Helpful 0

Log in

How to Send SQL Queries to MySQL from the Command Line

Steps

Running without the console.

Expert Q&A

Tips

Warnings

You Might Also Like

About This Article

Is this article up to date?

Quizzes

You Might Also Like

Featured Articles

Trending Articles

Featured Articles

Featured Articles

Watch Articles

Trending Articles

Explore Categories