PDA

View Full Version : Can't connect to MySQL server on 'localhost' <10061 "Unknown error">


strugglegenerator
05-31-2019, 03:02 PM
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
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!!!