Skip to content
Advertisement

MySQL/MariaDB – Reset password without DB restart

unfortunately I forgot to note down the new password from the last recovery. This means I can’t login as root and the init script can’t restart it due to not having been updated (sys_maint).

Is there a way for me to fix this, most of the guides I found require you to restart the mysql server, well, doesn’t work in my case.

I could kill the process but am I able to start it up again afterwards? If so I could probably use this way, if it works with mariadb: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix

Advertisement

Answer

After spending a few more hours with the issue I tried the one way and it even worked, though I didn’t have any access to the database. So in terms of security concerns, well its even official..: B.5.4.1.2 https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement