Can't mysql_secure_installation a fresh MariaDB on fresh Ubuntu 16.04 LTS

Collin M. Barrett asked:

I am trying to run mysql_secure_installation on a fresh install of MariaDB on a fresh Ubuntu 16.04 LTS server. I installed via the exact instructions found here. When prompted for Remove anonymous users? [Y/n], I provide a [return] to accept the default Y. I am then getting the following error:

Remove anonymous users? [Y/n]
/usr/bin/mysql_secure_installation: 203: /usr/bin/mysql_secure_installation: cannot create .mysql.26327: Directory nonexistent
/usr/bin/mysql_secure_installation: 205: /usr/bin/mysql_secure_installation: cannot open .mysql.26327: No such file
... Failed!
Cleaning up...

Any ideas how to solve this? I always used this same process on 14.04 with success, so my hunch is it is some sort of bug or new way of doing things on Ubuntu 16.04.

Thanks.

My answer:


Before you ran mysql_secure_installation you changed to a directory that no longer exists. To resolve the problem, change to a directory that exists, and run it again.


View the full question and answer on Server Fault.

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.