FINDING THE phpmyadmin Authentication details .

April 23, 2017 2.2k views
PHP Apache PHP Frameworks Ubuntu
geeber05
By:
geeber05

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

1 comment
Log In to Comment
2 Answers
jtittle1 April 23, 2017
Accepted Answer

@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
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
  • 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.

Have another answer? Share your knowledge.

Related Questions