Install phpmyadmin can't login

after install via phpmyadmin.sh

I have phpMyAdmin

https://31.31.79.20/9524_mysqladmin14681/

after htaccess login i try use user root and password, but i get " Cannot log in to the MySQL server "

I was trying uninstall, reload php, install again, change root passwd, reboot server but nothing help.

---

Thank you for any advice

 

Yes, and now is working and I have access.

example ssh user "root" password "pass123"
mysql user " root" password "word321"

And now is working to do that:

Stop MySQL

Code:

sudo /etc/init.d/mysqld stop

Safe mode

Code:

sudo mysqld_safe --skip-grant-tables &

Login

Code:

mysql -uroot

Code:

use mysql;

Reset Password

Code:

update user set password=PASSWORD("password") where User='root';

Code:

flush privileges;

Restart

Code:

quit

Code:

sudo /etc/init.d/mysqld stop
sudo /etc/init.d/mysql start

I now is working (i must reboot whole server not just service)