On Fri, 19 Jun 2020 12:27:02 -0700 ubuntu@enabled.com wrote:
Hi there,
I am doing a poor job installing mariadb.
Yes.
I need to install mariadb on a new ubunutu server.
Yes.
I attempted to set the root password and was having difficulties getting mariadb in a usable state after that.
Don't do that. The mysql root user is only accessible by the unix root user and therefore its secure as your root user. It needs to stay like this so that upgrades work. Create a new admin user like this answer: https://stackoverflow.com/questions/41846000/mariadb-password-and-unix-socke...
So I attempted a purge and reinstall of mariadb (same version).
That's the wrong way to solve a problem.
Now I cant start the daemon and I dont have a /var/lib/mysql directory anymore. What can I do?
create it: sudo -u mysql mysql_install_db
$ sudo mysql_secure_installation
not required.
noah@nuc2:~$ sudo systemctl restart mariadb
then do this ^ again