The Ultimate Guide to High Availability with MariaDB

Accidentally deleted mariadb.sys user

I deleted the MariaDB.sys user and now I cannot view any of the users I have created. I installed MariaDB using homebrew on MacOS.

I have tried uninstalling and reinstalling MariaDB but the issue remains.

I am a student just trying to setup my machine for a databases class. Is there a way to remove all associated data from my system and reinstall MariaDB? I don't really care about recovering data, I just want a clean install that I can use.

Any help would be great.

Answer Answered by Daniel Black in this comment.

recreate the user with:

CREATE USER `mariadb.sys`@`localhost` ACCOUNT LOCK PASSWORD EXPIRE

Comments

Comments loading...
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.