Go Back   EQEmulator Home > EQEmulator Forums > Development > EQEmu Operations Center

EQEmu Operations Center Web development tools

Reply
 
Thread Tools Display Modes
  #1  
Old 05-31-2019, 03:02 PM
strugglegenerator's Avatar
strugglegenerator
Hill Giant
 
Join Date: May 2012
Location: Minnesota
Posts: 231
Post Can't connect to MySQL server on 'localhost' <10061 "Unknown error">

I am so defeated right now.

My server was up and running fine for a week and now today I was unable to login to my SQL server at all because I kept getting error:
"Can't connect to MySQL server on '127.0.0.1' (10061).

I tried everything I could find on the forums, but nothing worked. No, my passwords never changed, literally I changed absolutely nothing. Server worked fine when I went to bed. Woke up, can't login to my own database.
So I gave up and decided to delete my entire server and start fresh.

However, even a fresh install is not working. I keep getting the same error "Can't connect to MySQL server on 'localhost' <10061 "Unknown error">


Any insight is greatly appreciated. If you are going to bash me, don't bother posting.
Reply With Quote
  #2  
Old 05-31-2019, 04:13 PM
strugglegenerator's Avatar
strugglegenerator
Hill Giant
 
Join Date: May 2012
Location: Minnesota
Posts: 231
Default

I figured it out. MariaDB went corrupt. I uninstalled MariaDB and did a fresh EQEmu Windows install and everything worked fine. Then I re-imported my backed up database and I'm back to where I was before MariaDB became corrupt.

Why MariaDB went corrupt is beyond me.
Reply With Quote
  #3  
Old 05-31-2019, 04:43 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

Do you happen to be running a file sharing program or a streaming service on this computer?

Port 3306 has been known to be hijacked by other programs.
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #4  
Old 05-31-2019, 06:23 PM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,333
Default

Aside from Uleat's suggestion, also check task manager/services to make sure your mysql/mariadb is up and running (as a service). That error is common to that too.
__________________
Hanging out at Antonica.World
Reply With Quote
  #5  
Old 05-31-2019, 08:38 PM
strugglegenerator's Avatar
strugglegenerator
Hill Giant
 
Join Date: May 2012
Location: Minnesota
Posts: 231
Default

I use Google Play Music to stream songs but I don't use any file sharing programs.

The only thing I can think of that may have caused MariaDB to fail was when my computer got a blue screen of death while I was using the server. It rebooted fine, and I was able to log back in to my server, but the next day, MariaDB no longer worked.

Maybe the blue screen of death knocked something out in MariaDB?

I did check if MySQL/MariaDB was up and running (as a service) and it was, however, it still did not let me in, which is why I think it just went corrupt.

Is it possible to simply re-install MariaDB, instead of re-installing the entire EQEmu PEQ server from scratch?
Reply With Quote
  #6  
Old 06-01-2019, 06:22 AM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,333
Default

Quote:
Originally Posted by strugglegenerator View Post
Is it possible to simply re-install MariaDB, instead of re-installing the entire EQEmu PEQ server from scratch?
When you download Akka's install, the 'eqemu_installer_files.zip' file. Inside that zip is the mariadb install, as well as all the other installs. They can each be installed seperately, but Akka's batch file (install script) automates it all, for ease of use.
__________________
Hanging out at Antonica.World
Reply With Quote
  #7  
Old 06-01-2019, 12:07 PM
strugglegenerator's Avatar
strugglegenerator
Hill Giant
 
Join Date: May 2012
Location: Minnesota
Posts: 231
Default

Awesome thank you guys!!!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 07:54 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3