maria-discuss team mailing list archive

[Antony Stone <Antony.Stone@xxxxxxxxxxxxxxxxxxxxxx>]

On Monday 11 January 2021 at 18:53:33, Alexander Nolting wrote:

> I did a fresh 20.04 and MariaDB 10.5.8 install and now I'm having a
> question related to the new authentication concept starting from 10.4.
>
> As stated at Authentication from MariaDB 10.4 and Authentication in MariaDB
> 10.4 — Understanding the Changes

Please can you provide a link to that documentation?

> there are two administrative accounts created: root and mysql.

I don't use Ubuntu, but I do use Debian and Devuan, and on both of those I get 
a 'root' user but I do not get a 'mysql' user.

> Logging as normal user as root into mariadb using unix_sockets is no
> problem

> Doing the same with as mysql
> testusr@host:~$ sudo mariadb -u mysql
> 
> ERROR 1698 (28000): Access denied for user 'mysql'@'localhost'.

1. What do you get from:

sudo mariadb -u root -e "select unique User from user"

	?

That will show you what username have been set up for you.

2. Note that in the first case "sudo ... -u root" you *are* the root user at 
the same time as you are trying to connect as the root user.

In the second case "sudo ... -u mysql" you are the root user but you are 
trying to connect as the mysql user - I think this may break the security 
model.  Does "sudo -u mysql mariadb -u mysql" do anything different?


Antony.

-- 
You can spend the whole of your life trying to be popular,
but at the end of the day the size of the crowd at your funeral
will be largely dictated by the weather.

 - Frank Skinner

                                                   Please reply to the list;
                                                         please *don't* CC me.