Koozali.org: home of the SME Server

Contribs.org Forums => Koozali SME Server 10.x => Topic started by: rmoria on August 16, 2021, 12:01:52 PM

Title: Unable to access MySQL
Post by: rmoria on August 16, 2021, 12:01:52 PM

Next problem for me.
I can not access MySQL

I get

Code: [Select]

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
I wanted to reset the password using:

Code: [Select]

cd /var/service/mysqld
sv d .
expand-template /root/.my.cnf
expand-template /var/service/mysqld/set.password
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password
sv u .But /var/service/mysqld does not exist.

Title: Re: Unable to access MySQL
Post by: ReetP on August 16, 2021, 12:16:06 PM

Two points.

First, never, ever, try and manually change your db root password. You will break things which we may not be able to fix.

There are methods in place to do this and to prevent you from making bad mistakes.

https://wiki.koozali.org/MySQL

You should also spend a lot of time in the wiki so you understand that v10 is now systemd controlled.

https://wiki.koozali.org/SME10_serviceControl

Second, please don't keep opening new threads as it confuses things and makes it very difficult to help you.

So stick with this thread and fix one thing at a time instead of jumping everywhere.

https://forums.contribs.org/index.php/topic,54586.0.html