Topic: Unable to access MySQL

[rmoria]

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.

[ReetP]

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