Page 1 of 1

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

Posted: Thu Jul 12, 2018 1:27 pm
by 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

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

Posted: Tue Aug 14, 2018 9:31 am
by Bubblecatcher
No ideas?

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

Posted: Mon Oct 15, 2018 2:40 pm
by 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

:)