I cant login to phpmyadmin,how to get the mysql password?

May 18, 2017 155 views
PHP MySQL Ubuntu 16.04

I already install the PHPmyadmin one click install.But I cant login to phpmyadmin.cause I dont know where to get this message as state at here https://www.digitalocean.com/community/tutorials/how-to-use-the-phpmyadmin-one-click-application-image

Thank you for using DigitalOcean's LAMP/PHPMyAdmin Application.
Your PHPMyAdmin installation can be accessed at http://0.0.0.0/phpmyadmin
The details of your PHP installation can be seen at http://0.0.0.0/info.php
Your MySQL root user's password is gNv8yafpVZ
You are encouraged to run mysqlsecureinstallation to ready your server for production.

Where to get this message?As state here
"Your new PHPMyAdmin droplet is ready to use as soon as it is launched but you will need to log in once via SSH or by using the web console in order to access your MySQL root password.'

so where is the web console?is it click "Access console" in droplet page?If so,how to access to that message?cause I login and change the password already,but no message coming out.

Any help appreciated,thanks in advanced.

1 Answer

@matchartproduction

You can try running

cat /etc/motd.tail

.. to see if the file exists and contains the password. That's the file noted in the guide which should have been displayed when you logged in to SSH for the first time.

As for the Console, yes -- click on the name of the Droplet, then Access. From there you'll be able to login to the web console using your root password (for the Droplet, not phpMyAdmin).

Have another answer? Share your knowledge.