(HY000/1045): Access denied for user 'phpmyadmin'
-
- Posts: 37
- Joined: Tue Mar 06, 2018 8:38 am
- Os: Debian 8x
- Web: apache
(HY000/1045): Access denied for user 'phpmyadmin'
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
Any clues where to look?
thanks
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
-
- Posts: 37
- Joined: Tue Mar 06, 2018 8:38 am
- Os: Debian 8x
- Web: apache
-
- Posts: 37
- Joined: Tue Mar 06, 2018 8:38 am
- Os: Debian 8x
- Web: apache
Re: (HY000/1045): Access denied for user 'phpmyadmin'
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
:)
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
:)
Re: (HY000/1045): Access denied for user 'phpmyadmin'
I have this issue but when I run the mysql_secure_installation comand I get Error: MySQL server has gone aways
Any ideas?
Thanks
Any ideas?
Thanks
Re: (HY000/1045): Access denied for user 'phpmyadmin'
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
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