mysql connection

[nemo1112]

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 ?

[atljohnsen]

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

[nemo1112]

i have tried this and still nothing

[azzureal]

pls retry 3 times

[azzureal]

don't input special charater

[nemo1112]

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 ?

[nemo1112]

any help the problem has became urgent ?

[azzureal]

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;

[nemo1112]

now i am getting this as error

-bash: syntax error near unexpected token `newline'

[azzureal]

i think this is php source ussu,

pls check your source

[nemo1112]

can you fix the problem to me i am willing to pay for server support

[azzureal]

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"