On Tue, May 03, 2022 at 10:14:55AM +0200, Lucio Crusca wrote: > Il 03/05/22 09:47, tomas@tuxteam.de ha scritto: > > Any chance you could try to run a command line as above and see > > whether the daemon likes to start? > > # /usr/sbin/mariadbd --basedir=/usr --datadir=/var/lib/mysql > --plugin-dir=/usr/lib/mysql/plugin --user=mysql --skip-log-error > --pid-file=/run/mysqld/mysqld.pid --socket=/run/mysqld/mysqld.sock [...] > 2022-05-03 10:12:21 0 [ERROR] Could not open mysql.plugin table: "Table > 'mysql.plugin' doesn't exist". Some plugins may be not loaded [...] > 2022-05-03 10:12:21 0 [ERROR] Can't open and lock privilege tables: Table > 'mysql.servers' doesn't exist [...] > 2022-05-03 10:12:21 0 [ERROR] Fatal error: Can't open and lock privilege > tables: Table 'mysql.db' doesn't exist > I'm afraid it does not, at least it does not give me anything, since it > shows the same error messages as before. ...but at least those seem clearer now to my slow brain :) The way I interpret this is that mysql isn't finding some tables it expects at start (possibly parts of the metaschema). I'd expect those to come along with a new installation. Perhaps something went astray during your last attempt. Perhaps uninstalling your mariadb server and re-installing it seems the best way forward (I think to remember you said you had no valuable data). Try `sudo apt purge mariadb-server', watch out for error messages, then re-install. Perhaps that helps. Cheers -- tomás
Attachment:
signature.asc
Description: PGP signature