mariadb not working well after password reset

[Colin Law]

On Fri, 19 Jun 2020 at 18:51, Noah <noah-list at enabled.com> wrote:
>
> Hi,
>
> I have a new 20.04 server and mariadb has been a little bit of challenge
> to get working.
>
> currently I cant get it started.  And I cant seem to set the mariadb
> root password.
>
> $ sudo systemctl status mariadb
> ● mariadb.service - MariaDB 10.3.22 database server
>       Loaded: loaded (/lib/systemd/system/mariadb.service; enabled;
> vendor preset: enabled)
>       Active: failed (Result: exit-code) since Fri 2020-06-19 17:36:53
> UTC; 7min ago
>         Docs: man:mysqld(8)
>               https://mariadb.com/kb/en/library/systemd/
>      Process: 526935 ExecStartPre=/usr/bin/install -m 755 -o mysql -g
> root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
>      Process: 526948 ExecStartPre=/bin/sh -c systemctl unset-environment
> _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
>      Process: 526951 ExecStartPre=/bin/sh -c [ ! -e
> /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`;
> [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=>
>      Process: 526999 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS
> $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
>     Main PID: 526999 (code=exited, status=1/FAILURE)

You need to find out why it is not starting before worrying about the
root password.  I don't use mariadb so I can only guess at where to
look (since no-one else has responded).  Start by running, in a
terminal
sudo tail -f /var/log/syslog
then in another terminal
sudo systemctl start mariadb
and see if there are any error messages in the log.  Possible there is
some issue with the db configuration file.

Colin