Question

FINDING THE phpmyadmin Authentication details .

Posted April 23, 2017 2.8k views
Ubuntu Apache PHP PHP Frameworks

I installed the phpmyadmin with this
https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-14-04
now whenever i am going to this login to my phpmyadmin
there authentication enabled with https://everythingisaffordable.com:22222/db/pma
and i tried everything to login with login passwords that i setup .. but nothing works..
Please help to find the login details for the htaccess authentication.
Thanks in advance

Add a comment
geeber05
By:
geeber05
Add a comment
1 comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

2 answers
jtittle1 April 23, 2017

@geeber05

On newer versions of Ubuntu, you shouldn’t need to use php5enmod as the package manager, apt, will handle enabling PHP modules. So if you receive an error when trying to run that command, that shouldn’t be a cause for concern.

When you ran this command:

htpasswd -c /etc/phpmyadmin/.htpasswd username

You should have been prompted to enter a password and confirm said password for each user that you create. For example, if I wanted to add geeber as a user, I’d run:

htpasswd -c /etc/phpmyadmin/.htpasswd geeber

… then enter a password and confirm the password.

Once that’s done, when visiting the URL you provided, I’d use geeber as the username as well as the password I setup when running the above command.

Once you’re past that authentication prompt, the credentials you’d use for phpMyAdmin depend on what you setup when creating your databases. You can also use root and the root password for MySQL.

Reply Report
geeber05 April 23, 2017

I tried that not works for me .. so now i have rebuild the droplet .
Could you please tell me the best way to install the phpmyadmin

Reply Report
  • jtittle1 April 23, 2017

    @geeber05

    That guide should work. I generally, however, recommend installing it manually instead of via the package manager (i.e. download the files, run the installer, etc) if you need phpMyAdmin as I find it to be more reliable.

    That being said, I’ve about dropped usage of phpMyAdmin in favor of Adminer because it’s a single file (instead of hundreds), works the same, and when I need it, I upload that file – when I don’t, I delete the file. No need for password protection, maintaining the large file base and the updates that go with it, etc.

    https://www.adminer.org/

    I manage a number of WordPress sites in production and in development as well as quite a few web servers. They take up a lot of my time, so when I can reduce the need to rely on a larger code base and the solution works, I aim to use it instead. Adminer fits that need perfectly and when it doesn’t, I use the CLI.

    I’d recommend giving it a shot. You can download the file here:

    https://github.com/vrana/adminer/releases/download/v4.3.1/adminer-4.3.1.php

    Simply upload that your your web root (i.e. where your index.php file is), rename it to something else (i.e. such as dba.php, dbmin.php, etc) and access it. When you’re done, delete it. There’s no need to install anything, it just works as long as you provide the right database credentials when trying to login.

    Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help