[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
tmcconnell168 at gmail.com
Tue Jan 10 21:49:20 GMT 2023
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!
>
More information about the pkg-mysql-maint
mailing list