Full Instructions to get PHPMyAdmin Working
Make sure PhpMyAdmin is installed. If using EasyEngine the command would be:
ee stack install --phpmyadmin
This would install PhpmyAdmin into your: /var/www/22222/htdocs/db/pma directory.
Paste line by line:
sudo apt-get install composer -y
cd /var/www/22222/htdocs/db/pma
sudo composer install
sudo chown www-data: * -R
So you want to goto IP followed by the “:” and “/db/pma”. (example: 10.10.10.10:22222/db/pma/)
Do not use Chrome, use Safari and skip and by pass the https security process.
Use EE http user/pass for the popup. If you have forgotten it, run the command to change:
ee secure —auth
Once you get to PhpMyAdmin Login page. You can log into with your root credentials. If you have forgotten it, reset by using the following commands. Make sure to go line by line:
Stop the MySQL server:
service mysql stop
Restart the MySQL server with the —skip-grant-tables option. To do this, type the following command:
mysqld_safe --skip-grant-tables &
Log into MySQL using the following command:
mysql
At the mysql> prompt, reset the password. To do this, type the following command, replacing NEW-PASSWORD-HERE with the new root password:
UPDATE mysql.user SET Password=PASSWORD('NEW-PASSWORD-HERE’) WHERE User='root';
At the mysql> prompt, type the following commands:
FLUSH PRIVILEGES;
exit;
Stop the MySQL server using the following command. You will be prompted to enter the new MySQL root password before the MySQL server shuts down:
mysqladmin -u root -p shutdown
Start the MySQL server normally.
service mysql start
OK, you should now have evrything you need to access PHPMyAdmin!