MRatWork Forum by Mustafa Ramadhan

Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: EndErr on 2019-11-19, 06:53:01

Title: Access denied for user 'root'@'localhost' (using password: YES)
Post by: EndErr on 2019-11-19, 06:53:01

Some strange things happened few hours ago.
I do can connect to mysql from console "mysql -u root -p" but when I do "sh /script/cleanup" I get following errors:

Code: [Select]

...
Update Kloxo database
- Update process
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
...
- Fix mail-all services
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
...
When I try "sh /script/reset-mysql-root-password <SomeNewPassword>" I get

Code: [Select]

Stop MySQL service...
MySQL ROOT password reset...
Start MySQL service...
191119 03:49:37 mysqld_safe A mysqld process already exists

I also tried to change password using that post https://forum.mratwork.com/kloxo-mr-releases-and-announcements/(tip)-reset-password/ (https://forum.mratwork.com/kloxo-mr-releases-and-announcements/(tip)-reset-password/) but still same errors.

That error "Access denied for user 'root'@'localhost'" I also receive when I  do "sh /script/fixmail-all" and "sh /script/fixvpop" and some actions from the panel.

How to fix that?

Title: Re: Access denied for user 'root'@'localhost' (using password: YES)
Post by: azzureal on 2019-11-25, 02:51:42

vi /root/.my.cnf

[client]
user="root"
pass="password"