MRatWork Forum by Mustafa Ramadhan

Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: nemo1112 on 2020-11-24, 14:38:38

Title: mysql connection
Post by: nemo1112 on 2020-11-24, 14:38:38
i have a problem connecting to mysql
everytime i get this error

Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

this happens alot
right now i can't enter using root

any help ?
Title: Re: mysql connection
Post by: atljohnsen on 2020-11-28, 14:00:55
Have you tried to reset mysql password?

if not, you can try it from SSH with:

sh /script/reset-mysql-root-password <newpassword>

Then

sh /script/restart-mysql

Title: Re: mysql connection
Post by: nemo1112 on 2020-11-29, 14:46:02
i have tried this and still nothing
Title: Re: mysql connection
Post by: azzureal on 2020-11-30, 04:24:10
pls retry 3 times
Title: Re: mysql connection
Post by: azzureal on 2020-11-30, 04:24:34
don't input special charater
Title: Re: mysql connection
Post by: nemo1112 on 2020-12-07, 12:27:54
still nothing
i have tried the user of each database and it worked but the root still not working
emails is on root so it's not working

any idea ?
Title: Re: mysql connection
Post by: nemo1112 on 2020-12-27, 23:04:26
any help the problem has became urgent ?
Title: Re: mysql connection
Post by: azzureal on 2021-01-04, 04:41:59
pls it by manual.

service mysql stop
mysqld_safe --skip-grant-tables &
mysql
UPDATE mysql.user SET Password=PASSWORD('new-password') WHERE User='root';
FLUSH PRIVILEGES;
exit;
Title: Re: mysql connection
Post by: nemo1112 on 2021-01-26, 14:14:02
now i am getting this as error

-bash: syntax error near unexpected token `newline'


Title: Re: mysql connection
Post by: azzureal on 2021-01-28, 11:35:26
i think this is php source ussu,

pls check your source
Title: Re: mysql connection
Post by: nemo1112 on 2021-01-28, 12:51:24
can you fix the problem to me i am willing to pay for server support
Title: Re: mysql connection
Post by: azzureal on 2021-02-04, 08:52:04
service mysqld stop
service mysql stop

mysqld_safe --skip-grant-tables &

mysql

PDATE mysql.user SET Password=PASSWORD('new-password') WHERE User='root';

FLUSH PRIVILEGES;
exit;

service mysqld start

vi /root/.my.cnf

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