maria-discuss team mailing list archive

[Daniel Black <daniel@xxxxxxxxxxxxx>]

On Fri, 19 Jun 2020 12:27:02 -0700
ubuntu@xxxxxxxxxxx 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-socket-authentication-for-root

> 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