Yesterday, I got MySQL to work like it should, and everything was fine. Today, I hopped on after the server restarted for it's updates at 3 AM, and I can't connect to the MySQL server. The exact error is:
#2002 Cannot log in to the MySQL server
My gaming servers that are using it as well can't connect, so I know it isn't just phpmyadmin. I'm wondering whether this is a problem on my part, or on the server's.
MySQL problem.
-
- New to forums
- Posts: 7
- https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
- Joined: Mon Sep 12, 2011 2:25 pm
Re: MySQL problem.
If this is on an unmanaged dedicated server/VDS, have you double-checked that MySQL is running? If it's not configured to start at boot, that might be the source of your problem.
Re: MySQL problem.
I'm browsing through the preferences on MySQL Workbench, but I can't find it. And even then, how would I activate MySQL manually?
Re: MySQL problem.
I don't know enough about your installation to say, but if it's a system service, you should be able to start it through the Windows Services snap-in (search for "services" in the start menu field). If it's just a standalone program, you should be able to start it from a shortcut.
Re: MySQL problem.
When I tried activating it through services, this popped out.


Re: MySQL problem.
Does the Windows error log show anything, or logs that MySQL might be keeping (in its folder)? It sounds like it might be misconfigured.
Re: MySQL problem.
If it's misconfigured, then would it be fine if I just reinstall all of the MySQL? I don't have anything to lose, really.
EDIT:
Oh, sweet. I just reinstalled it and it worked. Thanks, though! I probably wouldn't have done it if you didn't mention that it might've been misconfigured.
EDIT:
Oh, sweet. I just reinstalled it and it worked. Thanks, though! I probably wouldn't have done it if you didn't mention that it might've been misconfigured.
Re: MySQL problem.
I'd also recommend doing another reboot to make sure that it'll work from here on out.