Public bug reported:
First note please that while Bionic https://packages.ubuntu.com/bionic-
updates/amd64/mysql-server-5.7/filelist packaged auth_socket.so Focal
does not do so. https://packages.ubuntu.com/focal/amd64/mysql-
server-8.0/filelist
Yet /var/lib/dpkg/info/mysql-server-8.0.postinst tries to install it and
even worse it uses despite it does not exist:
echo "ALTER USER 'root'@'localhost' IDENTIFIED WITH 'auth_socket';"
>> "$initfile"
After every MySQL upgrade I need to restart with --skip-grant-tables and
undo this because it becomes impossible to log in.
Also
for d in $mysql_statedir $mysql_filesdir $mysql_keyringdir $mysql_logdir
$mysql_rundir
do
if [ ! -d "$d" -a ! -L "$d" ]; then mkdir "$d"; fi
chown -R mysql:mysql $d
chmod 0700 $d
done
This makes /var/run/mysqld 0700 which makes it impossible for non-root
users to access MySQL over the socket which is inside /var/run/mysqld
** Affects: mysql-8.0 (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1972046
Title:
mysql-server-8.0.postinst tries to install nonexistent plugin and sets
the wrong permissions
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1972046/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
