Im having the same when im trying to run phpmyadmin on the browser.
phpmyadmin 4.7.0 somehow changed a bit
here is my way to fix, copy paste all then press Enter, next press y when asked:
sudo rm -rf /var/www/22222/htdocs/db/pma && \
cd /var/www/22222/htdocs/db/ && \
sudo php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');" && \
sudo php -r "if (hash_file('SHA384', 'composer-setup.php') === '669656bab3166a7aff8a7506b8cb2d1c292f042046c5a994c43155c0be6190fa0355160742ab2e1c88d40d5be660b410') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;" && \
sudo php composer-setup.php && \
sudo php -r "unlink('composer-setup.php');" && \
sudo php composer.phar create-project phpmyadmin/phpmyadmin --repository-url=https://www.phpmyadmin.net/packages.json --no-dev && \
sudo mv phpmyadmin pma && \
sudo chown www-data:www-data -R pma
My way to fix it:
sudo apt-get install composer -y
cd /var/www/22222/htdocs/db/pma
composer
sudo chown www-data: * -R
Actually, perhaps you need a sudo
before composer
.
corrected: composer install
sudo apt-get install composer -y cd /var/www/22222/htdocs/db/pma sudo composer install sudo chown www-data: * -R
thanks guys, i use siprof ways
tq
I keep getting an unable to locate composer package when I try and install. This is the first time in like 20 servers that I have had this issue. EE setup properly, just PMA I cannot access. I prefer not to install lots of extra packages outside of EE if I can avoid it. Did something change in EE that would cause it not to add the composer repos? Ubuntu 14.04 64bit
I recommend Adminer
I also had the same issues.
I tried with above line and it work perfect now.
Thank you so much guys…
thanks!
Installer corrupt Could not open input file: composer-setup.php
i am getting this message please help
Installer corrupt Could not open input file: composer-setup.php i am getting this error after following your procedure please help
Getting this error please help
Your requirements could not be resolved to an installable set of packages.
Problem 1 - Installation request for phpdocumentor/reflection-docblock 4.1.1 -> satisfiable by phpdocumentor/reflection-docblock[4.1.1]. - phpdocumentor/reflection-docblock 4.1.1 requires php ^7.0 -> your PHP version (5.6.32) does not satisfy that requirement. Problem 2 - phpdocumentor/reflection-docblock 4.1.1 requires php ^7.0 -> your PHP version (5.6.32) does not satisfy that requirement. - phpspec/prophecy v1.7.2 requires phpdocumentor/reflection-docblock ^2.0|^3.0.2|^4.0 -> satisfiable by phpdocumentor/reflection-docblock[4.1.1]. - Installation request for phpspec/prophecy v1.7.2 -> satisfiable by phpspec/prophecy[v1.7.2].
Run this
sudo rm -rf /var/www/22222/htdocs/db/pma cd /var/www/22222/htdocs/db sudo apt-get install composer -y git clone https://github.com/phpmyadmin/phpmyadmin.git pma cd pma composer update sudo chown www-data: * -R
after that you need to change the root password of mysql in the config.inc.php in pma folder
check your root password here /etc/mysql/conf.d/my.cnf
This is What I did!
Because I’ve learn after doing the instructions from @siprof It will del the pma folder, even if it errors out. Then when trying to use @portofacil instructions, it will error out because it can’t now find the PMA folder. So do this:
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.
Next. Use @portofacil instructions:
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
sudo apt-get install composer -y
cd /var/www/22222/htdocs/db/pma
sudo composer install
sudo chown www-data: * -R
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!
Hello,
it will probably be better to download composer from official repository, because packages are most of time outdated (1.6.3 from APT repository on Ubuntu 18.04 LTS, when current composer release is 1.7.1).
You can install composer just by running :
curl -sS https://getcomposer.org/installer | php
mv composer.phar /usr/bin/composer
And phpmyadmin can be installed by running :
sudo -u www-data -H composer update -d /var/www/22222/htdocs/db/pma/
But if you have forgotten MySQL root password, you do not need to reset it, MySQL credentials are available in /etc/mysql/conf.d/my.cnf