[debian-mysql] Bug#1109404: /usr/bin/mytop: Access denied for user 'root'@'localhost'

[Olaf van der Spek]

Op do 7 aug 2025 om 09:02 schreef Otto Kekäläinen <otto at debian.org>:
>
> Hi!
>
> > olaf$ ./mytop -h ""
> >
> > * username you specified "root" (default is "root")
> >
> > ...
> >
> > Access denied for user 'root'@'localhost'
>
> What was your expectation here?

Hi Otto,

I expected it to use user olaf here, like the other clients do:

$ mariadb
ERROR 1045 (28000): Access denied for user 'olaf'@'localhost' (using
password: NO)

$ mysql
ERROR 1045 (28000): Access denied for user 'olaf'@'localhost' (using
password: NO)

> Is there an account configured for
> user 'olaf' to access using socket authentication

Normally yes, not in this instance though.

> or is there a my.cnf
> file for user 'olaf'?

> Does "sudo mytop" work, are you able to access using the main database
> user the locally running database?

sudo mytop -h "" works

-- 
Olaf