EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   EQEmu Operations Center (https://www.eqemulator.org/forums/forumdisplay.php?f=679)
-   -   Can't connect to MySQL server on 'localhost' <10061 "Unknown error"> (https://www.eqemulator.org/forums/showthread.php?t=42482)

strugglegenerator 05-31-2019 03:02 PM

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">
https://i.imgur.com/u8SYaFJ.jpg

Any insight is greatly appreciated. If you are going to bash me, don't bother posting.

strugglegenerator 05-31-2019 04:13 PM

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.

Uleat 05-31-2019 04:43 PM

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.

Huppy 05-31-2019 06:23 PM

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.

strugglegenerator 05-31-2019 08:38 PM

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?

Huppy 06-01-2019 06:22 AM

Quote:

Originally Posted by strugglegenerator (Post 262710)
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.

strugglegenerator 06-01-2019 12:07 PM

Awesome thank you guys!!!


All times are GMT -4. The time now is 09:01 AM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.