PDF download Download Article PDF download Download Article

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.

    • E.g. Windows users: C:\mysql\bin\mysql.exe
    • E.g. Linux/Unix users: /usr/local/mysql/bin/mysql
  1. 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
  2. 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.
  3. Advertisement
Method 1
Method 1 of 1:

Running without the console.

PDF download Download Article
  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
  2. 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.
    • MySQL should return the result of your query.
  3. Advertisement

Expert Q&A

Ask a Question
      Advertisement

      Video

      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.
      • 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.
      • 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.
      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Thanks for submitting a tip for review!
      Advertisement

      Warnings

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

      About This Article

      Thanks to all authors for creating a page that has been read 190,569 times.

      Is this article up to date?

      Advertisement