[debian-mysql] Bug#1025784: Bug#1025784: Acknowledgement (mariadb-server-core-10.6: Can't connect to local server through socket '/run/mysqld/mysqld.sock' (111))

[Tim McConnell]

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 <tmcconnell168 at 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!
>