Hi Faustin, Steps to recreate: 1.Install Mariadb client/server 2. Attempt to run mysql -u root -p 3. fail to be able to login
Note I have the problem corrected, I used Maria-discuss mailing list to get the answer. Steps to fix: run mysql_install_db and then chown -R mysql:mysql /var/lib/mysql to fix the issue and restart MariaDB again. It's working now. I'm unsure why the permissions were wrong from the install, I thought dpkg and the alternatives were supposed to set that "auto-magically". -- Tim McConnell <tmcconnell...@gmail.com> On Tue, 2023-01-10 at 12:51 +0100, Faustin Lammler wrote: > Hi Tim! > Can you explain the steps you followed so I can try to reproduce > this? > > From your logs, it seems that your system tables are missing > (mysql.db) > so it may be a problem with your datadir (normally /var/lib/mysql). > > You may want to recreate those tables, see: > https://mariadb.com/kb/en/installing-system-tables-mysql_install_db/ > > Before touching your datadir, please make sure that you have backups. > > Cheers! >
