Public bug reported:
The script "mysql_secure_installation" on a clean install fails:
ERROR 1133 (28000) at line 1: Can't find any matching row in the user
table
If I log into mariadb with root user:
sudo mariadb -u root
and try to run:
SHOW USERS;
I get this:
MariaDB [(none)]> SHOW USERS;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
'USERS' at line 1
ProblemType: Bug
DistroRelease: Ubuntu 22.04
Package: mariadb-server-10.6 1:10.6.16-0ubuntu0.22.04.1
ProcVersionSignature: Ubuntu 5.15.0-97.107-generic 5.15.136
Uname: Linux 5.15.0-97-generic x86_64
ApportVersion: 2.20.11-0ubuntu82.5
Architecture: amd64
CasperMD5CheckResult: unknown
Date: Wed Feb 28 18:53:02 2024
Logs.var.log.daemon.log:
MySQLConf.etc.mysql.mariadb.cnf: Error: [Errno 2] No such file or directory:
'/etc/mysql/mariadb.cnf'
ProcEnviron:
LANGUAGE=en_US:en
TERM=screen-256color
PATH=(custom, no user)
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: mariadb-10.6
UpgradeStatus: Upgraded to jammy on 2023-12-06 (83 days ago)
** Affects: mariadb-10.6 (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug jammy
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/2055320
Title:
root user has problems
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mariadb-10.6/+bug/2055320/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
