What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
MySQL error 1045 is an authentication failure. The server rejected the combination of account name, host and credentials sent by your client. Start with the smallest safe test: run mysql -u root -p and enter the root password when prompted. Then use the exact suffix in the error, the connection transport, the account’s host row and your MySQL version to choose the next step.
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 MySQL error 1045 means
A typical message is ERROR 1045 (28000): Access denied for user 'root'@'localhost'. It does not mean that the MySQL server is down. It means the server received a login attempt and refused authentication for the named account as seen from the named host.
As an Amazon Associate I earn from qualifying purchases.
Recommended Free Tools
Three pieces of the message matter:
- User:
rootis the account name the client presented. - Host:
localhostis part of the account identity. MySQL treats a root account associated withlocalhostas distinct from one associated with an IP address or another hostname. - Password status: the ending
using password: NOorusing password: YEStells you whether the client sent a password.
After installation, a root password may already have been assigned. In that case, the normal login form is mysql -u root -p, which asks for the password interactively instead of placing it in your shell command or history.
Use the error suffix to choose your first check
using password: NO
This says the client sent no password. The usual cause is running mysql -u root without the -p option, or using a script or shortcut that does not provide credentials. Retry interactively:
#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 -u root -pType the password at the prompt. Nothing is echoed while you type; that is expected. If the login succeeds, the problem was simply that the original invocation did not send a password.
using password: YES
This says the client did send a password, but the server could not authenticate it for that account and host. The password may be wrong, or an option file may be supplying an old password before you get a chance to type anything.
First retry with an interactive prompt. If the error still reports YES when you did not intentionally provide a password, suppress option-file loading for that one invocation:
mysql --no-defaults -u root -pIf this command works, inspect the MySQL client option files used on your system and remove or update the stale credential. Keep the password out of scripts and shell history whenever an interactive prompt is practical.
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
A safe troubleshooting sequence
- Record the complete error. Keep the exact user, host and
using passwordsuffix. Do not troubleshoot a generic “access denied” message without those details. - Try an explicit prompt. Run
mysql -u root -pand enter the password assigned during installation. - Eliminate hidden client settings. If a password appears to be sent unexpectedly, run
mysql --no-defaults -u root -p. - Test the intended transport. Compare the default
localhostconnection with an explicit TCP connection to127.0.0.1. - Check the matching account row. MySQL matches both
UserandHost; verify that the row for the connection you are making exists and uses the expected authentication plugin. - Reset only when the password is genuinely lost. Use the official recovery procedure for the installed MySQL version and operating system, then assign a new credential with
ALTER USER. - Review version-specific authentication support. Do not copy an old plugin or safe-mode command into a newer server without checking that version’s procedure.
Why localhost and 127.0.0.1 can behave differently
For a connection to localhost, MySQL programs normally try the local Unix socket unless connection parameters force TCP/IP. By contrast, -h 127.0.0.1 explicitly requests TCP/IP. These are different connection paths and can select different account rows or authentication behavior.
Compare the two transports
| Command | Typical transport | What a failure suggests |
|---|---|---|
mysql -u root -p |
Unix socket when the client defaults to localhost |
Check the root account row for Host='localhost', its password and its plugin. |
mysql -h 127.0.0.1 -u root -p |
TCP/IP | Check whether a matching row exists for the TCP connection’s host and whether the server permits that authentication path. |
A socket-authenticated root account does not automatically authenticate a TCP client. Conversely, a TCP test can fail even when the socket test succeeds. Test the transport your application or administration workflow is meant to use; do not “fix” a transport mismatch by granting a broad account.
Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Scan for outdated or missing drivers - takes under a minute3Clear out junk files and repair common Windows errorsInterpret common transport results
- Socket works, TCP fails: the credentials may be correct, but the account or authentication method is limited to the local socket/host entry.
- TCP works, socket fails: the
localhostrow, socket location or socket-specific authentication setup may not match the client. - Both fail with
YES: verify the password and remove any stale option-file credential before changing grants. - Both fail with
NO: the client is not sending a password; use-por correct the calling script.
Check the User and Host grant rows
MySQL account matching is exact enough that 'root'@'localhost' and 'root'@'127.0.0.1' are separate identities. A row for one host does not prove that the other connection will authenticate. The same applies to a machine name, an address supplied by DNS and any other host value shown by the error.
After obtaining administrative access through a working account or transport, inspect the root rows:
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)
mysql -u administrator -p -e 'SELECT User, Host, plugin FROM mysql.user WHERE User = ''root'';'The exact quoting required by your shell can vary. The important result is the list of User, Host and plugin values. Compare it with the host in the 1045 message and with the transport used by your command.
You can also inspect privileges for a specific identity:
Free tools Windows power users keep installed
One-click scans. No signup required.
mysql -u administrator -p -e 'SHOW GRANTS FOR ''root''@''localhost'';'Replace the host in the statement with the host value you are actually diagnosing. If no matching row exists, the server cannot authenticate that user-host combination. If a row exists, verify its credential and plugin rather than creating an unrestricted replacement.
Do not use Host='%' as a shortcut
A wildcard host permits connections from any host. The MySQL security guidance warns that such a grant leaves the account insecure. It also hides the original transport or host mismatch instead of correcting it. Prefer the narrow, specific host identity required by the installation and application.
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
When the root password is known
Use the password interactively first:
mysql -u root -pIf the command still fails, repeat it with option files disabled:
mysql --no-defaults -u root -pA successful second command proves that a client configuration file was injecting a different credential or setting. Find the relevant option file for your platform, remove the obsolete password or update it, and then retest without --no-defaults. Do not put a live password directly on the command line unless you understand the exposure in process listings, history or logs.
When the root password is lost
Do not guess at old “skip grant tables” commands copied from an unrelated MySQL release. Password recovery is version- and platform-specific. Follow the official reset procedure for the exact server version installed on the machine.
The recovery flow has these stages:
- Identify the installed version and platform. The supported startup option, service command and authentication defaults depend on them.
- Stop the normal server service. Ensure that only the intended recovery instance will access the data directory.
- Start the documented temporary recovery mode or initialization-file method. Use the syntax prescribed for that version; do not improvise flags from an older tutorial.
- Connect locally with administrative access. The recovery procedure provides a controlled path to issue account changes.
- Assign the new credential with
ALTER USER. Target the exact identity, such as'root'@'localhost', that your normal connection will use. - Stop the temporary instance and restart normally. Leaving recovery mode active can bypass normal authentication and is unsafe.
- Test both the intended socket or TCP command and the application connection. Confirm that the host identity and plugin match the production path.
For a known local identity, the account change has the following form:
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.
ALTER USER 'root'@'localhost' IDENTIFIED BY 'S3cure-Example-Only-Change-Me!';Use a long, unique secret of your own instead of the example value, and change the host portion if the account row you are repairing is different. The statement must be executed while you have the administrative access provided by the recovery procedure.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.If MySQL was initialized without a password
MySQL documents that initializing the data directory with mysqld --initialize-insecure can allow passwordless root login. The server treats that as a security risk and expects you to set a password for the root account.
The Tool Desk
Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →If this describes the installation, test the documented passwordless local login only as part of the initial setup, then set a password immediately with ALTER USER. Do not leave an insecurely initialized server accessible to other users or networks while you postpone that change.
Authentication-plugin compatibility by MySQL version
Authentication plugins are not interchangeable across all releases. MySQL 8.4 disables mysql_native_password by default, and MySQL 9.0 removes it. A client or account configured around that legacy plugin can therefore fail after an upgrade even when the password has not changed.
| Server release | Plugin fact | Practical response |
|---|---|---|
| Before 8.4 | Legacy plugin behavior depends on the server and account configuration. | Inspect the account’s plugin value before changing it. |
| 8.4 | mysql_native_password is disabled by default. |
Use a current client and the server’s supported authentication method; enable legacy behavior only when the version-specific documentation and compatibility requirement justify it. |
| 9.0 and later | mysql_native_password is removed. |
Upgrade or reconfigure clients and accounts to a supported plugin rather than trying to restore the removed default. |
Changing a plugin can affect every client that uses the account. Treat it as a migration decision, not as a generic response to every 1045 error. First establish whether the failure is actually a wrong password, a host-row mismatch or an option-file credential.
Decision table: choose the least disruptive fix
| What you know | Most likely issue | Next action |
|---|---|---|
Error ends in using password: NO |
No password was sent. | Run mysql -u root -p. |
Error ends in using password: YES; you did not type a password |
An option file supplied one. | Run mysql --no-defaults -u root -p, then correct the option file. |
localhost works; 127.0.0.1 fails |
Socket and TCP use different account or authentication paths. | Inspect the matching User/Host rows and use the intended transport. |
127.0.0.1 works; localhost fails |
The local socket path or localhost row does not match. |
Check the socket connection settings and the 'root'@'localhost' identity. |
| Password is unavailable | The credential must be replaced. | Use the official, version-specific reset procedure, then run ALTER USER. |
| Failure follows an upgrade | Client or authentication-plugin incompatibility. | Check the server release and account plugin; move to a supported method. |
Common mistakes that make the problem worse
- Adding
-pand typing a password on the same command line: this can expose the secret in shell history or process information. Let the client prompt instead. - Assuming
localhostmeans TCP: it normally selects a Unix socket. Use-h 127.0.0.1when you intentionally need TCP/IP. - Granting
rootto%: a wildcard host broadens access to every host and does not diagnose the original mismatch. - Running a reset command from a different MySQL version: startup and recovery options change. Use the procedure for the installed release and operating system.
- Changing the plugin before checking the account row: plugin edits can break existing clients and will not correct a wrong host or stale password.
- Leaving temporary recovery mode running: restore normal server startup as soon as the account change is complete.
Verify the repair
- Run the exact command your administrator or application needs, including its intended host option.
- Confirm that the error no longer reports 1045 and that the account is the expected user-host identity.
- Test the alternate transport only if you need it; a successful socket login does not certify TCP access.
- Remove obsolete credentials from client option files and scripts.
- Record the MySQL version, account host row and authentication plugin so a future upgrade can be checked before it reaches production.
The durable fix is the narrow one: send the intended password, use the intended socket or TCP transport, authenticate against the matching User/Host row, and keep the account’s plugin compatible with the installed MySQL release.
Quick wins for a faster PC:
Repair Windows errors before they cause bigger problemsFix Now →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →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.
