MySQL problem.

Ask questions about dedicated servers here and we and other users will do our best to answer them. Please also refer to the self-help section for tutorials and answers to the most commonly asked questions.
Post Reply
Nesstea
New to forums
New to forums
Posts: 7
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Mon Sep 12, 2011 2:25 pm

MySQL problem.

Post by Nesstea »

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.
User avatar
Edge100x
Founder
Founder
Posts: 13129
Joined: Thu Apr 18, 2002 11:04 pm
Location: Seattle
Contact:

Re: MySQL problem.

Post by Edge100x »

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.
Nesstea
New to forums
New to forums
Posts: 7
Joined: Mon Sep 12, 2011 2:25 pm

Re: MySQL problem.

Post by Nesstea »

I'm browsing through the preferences on MySQL Workbench, but I can't find it. And even then, how would I activate MySQL manually?
User avatar
Edge100x
Founder
Founder
Posts: 13129
Joined: Thu Apr 18, 2002 11:04 pm
Location: Seattle
Contact:

Re: MySQL problem.

Post by Edge100x »

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.
Nesstea
New to forums
New to forums
Posts: 7
Joined: Mon Sep 12, 2011 2:25 pm

Re: MySQL problem.

Post by Nesstea »

When I tried activating it through services, this popped out.

Image
User avatar
Edge100x
Founder
Founder
Posts: 13129
Joined: Thu Apr 18, 2002 11:04 pm
Location: Seattle
Contact:

Re: MySQL problem.

Post by Edge100x »

Does the Windows error log show anything, or logs that MySQL might be keeping (in its folder)? It sounds like it might be misconfigured.
Nesstea
New to forums
New to forums
Posts: 7
Joined: Mon Sep 12, 2011 2:25 pm

Re: MySQL problem.

Post by Nesstea »

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.
User avatar
Edge100x
Founder
Founder
Posts: 13129
Joined: Thu Apr 18, 2002 11:04 pm
Location: Seattle
Contact:

Re: MySQL problem.

Post by Edge100x »

I'd also recommend doing another reboot to make sure that it'll work from here on out.
Post Reply