Question
Cannot Access PHPMyAdmin on a WordPress Droplet with UserDate PhpMyAdmin installation
I’ve created a new WordPress Droplet and used User-Data to install PhpMyAdmin.
When I try to access:
http://107.170.14.110/phpmyadmin
I Receive 401 Unauthorized.
I’ve tried do use MYSQL root user using the password displayed at MOTD
I’ve tried “phpmyadmin” using the password available at /etc/dbconfig-common/phpmyadmin.conf
I’ve tried do use WordPress DB user/pass available at wp-config.php
What Im missing?
I just need to open PHPMyAdmin to restore the full DB from my old blog domain so I can start using DO for my website.
Here’s the 401 error:
https://www.dropbox.com/s/kcocj7lj7h5qjle/Captura%20de%20tela%202015-08-18%2015.28.11.png?dl=0
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.
×
What user data commands did you use to install phpmyadmin?
Hey Ryan! Thanks for your help.
I’ve used this script available at:
https://github.com/digitalocean/do_user_scripts/blob/master/Ubuntu-14.04/web-servers/lamp-phpmyadmin.yml
cloud-config
aptupdate: true
packageupgrade: true
packages:
# Generate random passwords for the MySql root user and the .htaccess file
dd if=/dev/urandom bs=1 count=12 2>/dev/null | base64 -w 0 | rev | cut -b 2- | rev
dd if=/dev/urandom bs=1 count=12 2>/dev/null | base64 -w 0 | rev | cut -b 2- | rev
# Enable the conf and restart Apache.