How.com.vn is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, 10 people, some anonymous, worked to edit and improve it over time.
The How.com.vn Tech Team also followed the article's instructions and verified that they work.
This article has been viewed 187,585 times.
Learn more...
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
- 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
- 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 - where
- Enter your password when prompted.
- 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.
- 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
- 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.
- where
Expert Q&A
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
- You can specify the password on the command line by putting it directly after the -p, e.g. mysql -u username -h host -ppassword. Notice there is no space between the -p and the password.Thanks
- 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
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
About This Article
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.