Free tools Windows power users keep installed
One-click scans. No signup required.
Use MySQL’s mysql command-line client to connect to a server, authenticate, and submit SQL. For an interactive session, run mysql -h HOST -P 3306 -u USER -p DATABASE, enter the password when prompted, and type statements at the mysql> prompt. For a single query, add --execute; for repeatable work, redirect a saved file or use batch mode. This guide shows each workflow and how to avoid exposing credentials.
Need a server to try this on? Antihost offers Linux VPS plans with NVMe storage, full root access and a 14-day free trial.
What you need before running a query
The terminal client does not contain your data by itself. It opens a connection to a running MySQL server, then sends SQL under a particular account. Have these values ready:
As an Amazon Associate I earn from qualifying purchases.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
- Host: the server name or IP address. If omitted, the client uses
localhost. - Port: the server’s TCP port. The documented default is
3306. - User: the MySQL account name.
- Password: use a prompt or another protected credential method rather than placing it in the command itself.
- Database: the default schema to select after login. You can omit it and select a database later, but specifying it makes scripts clearer.
Your account also needs privileges for the operation you intend to perform. A successful network connection does not guarantee that a particular table can be read or changed; permissions are evaluated by the server for each statement.
The official MySQL 8.4 documentation describes the connection options and the client’s command-line behavior in the Command Options for Connecting to the Server and mysql Client Options references.
#1 Best Overall
- [Ultra-Lightweight Ear Buds Designed for Small Ears] Each earbud weighs only 3.7g and features a compact, ergonomic in-ear design made especially for small ears. Secure, low-profile, and comfortable for workouts, all-day wear or overnight sleeping.The ultra-slim profile sits flush in your ear with no hard edges poking or rubbing, so you can even sleep on your side without discomfort.
- [Immersive Stereo Sound with TOZO OrigX Technology] TOZO OrigX tuning delivers clear vocals, balanced mids, and natural stereo sound for music, podcasts, and videos.
- [Long Battery Life for Daily Use] Get up to 7 hours of playtime on a single charge, with up to 32 hours total using the charging case—ideal for workdays, commuting, and extended listening sessions.
- [Bluetooth 5.3 & Stable Connection] Bluetooth 5.3 provides fast pairing, stable wireless performance, and reduced dropouts as you move around home or office.
- [Deep Bass with Clear Vocals] High-performance drivers produce punchy bass while keeping vocals clean and detailed for everyday listening.
Connect interactively from a terminal
Start with this form:
mysql -h HOST -P 3306 -u USER -p DATABASEReplace the uppercase placeholders with your values. The options mean:
| Part | Purpose | What happens when omitted |
|---|---|---|
-h HOST |
Chooses the MySQL server host. | The client uses localhost. |
-P 3306 |
Chooses the TCP port. | The client uses port 3306. |
-u USER |
Selects the account used for authentication. | The client’s normal account default applies; specify the account explicitly in scripts. |
-p |
Prompts for the password without displaying it as part of the command. | No password prompt is requested. |
DATABASE |
Selects the initial database after login. | No default database is selected. |
When prompted, type the password and press Enter. A successful login displays the mysql> prompt. The client is now waiting for SQL, not shell commands.
Do these 3 things before closing this tab:
1Scan for outdated or missing drivers - takes under a minute2Repair Windows errors before they cause bigger problems3Fix the driver behind crashes, sound loss and screen glitchesRun a query at the mysql> prompt
Terminate an SQL statement with a semicolon. For example:
SELECT id, email
FROM users
LIMIT 20;The client sends the complete statement after the semicolon and prints the result. The line breaks in a multi-line statement are for readability; the semicolon is what tells the interactive client that the statement is complete.
You can select another database during the session:
USE reporting;
SELECT order_id, total
FROM orders
LIMIT 20;Use fully qualified names when a query needs tables from a specific schema:
Recommended Free Tools
Rank #2
- 【IP68 Waterproof Multifunctinal Smart Watch】Torjalph fitness activity tracker smart watch is IP68 waterproof technology ,you can wear it when swimming,handwashing,it's rain-proof which means that you perform multiple exercise modes outside without worrying about sweat or rain corroding your fitness smart watch,and this watch equipped with a 230 mAh large capacity battery magnetic charging ,and this sports activity tracker watch can be used 5-7 days If fully charged.
- 【Larger 1.83'' Full Screen Watch & Multi-dial Selection】1.83 inch full HD color touch screen smart watch for men / women provides excellent 240*284 resolution image quality ,This Bluetooth smart watch offers a better touch experience and remarkable immersion and ,more than 200 watch faces for you to choose from App"Da Fit ", you can change the dial style according to your mood to wear keeping the world on your wrist
- 【Accurate Activity Tracker Smart Watch 】sports watch activity tracker uses sweat and dust resistant breathable silicone strap, our Fitness Tracker Smart Watch for Android iOS Phones supports 12 sports modes,walking,running,bicycle,swimming,badminton,basketball,football,rope skipping. This bluetooth calls smart watch for men women is lightweight and stylish, bringing more convenient and relaxing sports experience while also providing more protection.
- 【Your 24 Hour Personal Daily Health Monitor】Fitness watch for women men full touch screen IP67 waterproof bluetooth smartwatch for Android iOS Phones with heart rate blood pressure monitor multifunction Andriod smart watch with steps counter sleep monitor sports fitness watch, monitoring blood oxygen saturation allows you to understand your physical condition in real time to track fitness progress ,to know your health status in time.
- 【More Functions Bluetooth Call Smart Watch】This fitness activity smart watch full screen for iPhone and Android phones includes a bunch of new features including:The bluetooth smart watch can hang up the phone, receive and display WhatsAPP /Text /Facebook /Twitter /Messenger reminder.Support sedentary reminder, alarm clock, stopwatch, timer,weather information,music control, remote camera control compatible with Android 5.0 and above or iOS 9.0 and above smartphones.
SELECT id, email
FROM accounts.users
LIMIT 20;To leave the client, enter exit; or quit;, or press Ctrl-D in a terminal that sends end-of-file. SQL statements and client commands should not be confused: SELECT ...; is sent to the server, while commands such as leaving the client are handled by the terminal program.
Run one query and exit with --execute
For a one-off statement, pass SQL to --execute:
mysql -h HOST -u USER -p DATABASE --execute='SELECT id, email FROM users LIMIT 20;'The client runs the supplied statement and quits. This is useful for a quick check, a deployment step, or a shell script that needs one result without opening an interactive session. The MySQL 8.4 client-options reference documents that --execute executes the statement and exits.
Keep the password separate from the SQL argument. The single quotes around the SQL above are shell quoting, not MySQL syntax; they prevent the shell from interpreting spaces and punctuation before the client receives the statement. If your SQL itself contains a single quote, use suitable shell quoting for your environment or place the statement in a file instead.
Run a saved .sql file
Put repeatable statements in a file such as query.sql, with each SQL statement terminated by a semicolon:
SELECT id, email
FROM users
WHERE active = 1
LIMIT 20;Feed that file to the client with shell redirection:
mysql -h HOST -P 3306 -u USER -p DATABASE < query.sqlThe client reads the file as standard input, executes its statements, and then exits when the file ends. Redirection keeps the SQL in a versionable file rather than embedding a long command in shell history.
Rank #3
- [Low Noise High Fidelity] New bee guitar cord with 22AWG oxygen-free-copper center conductors provides enhanced signal transfer, the PVC insulation material and the high-density stranded copper double shield provide noise rejection for quiet operation
- [Ideal for Choice] New bee 1/4 straight and right angle metal connectors, ensures a secure connection in any instrument, pedal, or amp jack. L shape great fro on stage guitar stands
- [Wide Compatible] Suitable for mixer, power amplifier, microphone, effector, decoder, equalizer, electoronic organ, electric guitar, electric bass and other electronic equipments. Widely used in the installation of smart home, karaoke speaker, professional stage audio, etc
- [Easy Disassemble] Making incidental repairs quick and easy! Very nice, flexible cable
- [Dont Hesite to Order] 24 hours customer services and professional technology team are standing by
You can combine redirection with batch mode:
mysql -h HOST -P 3306 -u USER -p DATABASE --batch < query.sqlAccording to the client documentation, --batch prints rows with tab separators, puts each row on a new line, and does not use the history file. That format is convenient when another command or script needs to consume the output.
Choose the right command-line method
| Method | Best for | Output and repeatability | Credential consideration |
|---|---|---|---|
| Interactive command | Exploring a schema, trying several statements, and inspecting results manually. | Human-readable prompt-driven output; commands are easy to adjust but less repeatable. | Use -p so the password is requested privately. |
--execute |
One statement in a check, shell step, or short automation task. | Runs the supplied statement and exits; the SQL is visible in the command text. | Do not append a literal password to the command. |
| Input redirection | A saved query or multi-statement script. | The file can be reviewed, versioned, and rerun consistently. | Keep credentials out of the file unless you are using a protected credential mechanism. |
--batch with a file or standard input |
Machine-readable, line-oriented output for downstream processing. | Tab-separated columns and one row per line; no client history file. | Use the same protected authentication method as other modes. |
Interactive mode favors experimentation speed. --execute, redirected files, and batch mode favor repeatability and automation. Pick based on whether a person or another program will consume the result and whether the SQL needs to be rerun unchanged.
PC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchProtect the password
Do not write a password after -p in a command that may be saved, displayed, or inspected. The MySQL manual states: “Specifying a password on the command line should be considered insecure.” A literal password can leak through shell history, process listings, copied terminal output, scripts, or logs.
Use the option with no value:
mysql -h HOST -u USER -p DATABASEThe client then prompts at connection time. For unattended jobs, use a protected option file or login path as described in MySQL’s Account User Names and Passwords documentation. Protect that file with the operating system’s permissions and avoid placing it in a repository or sharing it with query output.
SQL itself can contain sensitive values. Treat query files, redirected output, terminal captures, and automation logs as potentially confidential even when the password is handled correctly.
Connection details that commonly matter
Host and port
Use -h when the server is not the local default. Use an uppercase -P for the TCP port:
Rank #4
- Digital Family Calendar: BSIMB digital calendar wall touch screen puts an end to your chaotic life. Designed for busy families, the digital calendar keeps you organised and in step with your family. Assign different colours and tasks to each family member to make family scheduling easier and more intuitive.
- Easy Setup and Auto-Sync: Plug in, connect to WLAN and auto-syn your electric calendar in minutes. Digital wall calendar compatible with Google calendar, iCloud calendar, Outlook calendar, Cozi calendar and Yahoo calendar. Add events directly on the device or through the ecalendar app. Electronic calendar stays current whether you're at work or traveling—no manual updates needed.
- All-In-One Home Assistant: Smart calendar builds habits and encourage independence with personalised chores. Display daily meal plan to reduce the daily ‘What's for dinner?’ stress. To-do lists keep track of everything you want. Turning chores into valuable achievements with stars and rewards, making life easier and more enjoyable.
- Manage Anytime Anywhere: BSIMB electronic calendar for family stay connected with the powerful ecalendar app. Access and manage your digital wall calendar anytime, anywhere with free features like stars & rewards, photo screensaver, chore charts, meals plans, to-do lists etc. Electronic planner paid features like Magic Import tailor advanced tools for users with special needs.
- Stay in Touch with Loved Ones: Share photos or videos from your phone to electronic wall calendar with app, instantly update your life moment, and keep in touch with your family, especially those who are far away; you can also surprise your smart calendar digital wall by sending him a wish card; it's also great for keeping tech-illiterate elders in touch with the youngsters.
mysql -h db.example.internal -P 3307 -u analyst -p reportingA wrong host or port prevents a connection before MySQL can evaluate your SQL. Confirm the server’s listening address and port with whoever operates it; do not assume that a nonstandard port is interchangeable with the documented default of 3306.
User and default database
The account and the database are separate choices. An account may authenticate successfully but lack access to the database named at the end of the command. Conversely, leaving the database off lets you connect first and then run USE database_name; if your account is allowed to do so.
TCP versus local defaults
The documented command-line options establish the host and TCP port parameters. If your environment uses a local socket, a proxy, TLS settings, or another connection requirement, use the corresponding options and configuration for that server; the four values in the basic example are the starting point, not a guarantee that every deployment has identical transport settings.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Practical query recipes
Inspect a small sample
mysql -h HOST -u USER -p DATABASE --execute='SELECT * FROM users LIMIT 10;'Use a restrictive LIMIT while learning a table. It reduces the amount of output you must inspect, but it does not replace an appropriate WHERE clause when you need a particular subset.
Select only the columns you need
mysql -h HOST -u USER -p DATABASE --execute='SELECT id, email FROM users LIMIT 20;'Naming columns makes the result easier to read and reduces accidental exposure of unrelated fields.
Run several statements from a file
-- query.sql
USE reporting;
SELECT COUNT(*) AS order_count FROM orders;
SELECT order_id, total FROM orders LIMIT 20;Execute it with:
mysql -h HOST -u USER -p < query.sqlHere the file chooses the database with USE, so the database argument is intentionally omitted from the startup command. Use one approach consistently in a project so a script cannot silently run against an unintended schema.
Produce line-oriented output for a script
mysql -h HOST -u USER -p DATABASE --batch < query.sqlBatch output is tab-separated rather than the interactive client’s presentation format. If values can contain tabs or newlines, design the consuming script with that possibility in mind; the client’s documented batch format is simple, not a general-purpose data serialization format.
Diagnose connection and query failures
The client command is not found
Your shell cannot locate the mysql executable. Install the MySQL client appropriate to your operating system or add its installation directory to PATH. This is a local setup problem; it occurs before a server, account, or SQL statement is involved.
Connection refused or timed out
- Check the host passed to
-h. - Check the port passed to uppercase
-P;-pis the password prompt and is a different option. - Confirm that the server is running and reachable from the machine where the command is executed.
- Verify that a firewall, network policy, proxy, or tunnel is not blocking the route.
Changing the SQL cannot fix a failure that occurs before authentication.
Access denied
- Confirm the account supplied with
-u. - Retry with
-pand enter the password at the prompt, rather than reusing a copied command that may contain a typo. - Check that the account is permitted to connect from the client host and has privileges on the requested database.
Do not respond by putting the password directly into the command line; that trades an authentication problem for a credential exposure.
Unknown database or table
Verify the database name at the end of the command, or connect without one and run USE database_name;. Then check the table name and spelling. A query file that assumes a database should either name it in the command or contain an explicit USE statement.
The prompt appears to be waiting
In interactive mode, an unfinished statement has not reached its terminating semicolon. Review the preceding lines, add the intended SQL, and finish with ;. If you started a statement accidentally, cancel the current input using the client’s normal interrupt behavior for your terminal and retry carefully.
The output is unexpectedly large
Stop and refine the statement before redirecting more data. Select only required columns, add an appropriate filter, and use a bounded sample while exploring. Large results consume terminal space and can create oversized logs or files; performance depends on the schema, indexes, privileges, server configuration, and data volume, so there is no universal runtime or output-size guarantee for a command.
Make command-line queries safer and repeatable
- Start read-only: use a narrowly scoped
SELECTto confirm the host, account, database, and table before considering a change. - Qualify the target: include the intended database explicitly, either in the startup command or with
USEin the file. - Limit exploration: begin with a small result set and expand only when you know the expected volume.
- Save stable SQL: put recurring statements in a reviewed
.sqlfile instead of relying on an improvised shell line. - Separate secrets: use the password prompt or a protected option-file/login-path mechanism; never commit credentials with SQL.
- Choose output deliberately: use ordinary interactive output for people and
--batchfor simple tab-separated consumption by another command. - Check privileges: ensure the account has only the access required for the task and remember that permissions and server configuration affect what a query can do.
These practices do not make a query inherently fast. They make its target, credentials, output, and repeatability easier to reason about while leaving performance to the actual schema, indexes, server configuration, privileges, and data volume.
A complete workflow
- Identify the server host, TCP port, account, and intended database.
- Connect with
mysql -h HOST -P 3306 -u USER -p DATABASE, keeping the password out of the command. - At
mysql>, run a small, read-only query and terminate it with;. - For a single repeatable statement, move the SQL to
--execute; for multiple statements, savequery.sqland use input redirection. - Add
--batchwhen a downstream script needs tab-separated rows with one row per line. - Review host, port, account, database, privileges, and statement boundaries when a command fails.
- Keep query files, output files, shell history, and credential configuration protected from unauthorized readers.
With that workflow, the same mysql client covers exploratory sessions, one-off checks, and repeatable command-line jobs without exposing a password as a literal command argument.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
Quick wins for a faster PC:
Scan for outdated or missing drivers - takes under a minuteDriver Scan →Repair Windows errors before they cause bigger problemsFix Now →
