Modcraft - The community dedicated to quality WoW modding!

Legion- / WoD- / Mop- / Cata-Modding => Miscellaneous => Topic started by: Jalzm on July 04, 2017, 09:14:45 pm

Title: How to start mysql server?
Post by: Jalzm on July 04, 2017, 09:14:45 pm
I don't know how to restart the mysql server after I've closed it. The commands I found online don't start my WoD server, just a generic mysql server.
Title: Re: How to start mysql server?
Post by: schlumpf on July 04, 2017, 09:28:38 pm
This depends on so many variables, like
* the os/distro
* installed as service or container or other
* what version of MySQL
* how did you close it
* how did you start it the first time
* how is the fact you're running a wod server relevant for the MySQL server part?
Title: Re: How to start mysql server?
Post by: Jalzm on July 04, 2017, 09:56:51 pm
This depends on so many variables, like
* the os/distro
* installed as service or container or other
* what version of MySQL
* how did you close it
* how did you start it the first time
* how is the fact you're running a wod server relevant for the MySQL server part?

Windows 7
Installed as Windows Service
Version 5.6
Closed it normally
It started automatically after mysql was installed
I thought there was a difference as my password doesn't work when I start mysql. I guess I was wrong. I don't know very much about mysql.
Title: Re: How to start mysql server?
Post by: Amaroth on July 05, 2017, 08:27:51 am
You are kinda confusing here. So, what is your problem - you can't make your WoW WoD server emulator run, or an actual MySQL server? These are 2 completely different things.

For MySQL just Google.: https://stackoverflow.com/questions/12972434/restart-mysql-server-on-windows-7
And if you continue having issues with MySQL, I'd suggest you to reinstall it and follow MySQL installation guide very, very closely. If you are using TrinityCore, such guide is here:
https://trinitycore.atlassian.net/wiki/display/tc/Windows+Requirements (point 3)

BUT if starting an actual WoW server is what you are having issues with - there is nothing like restarting a server, at least not on WotLK, and I doubt something has changed. Whenever server is being restarted, it is actually completely closed (stopped) and then either you or some external script (usually called restarter) have to start server again. So there is no actual restart, only re-start. And, like I said, MySQL server and WoW server are two completely separated and different applications and things. Running MySQL server means you are running application which is responsible for inserting, editing, removing and retrieving data from database. Thats not WoW server.
Title: Re: How to start mysql server?
Post by: Steff on July 05, 2017, 11:59:00 am
Open the services and have a look at the mysql state. Is it started there? If not start it. Control the start type.