Comments - MariaDB removes all users on restart

8 years, 3 months ago Andrew Kilburn

FOUND THE ANSWER.

Really strange if you ask me. When changing the config files I had set the variables like so :

WAIT_TIMEOUT = 6200 INTERACTIVE_TIMEOUT = 6200 INNODB_LOCK_WAIT_TIMEOUT = 120

I believe it caused a syntax error in the config file. I changed the variables to lower case and it worked fine. Maybe it got to the config file and failed and then didn't continue with the setup after restart. Shout out to Ben for the help!

 
8 years, 3 months ago Federico Razzoli

Next time check if mysqld is running. If it is not, check the error log.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.