Page 1 of 1

Updated to PHP7, but now phpMyAdmin is borked.. What do? (CentOS 7)

Posted: Thu Jul 06, 2017 10:36 pm
by ohioiproject
Hello and please help!

I have installed PHP7 on my CentOS 7 VPS, however I cannot seem to find a tutorial to help me re-install phpMyAdmin for PHP7. I followed the tutorial here: http://www.servermom.org/upgrade-vestac ... p-7-centos if that helps you know what plugins I have. I also installed ZIP after the install.

I have found many guides that simply say " I went into my public folder and installed it with this command:
git clone --depth=1 --branch=STABLE https://github.com/phpmyadmin/phpmyadmin.git" however I don't know how this would work, which "public folder" they mean, and if it works for PHP7 or not.

Thank you to anyone who can guide me!

Re: Updated to PHP7, but now phpMyAdmin is borked.. What do? (CentOS 7)

Posted: Fri Jul 07, 2017 5:17 am
by plutocrat
I'm running PHPmyadmin under PHP7 without any problems. I'm guessing that you must just be missing some PHP modules.

The first place I'd look is in the error logs of your webserver, and in the PHP error log. You may have to enable PHP errror log depending on your installation. Plenty of help around the internet for doing that.

Another approach would be to see what php modules were installed originally and make sure you have some. You don't mention your OS, but looking at the original installation script, I can see that these are all the PHP related modules you need for PHP 7.
libapache2-mod-php7.0 php7.0 php7.0-common php7.0-cgi php7.0-mysql php7.0-curl php7.0-fpm php7.0-pgsql

On debian/ubuntu I'd make sure these were installed with "apt-get install libapache2-mod-php7.0 php7.0 php7.0-common php7.0-cgi php7.0-mysql php7.0-curl php7.0-fpm php7.0-pgsql"
Centos you'd use yum install.
If this installs additional modules, then you're probably OK. If all modules are already installed, then you have to keep looking.

Re: Updated to PHP7, but now phpMyAdmin is borked.. What do? (CentOS 7)

Posted: Sat Jul 15, 2017 1:42 pm
by ohioiproject
Thanks for the reply @plutocrat, however I simply gave up and just added a new folder with the latest version of phpMA.


Thanks again for offering your insight.

Re: Updated to PHP7, but now phpMyAdmin is borked.. What do? (CentOS 7)

Posted: Sun Jul 23, 2017 7:36 pm
by Pendulum
yea the issue was 80% most likely libapache2-mod-php need the php7 variation for it

Re: Updated to PHP7, but now phpMyAdmin is borked.. What do? (CentOS 7)

Posted: Tue Aug 01, 2017 11:24 am
by xlegends
ohio, consider it a blessing you broke phpmyadmin,
Its just 1 more security risk you dont need..

you can do everything you need with your database from CLI
Im assuming you're using mysql.


CREATE DB
#mysql -u root -p
#CREATE DATABASE dbname;
#GRANT ALL PRIVILEGES ON dbname.* TO dbusername@localhost IDENTIFIED BY 'dbpassword';

BACKUP DB
#cd /choosepath/backup/location
#mysqldump -p -u dbusername database_name > backupname.sql

RESTORE DB
#cd /yourpath/backup/location
#mysql -uroot -p database_name < backupname.sql

REPAIR OPTIONS
#mysqlcheck --auto-repair -r databasename -u root -p
#mysqlcheck --auto-repair -o databasename -u root -p
#mysqlcheck -r --all-databases -u root -p
#mysqlcheck -o --all-databases -u root -p

If you ever need to manually view a table you can always install a phpmyadmin alternative adminer. It easily installs and you can easily uninstall it when you're done.