Windows 10下MySQL服务无法启动及连接问题求助
I’ve been wrestling with MySQL issues for hours now—every fix I’ve tried from similar questions hasn’t resolved my problem. Let me break down exactly what’s happening and what I’ve attempted so far:
What I’ve Tried & The Errors I’m Seeing
1. Starting Server via MySQL Workbench
I installed MySQL Workbench and MySQL Server 8.0, logged in as root, then navigated to Server > Startup/Shutdown > Start Server. Here’s the log output:
2018-05-14 21:09:59 - Starting server...
2018-05-14 21:10:07 - Server start done.
2018-05-14 21:10:09 - Checking server status...
2018-05-14 21:10:09 - Trying to connect to MySQL...
2018-05-14 21:10:09 - Can't connect to MySQL server on 'localhost' (10061) (2003)
2018-05-14 21:10:09 - Assuming server is not running
A pop-up error also appears immediately:
【Connect Error】
Could not connect to MySQL: Can't connect to MySQL server on 'localhost' (10061)(code 2003)
2. Manually Installing the MySQL Service
I opened Command Prompt as an administrator and ran:
C:\> "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld" --install
The output showed:
Service successfully installed.
But the service still remains stopped in Workbench, and attempting to start it again results in the same log and connection error as before.
3. Using MySQL Notifier for Service Management
I installed MySQL Notifier to help manage the service, but after restarting Workbench and trying to log in as root, I hit a new authentication error:
【Cannot Connect to Database Server】
Your connection attempt failed for user 'root' from your host to server at localhost:3306:
Authentication plugin 'catching sha2 password' cannot be loaded: Das angegebene Modul wurde nicht gefunden.
Please:
1 Check that mysql is running on server localhost
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the root has rights to connect to localhost from your address (mysql rights define what clients can connect to the server from which machines)
4 Make sure you are both providing a password if needed and using the correct password for localhost connecting from the host address you're connecting from
4. Attempting to Fix the Authentication Plugin Issue
I found a potential fix for the authentication plugin error that requires running commands via CMD, but when I navigate to the MySQL bin directory and run:
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -u root -p
After entering my password, I get this access denied error:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Where I’m Stuck
At this point, I can’t get the MySQL service to run properly, and every path I take to troubleshoot leads to another dead end. I’m completely stuck and would really appreciate any guidance or solutions to get MySQL up and running again.
内容的提问来源于stack exchange，提问作者user7964981
