What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
The standard interactive login is mysql -u user -p. Replace user with a MySQL account name, press Enter, and type the password when prompted. Add -h host for a remote server, -P port for a nondefault TCP port, or a database name to select an initial database.
Antihost offers Linux VPS plans with full root access, unlimited traffic on a 1 Gbps port and a 14-day free trial.
What you need before running the command
A command-line login can succeed only when the client, server, account, and transport are all available. Before troubleshooting syntax, confirm these prerequisites:
As an Amazon Associate I earn from qualifying purchases.
Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Fix the driver behind crashes, sound loss and screen glitches3Clear out junk files and repair common Windows errors- The MySQL command-line client is installed and your shell can find the
mysqlexecutable. - A MySQL server is running locally or is reachable over the network.
- You have a valid MySQL account name and its password.
- Your account is permitted to connect from the host where you are running the client.
- The selected transport is available: a Unix socket, TCP port, Windows named pipe, or shared-memory endpoint, depending on the installation.
Authentication plugins, TLS requirements, firewall policy, the server’s bind address, and account host permissions are server-specific. A syntactically correct command therefore does not guarantee a successful session.
The standard interactive login
mysql -u user -p-u (or --user) supplies the account name. A lowercase -p with no password value tells the client to prompt securely after you press Enter. The password is not displayed while you type it.
#1 Best Overall
- BLUE LIGHT BLOCKING GLASSES: Our blue light glasses for women boast UV400 protection, blocking harmful blue rays from computer screens. With these bluelight glasses women, you can enjoy gaming, reading, or watching TV with no worries of eye strain.
- EYE RELIEF: Our blue light glasses are engineered to reduce blurry vision or strain caused by prolonged screen time. These womens blue light glasses aid in better sleep by preventing blue light from disrupting your natural sleep cycle, helping you fall asleep faster and enjoy a more restful night's sleep, making them the perfect christmas present.
- COMFORTABLE: Crafted from durable material, our trendy blue light glasses for woman or blue light glasses men ensure long-lasting comfort. The high-transmittance lenses accessories, gamer gifts for men, help keep your eyes relaxed. Perfect stocking stuffers, gifts for gamers men, christmas gifts for men, halloween costumes.
- LIGHTWEIGHT: These clear blue light glasses feature a lightweight frame, meaning they’ll stay comfy for long-term wear. Perfect as blue blockers glasses for women or mens blue light glasses, these non-prescription fake glasses for men can be worn throughout the day. The blue light blocking glasses women feature polycarbonate HD lenses, which are anti-reflective and restore true color.
- WORRY-FREE PURCHASE: If you experience any issues, our support team is ready to assist you quickly. These are the perfect costume glasses for cosplay dressing up.
MySQL’s documented pattern also permits a database name:
mysql -u finley -p db_nameHere, finley is the account and db_name becomes the initial default database after authentication. The database argument is optional; leaving it out still opens a session, but you must select a database later with USE database_name; or qualify table names in your SQL.
Quick wins for a faster PC:
Clear out junk files and repair common Windows errorsFree Scan →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Do not add a space between -p and a password. More importantly, do not put a real password on the command line at all. The prompt form avoids exposing the secret through shell history or process-argument inspection.
Understanding the command options
| Option | Long form | Purpose | Important detail |
|---|---|---|---|
-u user |
--user=user |
Selects the MySQL account. | The account’s host permissions still determine whether it may connect from your client machine. |
-p |
--password |
Prompts for the password. | Use without a value for interactive entry; avoid placing the secret in the command itself. |
-h host |
--host=host |
Selects the server host. | Omitting it uses the client’s local-server default behavior; a hostname or IP selects another endpoint. |
-P port |
--port=port |
Selects a TCP port. | The capital P matters. The classic MySQL TCP default is port 3306. |
-S path |
--socket=path |
Selects a Unix-domain socket file. | Use it when the server socket is not at the client’s configured default location. |
--protocol=TCP |
— | Forces TCP rather than an automatically selected local transport. | Useful when testing a local TCP listener or a nondefault local port. |
Short options can be combined in some command-line styles, but keeping them separated, as in -u user -p, makes the command easier to audit and less error-prone.
Connecting to a remote MySQL server
mysql -h db.example.com -P 3306 -u user -pThis command asks the client to reach db.example.com over TCP port 3306, authenticate as user, and prompt for the password. Port 3306 is the default for the classic MySQL protocol, so -P 3306 is usually unnecessary when the server really uses that port; including it can make the intended endpoint explicit.
If an administrator configured another listening port, substitute that number:
Rank #2
- WINDEX GAMING WIPES: effortlessly clean all your gaming gear and gaming electronics in one easy step with our new Windex Gaming Wipes
- AMMONIA FREE: our ammonia-free formula is safe to use on all of your favorite gaming equipment like consoles, headsets, controllers, screens, keyboards, and more
- PRE-MOISTENED WIPES: each wipe instantly removes dust, dirt, and stubborn smudges and fingerprints leaving a streak-free shine
- ANTI-STATIC: great for cleaning and wiping down your gaming gear and electronics leaving behind no visible residue
- COMPACT RESEALABLE PACKAGE: store your pack of Windex Gaming Wipes anywhere in your home for whenever a quick and easy wipedown is needed
mysql -h db.example.com -P 3307 -u user -pThe host can be a DNS name or an IP address. Use the name or address that resolves and routes from the machine running the client. A cloud or private-network hostname may work only from an approved network, VPN, or bastion host; that is a network design constraint, not a different MySQL login syntax.
When a remote connection fails, separate the layers:
- If the name does not resolve, correct DNS or use the server’s reachable address.
- If the TCP connection is refused or times out, check that MySQL is listening on the requested port, the server bind address permits remote traffic, and firewalls allow the path.
- If the server is reached but authentication is rejected, verify the account name, password, authentication plugin compatibility, and the account’s permitted source host.
- If the server requires encrypted transport, obtain the required TLS settings from its administrator and add the corresponding client options; the exact settings depend on that deployment.
Why localhost may ignore your port
On Unix-like systems, localhost normally selects a Unix-socket connection. That means this command can use a socket even though it contains a port option:
mysql -h localhost -P 3307 -u user -pThe port number applies to TCP. If the client chooses a local socket instead, there is no TCP port for -P 3307 to select. This behavior often explains why a local connection appears to disregard a custom port.
Free tools Windows power users keep installed
One-click scans. No signup required.
Force TCP by using the loopback IP address:
mysql -h 127.0.0.1 -P 3307 -u user -pOr leave the host name unchanged and force the protocol:
mysql --protocol=TCP -P 3307 -u user -pUse the first form when you want the endpoint to be obvious in scripts and troubleshooting notes. Use the second when the local name is already part of your configuration but the transport must be TCP.
Rank #3
- Ergonomic & Adjustable Design: Fight "text neck" and improve your posture. Designed for comfort, it offers an adjustable height (7.1in-8.5in) (1.4in adjustable range) and angle (5°-85°) Please note: cell phone stand is only 9 inches tall—the length of a standard pencil
- Without blocking subtitles Perfect for office desk Tiktok Face Time Zoom video—this is the ultimate kitchen desk essential for phones! Perfect viewing experience while reducing neck back strain, A must-have for gamers streamers desk, and anyone who values both style and support!
- Sleek & Stable Design fits Otterbox Case: Say goodbye to bent cables, tangles, and tip-overs! LISEN’s stylish adjustable desk phone holder features a built-in charging hole and smart cable management, keeping your phone secure and your workspace clutter-free cool gadgets for men
- ANTI-SLIP DESIGN free hands: The under 10.00 items easy gadgets back and the bottom of this kitchen essentials for women are fully covered by anti-skid silicone, which LISEN stand up desk decor can provide maximum protection device from any scratches and slides
- Your Perfect Viewing Companion:If your product arrives damaged or breaks within 365 days, reach out to LISEN for a quick and hassle-free solution. Struggling with assembly, like tightening the screw? We’ve got your back! Your experience matters to us. (Product including: phone Holder stand*1, screw*1, hexagon screwdriver*1, specification*1)
Connecting through a Unix socket
A local server may expose a socket file at a path that differs from the client’s default. Supply that path explicitly:
mysql -S /path/to/mysql.sock -u user -pThe equivalent long option is --socket=/path/to/mysql.sock. A socket connection does not use a TCP port, so adding -P does not redirect it. If you are unsure of the path, obtain the configured socket location from the server administrator or the server’s configuration rather than guessing.
The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Socket access also depends on operating-system permissions. A file can exist while your account lacks permission to open it. In that case, fix the filesystem or service-account permissions, or deliberately test the server’s TCP listener with 127.0.0.1 and --protocol=TCP.
Transport differences by platform
The client supports several transport types. The default choice depends on the operating system and the arguments you provide.
| Transport | Typical selector | When it is appropriate | What to check |
|---|---|---|---|
| TCP/IP | --protocol=TCP, optionally with -h and -P |
Remote servers, or a local server deliberately tested through its TCP listener. | Hostname resolution, listening port, bind address, firewall rules, and TLS policy. |
| Unix socket | --protocol=SOCKET or -S path |
Local Unix-like installations using a socket file. | Correct socket path and filesystem permissions. |
| Windows named pipe | --protocol=PIPE |
Windows configurations that expose a named-pipe endpoint. | That named-pipe support is enabled and your Windows account can access it. |
| Shared memory | --protocol=MEMORY |
Supported local Windows configurations using shared memory. | Both client and server must support and be configured for this transport. |
On Windows, the bundled client can be started from the MySQL installation’s bin directory or from the MySQL Command Line Client shortcut. Once the server is running, the familiar form is still:
mysql -u root -pThe account name in that example is illustrative; use an account created for your installation rather than assuming that a root account is enabled for every connection method.
Rank #4
- Easy Installation: Our gaming lights have been designed to enhance your entertainment experience. Simply position the led light bar next to your TV or game console to create a game room environment with ease. They come with USB power and a 60 inch cord for direct mounting and mobility
- Audio Syncing & Extensive Mode: The built-in high-sensitivity music sensor allows you to sync the TV led lights to your favorite music. Lights react and move to the beat of music, film and game audio, creating an incredible immersive sound and light experience – and all without the need for an additional hub. You can choose from 64+ patterns, including strobe, illusion, jump, energy, gradient, running, chasing, fluttering mode etc. Each mode can be applied to different scenes
- 64+ Chasing IC+RGB & W Effect: The independent control design of IC+RGB and white all-in-one multifunctional rgbw led bar lights monitor backlight allows you to easily switch the led lights for desk between IC+RGB and white to enjoy a variety of lighting effects, you can choose white lighting mode with high brightness for better illumination when working, etc. Choose IC+RGB lighting mode when you need to create an entertaining atmosphere for the light show, 16 million colours of Color changing rgb light bar let you dance to the beat and create a dynamic party atmosphere
- Dynamic and Dimmable Lights: 1%-full brightness free brightness adjustment gives you the flexibility to adjust dimmable led light bar for room decorations or a variety of occasions
- USB Powered: USB light bars for room can be powered by powernank, usb charger, TV, Monitor, laptop PC mainframe, making behind TV led lighting bar easy to install in any location.TV led lights are powered by the TV usb interface / PC mainframe, can be turned on/off synchronously with TV / PC
Enter passwords safely
Use the interactive prompt
mysql -u user -pAfter you press Enter, the client requests the password without echoing it. This is the preferred method for one-off interactive sessions.
Why inline passwords are risky
mysql -u user -psecretAlthough this syntax may be accepted, MySQL documentation says that specifying a password on the command line should be considered insecure. Shell history, process listings, job logs, terminal recording, and automation diagnostics can expose command-line arguments. Treat the password as compromised if it has been printed or recorded and rotate it according to your organization’s procedure.
Use protected credential mechanisms for repeat work
For scripts or frequent administration, store credentials in a protected MySQL option file or login path file instead of embedding them in commands. Restrict the file so other operating-system users cannot read it, follow your platform’s secret-management policy, and avoid putting the password in source control. The exact file location and permission requirements vary by operating system and MySQL installation, so use the documentation and administrator guidance for your environment.
Even with stored credentials, keep the command’s host, port, and account explicit when connecting to more than one environment. Accidentally running a destructive statement against a production endpoint is an operational risk independent of password security.
Windows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallOutdated 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 matchConfirm that the session is ready
After successful authentication, the interactive client displays the mysql> prompt. That prompt means the client has an active session and is ready to receive SQL.
Statements normally end with a semicolon:
SELECT VERSION();You can also terminate a statement with g. A semicolon or g is required before the client sends a complete statement; pressing Enter alone generally creates a multiline input buffer.
Best Value
- Compatible with Wide Screens - To ensure compatibility with the dual monitor mount, your each monitor must meet three conditions at the same time: First, computer screens size range: 13 to 32 inches. Second, screen weight range: 4.4 to 19.8 lbs. Third, the back of the monitor screen must have VESA mounting holes with a pitch of 75x75mm or 100x100mm.
- Regarding the compatibility with desks - Your desk must meet three conditions at the same time: First, desk material: Only wooden desks are recommended, plastic or glass desks cannot be used. Second, desk thickness range: 0.59" - 3.54". Third, the bottom of the desk should not have any cross beams or panels, as this will interfere with installation. We recommend carefully checking that your desk and monitors meets all above conditions before purchasing.
- Dual C-Clamp Hold - Worried your dual monitors might wobble or slip? Our upgraded base uses a larger platform plus a dual C-clamp structure to lock the dual monitor arm firmly to your desk. Each arm safely keeps your screens steady while you type, click and game—no shaking, no sliding, just a clean and secure setup you can trust every day. It also provides Grommet Mounting installation choice, both options ensure stable and secure fixation for your 0.59" - 3.54" desk.
- Full-Motion Adjustment For Comfortable View - Pull the screen closer when you’re deep in a spreadsheet, push it back to watch videos, or rotate to portrait for coding — moving everything smoothly with just one hand. The monitor stand offers +85°/-50° tilt, ±90° swivel and 360° rotation. Raise your monitor up to 15.75″ to support a healthy sitting posture. Whether you’re working from home, gaming through the night, or switching between video calls and documents, getting the screens to your natural line of sight helps relieve neck, shoulder and back strain so you can stay focused longer with less fatigue.
- Keep Your Desk Organized: By lifting both screens off the desktop, this dual monitor stand opens up valuable space for your keyboard, notebook, docking station or a simple, clutter-free work area. Built-in cable management guides wires along the arms, keeping cords out of sight and out of the way. Enjoy a tidy, modern workstation that looks as good as it feels to use.
To choose a database after connecting:
USE db_name;If the command included db_name at login, that database is already the initial default. You can still switch databases with USE if the account has privileges.
Exit the MySQL client
Run either of these at the mysql> prompt:
QUIT;qOn Unix-like systems, Control-D also disconnects an interactive session. Exiting the client closes the session; it does not stop the MySQL server.
Choose the right connection form
| Goal | Command | Transport or behavior |
|---|---|---|
| Local interactive login | mysql -u user -p |
Uses the platform’s local default, commonly a Unix socket on Unix. |
| Local login and select a database | mysql -u user -p db_name |
Same local behavior, with an initial default database. |
| Remote server on the default classic port | mysql -h db.example.com -u user -p |
TCP, normally port 3306 unless client or server configuration changes it. |
| Remote server on a custom port | mysql -h db.example.com -P 3307 -u user -p |
TCP port 3307 in this example. |
| Local TCP test | mysql -h 127.0.0.1 -P 3307 -u user -p |
Forces a loopback TCP connection instead of the Unix-socket interpretation of localhost. |
| Local socket at a known path | mysql -S /path/to/mysql.sock -u user -p |
Uses the specified Unix socket and no TCP port. |
Troubleshoot a failed login systematically
The shell says mysql is not found
The client is either not installed or its executable directory is absent from your PATH. On Windows, open the MySQL Command Line Client shortcut or change to the installation’s bin directory. On Unix-like systems, install or expose the client according to your distribution’s normal package and path management. This is a client-availability problem, not a database password problem.
The client asks for a password, then rejects it
Check the account name, password, authentication plugin compatibility, and the host from which the account is connecting. MySQL accounts can be restricted by source host, so an account that works locally may be denied remotely even when the password is correct. Avoid repeatedly guessing; use the administrator’s reset or access-grant process.
A local connection reports a socket failure
First determine whether you intended a socket. If yes, verify that the server is running, the socket path is correct, and your operating-system account can open the file. If you intended TCP, replace localhost with 127.0.0.1 or add --protocol=TCP, then specify the server’s actual TCP port.
The connection is refused or times out
These symptoms occur before SQL authentication completes. Verify the hostname, route, server listening state, configured port, firewall rules, and server bind address. A remote MySQL server may intentionally listen only on a private interface, making it unreachable from the public internet even though the service is healthy.
The server is reachable but a database is unavailable
A successful login does not imply access to every schema. If specifying an initial database fails, confirm that the database exists and that the account has privileges on it. Omit the database argument to test authentication separately, then run USE db_name; after login when appropriate.
A required encrypted connection is refused
Some deployments require TLS or a particular authentication plugin. Obtain the server’s required certificate, verification, and authentication settings from its administrator and use the matching client options. Do not disable encryption or certificate verification merely to make a test command pass.
A practical connection checklist
- Identify the endpoint: local socket, local TCP, or remote TCP.
- Confirm the server is running and note its configured socket path or TCP port.
- Start with
mysql -u user -pfor the local default, or add-h hostand-P portfor a remote endpoint. - If
localhostbehaves unexpectedly, force TCP with127.0.0.1or--protocol=TCP. - Enter the password at the prompt rather than placing it in the command.
- Wait for the
mysql>prompt, then run a harmless statement such asSELECT VERSION();. - Exit with
QUIT;,q, or Control-D on Unix.
This sequence keeps transport, authentication, authorization, and SQL execution distinct. That separation makes failures easier to diagnose and prevents a password or database-privilege problem from being mistaken for a port or socket problem.
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.
Recommended Free Tools
