Re: Useable guide to first invocation of mariadb - where?

[Richard Owlett <rowlett@cloud85.net>]

On 05/08/2017 12:43 PM, Ric Moore wrote:
> On 05/08/2017 11:06 AM, Richard Owlett wrote:
>
> > I then did
> >   apt-get install mariadb-client mariadb-server
> >
> > As user I (reasonably) see:
> > richard@stretch-2nd:~$ mariadb
> > ERROR 1698 (28000): Access denied for user 'richard'@'localhost'
> >
> > As root I see:
> > root@stretch-2nd:/home/richard# mariadb
> > Welcome to the MariaDB monitor.  Commands end with ; or \g.
> > Your MariaDB connection id is 10
> > Server version: 10.1.22-MariaDB- Debian 9.0
>
> I have no experience with this database, but you may wish to check
> /etc/group and see if there is a mariadb group to add your user to.
> When trouble shooting with a shotgun, you're bound to get lucky. Ric

But there should be fewer side effects with a targeted approach ;}
There is no "mariadb group", but there is a "mysql group" {reasonable as 
mariadb is supposed to be a drop-in replacement for mysql}.

I'll not attempt a brute force "solution" by editing that file. Too much 
unknown/unknowable collateral damage possible.

The pages Joe pointed me to gives the lay of the land. If I had seen 
them before my first attempt months ago, I probably not be in current 
situation. They don't directly give troubleshooting guidance, it was not 
the intended purpose.