Page 1 of 1

Cannot Login PhpMyAdmin - New Install

Posted: Mon May 02, 2022 8:13 am
by Vegas10128
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.

Code: Select all

sudo nano /usr/local/vesta/conf/mysql.conf
To retrieve the following password that is generated in the config file.
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'
I have also did the following.

Code: Select all

sudo su

Code: Select all

nano /root/.my.cnf
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!

Re: Cannot Login PhpMyAdmin - New Install

Posted: Tue May 03, 2022 1:50 am
by Vegas10128
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

Code: Select all

sudo nano /etc/mysql/debian.cnf
find user provided under local host.
Should be

Code: Select all

debian-sys-maint
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!