Problem with new user phpmyadmin login

I installed Hestia for the first time yesterday and was able to add a new user with phpmyadmin access by using the following command as it was giving an error before that:
chown -R root:www-data /etc/phpmyadmin/

The problem I am experiencing now is that when I create a new user the usename/password is not accepted by phpmyadmin. Also when I check the database users via the terminal the new user is not showing.

I created a new user at the terminal and gave it all privileges and that worked ok and the user can now login to phpmyadmin ok, but how can I create a new user in Hestia that can access phpmyadmin without me needing to open the terminal?

Hestia doesn’t create a new db user when you add a new user, the db users are created when you add a DB. Also, the db user is in the form user_dbuser, I mean, if you create a new Hestia user like soulyears, when you create a DB under that user, you must specify the db user, like test so, in the end, the db user for that new db will be soulyears_test

I did try earlier today creating a database and then trying to log in to phpmyadmin but the username/password was not accepted. Just a moment ago I tried the same thing and when I try to to access phpmyadmin now i get:

PHP 7.2.5+ is required.

Currently installed version is: 5.6.40-78+0~20240802.86+debian12~1.gbp864daf

Can I downgrade the phpmyadmin version to one that works with PHP 5.6 using Hestia commands do you know?

Don’t do that.

Just install a modern php version and use it, you can assign the php version 5.6 to the sites that must use it and you will avoid a lot of problems…

1 Like

Actually there is only one app that I want to run on this new VPS. It is a rather large app (150gb+) and has been running on a VPS from the same provider since 2016. The OS is Centos and as they no longer support Centos they are now charging me more than double the cost of this new VPS I just purchased from them. I don’t care about downgrading the present php version much as I will only be running this one app on the VPS anyway most likely. From what I can tell I need PHP version 4.9 to be installed.

Do you think it will be an easy matter for me to get version 4.9 running alongside the present modern phpmyadmin version?

I just thought of a simpler solution. I created a subdomain to run the app on with php version 5.6 and then set the parent domain back to version 8.2, so I can just access phpmyadmin from it without needing to access phpmyadmin from the subdomain.