(HY000/1045): Access denied for user 'phpmyadmin'

[Bubblecatcher]

Hi, needed to reset database root password.

Have checked /usr/local/vesta/conf/mysql.conf and the correct password is there.

Can create a new database fine in vestacp, but when loading myphpadmin i see error messages

Code: Select all

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
Or alternately go to 'Operations' tab of any database to set it up there.
Open new phpMyAdmin window
mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
Connection for controluser as defined in your configuration failed.
mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
Connection for controluser as defined in your configuration failed.

Any clues where to look?

thanks

[Bubblecatcher]

No ideas?

[Bubblecatcher]

Hi, i had this and other phpmyadmin issues after install and eventually found this cleared them:


run
mysql_secure_installation

ensure all files are using correct password
/root/.my.cnf
/usr/local/vesta/conf/mysql.conf

remove mysql root password (dpkg-reconfigure -plow phpmyadmin fails with root pw error)
mysql -uroot -p
SET PASSWORD FOR root@localhost=PASSWORD('');
quit

reconfigure phpmyadmin
dpkg-reconfigure -plow phpmyadmin

rerun
mysql_secure_installation

log into phpmyadmin with no errors

:)

[clu55ter]

I have this issue but when I run the mysql_secure_installation comand I get Error: MySQL server has gone aways

Any ideas?
Thanks

[clu55ter]

Thank you for the guide but any ideas on where to find the root password for mysql?
I have tried both my vestacp admin password and the password that's located in /root/my.cnf but am getting Access denied for the root user on both occasions.

Any help would be appreciated.

Thanks