0

The server admin is ill and unreacheable, I have virtual server accounts. The mysql server crashed, and have no backup. The system is a centos 7 with virtualmin.

Jose Vallarino
  • 1
  • 5
    Without the ability to login into the server and gracefully shutdown the machine, you only have one other choice, and that is to do it by force. Press and hold the power button. You should avoid doing this unless you are authorized to do so and understand the risk to the database. – Ramhound May 21 '23 at 04:47
  • The server admin should have planted all system & application passwords in an envelope for example to ensure that this kind of issue does not require such force. What if they just ups and leaves? What if they die? First thing you should do is when they come back - get a written backup of the passwords salted away somewhere else you could he held hostage. – Bib May 21 '23 at 09:58
  • Ohh, I forgot to tell you, I can log in with several accouts, but no root o sudoer. @Bib: totally agree. – Jose Vallarino May 21 '23 at 12:47
  • This is known as the Bus Factor. You have a bus factor of 1. That is bad, very bad. – Tetsujin May 21 '23 at 17:42
  • @Tetsujin I understand the bus factor (or lottery factor, if you're one of those flippin' "sunny disposition" people) is the number you can lose WITHOUT operations failing, meaning this orgs m80-went-off-in-the-lads-pocket number would be zero. Though, I may be wrong. Just how I recall hearing it. – music2myear May 22 '23 at 02:56
  • @music2myear - ah, yes, zero-based. My bad. – Tetsujin May 22 '23 at 07:03

1 Answers1

0

Can't be done, and it would be a poor system if it could be.

Remember, any system that you can get from access to one Db all the way to now I can restart the server would be compromised by bad actors in moments. The same good choices keeping them out are also keeping you out.

music2myear
  • 41,771