← Back to team overview

maria-discuss team mailing list archive

New Question: MariaDB removes all users on restart



A new question has been asked in "MariaDB FAQ" by andrew_kilburn_g. Please answer it at http://mariadb.com/kb/en/mariadb-removes-all-users-on-restart/ as the person asking the question may not be subscribed to the mailing list.

I am new to MariaDB and have set 3 instances up on 3 different servers. I customised the variables using the MySQL MariaDB client and all was well with the world. However, when coming to restart the machine which the MariaDB databases are currently installed on, it set all the variables back to default values. This is very strange and I'm not sure why this has occurred. After some investigating I found that I can set the variables permanently by changing the My.config file. So this is what I did.

My MariaDB instance had 2 users, the original root and the new user which I created. When I restarted the machine after changing the config file by only adding 3 variables, I found that it removed both users and I now cannot connect to MariaDB using any of the users which have been created. I've done this on two machines and now I only have access to one!

Why is this? Is this some sort of bug? How am I supposed to get back in?

To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-removes-all-users-on-restart/