Fresh install gives phpMyAdmin error

Fresh install gives phpMyAdmin error - Printable Version

+- Sentora Support Forums (https://senforums.mach-hosting.com)
+-- Forum: Sentora Forum Archives (https://senforums.mach-hosting.com/forumdisplay.php?fid=5)
+--- Forum: Sentora Public Support Forums v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=32)
+---- Forum: General Support Forum v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=36)
+---- Thread: Fresh install gives phpMyAdmin error (/showthread.php?tid=107)

Fresh install gives phpMyAdmin error - Ron-e - 08-10-2014

I am testing around with Sentora on a VPS of mine.
But i got an phpMyAdmin error after an fresh install, i needed to upgrade to MySQL 5.5.0 or later.
Sentora is using 5.1.73..
[Image: s7HrvUB.png]

RE: Fresh install gives phpMyAdmin error - Jason.Kenyon - 08-11-2014

(08-10-2014, 07:26 PM)Ron-e Wrote: I am testing around with Sentora on a VPS of mine.
But i got an phpMyAdmin error after an fresh install, i needed to upgrade to MySQL 5.5.0 or later.
Sentora is using 5.1.73..

The script should only install the versions, and packages that your linux has. But below is a work around.

What OS are you running, Cent or Ubuntu?

If you are running CentOS you can install the new mysql using the replace.

Code:
sudo service mysqld stop

# install repo webtatic

yum -y install http://mirror.webtatic.com/yum/el6/latest.rpm

# install yum-replace

yum -y install yum-plugin-replace

# update MySQL

yum -y replace mysql --replace-with=mysql55

sudo service mysqld start

Steps taken from @andykimpe, from the old ZpanelCP forums

RE: Fresh install gives phpMyAdmin error - DiscoWay - 08-12-2014

(The other option is to downgrade phpMyAdmin)

Perform the following to downgrade:

Change directories to phpMyAdmin directory

Code:
cd /etc/zpanel/panel/etc/apps

Move current to old directory

Code:
mv phpmyadmin phpmyadmin_old

Download phpMyAdmin from the following location (could be newer versions, check on main site):

Code:
wget http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/4.0.10.1/phpMyAdmin-4.0.10.1-all-languages.tar.gz/download

Extract the package

Code:
tar -zxvf phpMyAdmin-*.tar.gz

Clean up

Code:
rm phpMyAdmin-*.tar.gz

Move extracted phpMyAdmin folder to its correct directory

Code:
mv phpMyAdmin-*/ /etc/zpanel/panel/etc/apps/phpmyadmin

Change permissions on directory and all subfolders and files

Code:
chmod 777 -R phpmyadmin/

Change ownership on directory and all subfolders and files

Code:
chown root:root -R phpmyadmin/

Copy phpMyAdmin config from old to new

Code:
cp phpmyadmin_old/config.inc.php phpmyadmin/config.inc.php

Clean up

Code:
rm -Rf phpmyadmin_old

Source: http://forums.zpanelcp.com/Thread-HOW-TO-Update-PHPMyadmin

This worked for me

-DiscoWay

RE: Fresh install gives phpMyAdmin error - jacobg830 - 08-12-2014

^ Always make sure you remove the setup folder as well.

Code:
rm -Rf phpmyadmin/setup

RE: Fresh install gives phpMyAdmin error - kandrews - 08-12-2014

I'm supprised phpmyadmin requires a mysql version of 5.5 ... centos is using a stable securely backported version of mysql. I personally would be looking to make phpmyadmin work on the distro version of mysql rather than relying on external repos..

Alternatively look at installing MariaDB as a drop in replacement Smile

This needs raising as a bug on the installers repo over on github ...

RE: Fresh install gives phpMyAdmin error - long1261 - 08-15-2014

If you do not want to upgrade your MySql install or downgrade your phpMyAdmin you can alternately just modify the common.inc.php file so phpMyAdmin will stop complaining.

In CentOS 6 go to:
/etc/zpanel/panel/etc/apps/phpmyadmin/libraries/common.inc.php

If you open this up, there is a line:

Line 994

Code:
if (PMA_MYSQL_INT_VERSION < 50500) {

Change it to say:

Code:
if (PMA_MYSQL_INT_VERSION < 50100) {

Now you can use phpMyAdmin without it complaining. Smile

RE: Fresh install gives phpMyAdmin error - ballen - 08-20-2014

Check out the latest merged changes, this has been resolved for the meantime!

RE: Fresh install gives phpMyAdmin error - Diablo925 - 08-20-2014

hmm :/

RE: Fresh install gives phpMyAdmin error - saharmohamedali - 07-03-2015

(08-12-2014, 06:14 PM)jacobg830 Wrote: ^ Always make sure you remove the setup folder as well.

Code:
rm -Rf phpmyadmin/setup