We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Cannot Login PhpMyAdmin - New Install
-
- Posts: 38
- Joined: Tue Aug 16, 2016 4:58 pm
Cannot Login PhpMyAdmin - New Install
Hello members!
I have created 2 new installations using Ubuntu 18.04
Both are brand new installations and
I cannot log into PhpMyAdmin.
I nano into the following file and directory.
To retrieve the following password that is generated in the config file.
PhpMyAdmin rejects the request and throws message
I have also did the following.
compared and verified the password is the same in this file as well.
I never had such problems with fresh installs and instant login to PhpMyAdmin.
However this time after attempting to spin up 2 different vesta servers and needing access to PhpMyAdmin it is now a different story.
What is the point of either 2 files if they do not abide by their configured rules?
is there another file i should look into for password authentication?
Any help I will thank you a lot!
I have created 2 new installations using Ubuntu 18.04
Both are brand new installations and
I cannot log into PhpMyAdmin.
I nano into the following file and directory.
Code: Select all
sudo nano /usr/local/vesta/conf/mysql.conf
PhpMyAdmin rejects the request and throws message
Code: Select all
#1698 - Access denied for user 'root'@'localhost'
Code: Select all
mysqli_real_connect():(HY000/1698):Access denied for user 'root'@'localhost'
Code: Select all
sudo su
Code: Select all
nano /root/.my.cnf
I never had such problems with fresh installs and instant login to PhpMyAdmin.
However this time after attempting to spin up 2 different vesta servers and needing access to PhpMyAdmin it is now a different story.
What is the point of either 2 files if they do not abide by their configured rules?
is there another file i should look into for password authentication?
Any help I will thank you a lot!
-
- Posts: 38
- Joined: Tue Aug 16, 2016 4:58 pm
Re: Cannot Login PhpMyAdmin - New Install
I found the solution!!!!
After digging around the file directories looking for password related solutions I came across the following file.
debian.cnf
Steps for solution to accessing PhpMyAdmin.
Log into server ssh as regular user.
then
find user provided under local host.
Should be
with hyphens included.
copy the following password underneath user, as it is randomly generated.
Paste both user and password in phpmyadmin login page and will give you access.
Hope this helps everyone in the future!
After digging around the file directories looking for password related solutions I came across the following file.
debian.cnf
Steps for solution to accessing PhpMyAdmin.
Log into server ssh as regular user.
then
Code: Select all
sudo nano /etc/mysql/debian.cnf
Should be
Code: Select all
debian-sys-maint
copy the following password underneath user, as it is randomly generated.
Paste both user and password in phpmyadmin login page and will give you access.
Hope this helps everyone in the future!