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
-
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 ?
-
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
-
i have tried this and still nothing
-
pls retry 3 times
-
don't input special charater
-
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 ?
-
any help the problem has became urgent ?
-
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;
-
now i am getting this as error
-bash: syntax error near unexpected token `newline'
-
i think this is php source ussu,
pls check your source
-
can you fix the problem to me i am willing to pay for server support
-
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"