Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > linux.debian.user > #180877

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

Show all headers | View raw

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.

Back to linux.debian.user | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Useable guide to first invocation of mariadb - where? Richard Owlett <rowlett@cloud85.net> - 2017-05-08 17:10 +0200
  Re: Useable guide to first invocation of mariadb - where? Joe <joe@jretrading.com> - 2017-05-08 19:00 +0200
    Re: Useable guide to first invocation of mariadb - where? Richard Owlett <rowlett@cloud85.net> - 2017-05-08 21:00 +0200
      Re: Useable guide to first invocation of mariadb - where? Richard Owlett <rowlett@cloud85.net> - 2017-05-11 14:40 +0200
        Re: Useable guide to first invocation of mariadb - where? <tomas@tuxteam.de> - 2017-05-11 15:30 +0200
          Re: Useable guide to first invocation of mariadb - where? Richard Owlett <rowlett@cloud85.net> - 2017-05-11 17:00 +0200
  Re: Useable guide to first invocation of mariadb - where? Ric Moore <wayward4now@gmail.com> - 2017-05-08 19:50 +0200
    Re: Useable guide to first invocation of mariadb - where? Richard Owlett <rowlett@cloud85.net> - 2017-05-09 14:40 +0200

csiph-web