Phpmyadmin to work for php 5.6 and 7.2 both on Ubuntu 20.04

Vishal Verma

1/12/23, 8:03 AM

I am working on Ubuntu 20.04 and have multiple PHP versions installed (5.6 - 8.0) because I need to work on Magento 1 & 2 both. When I switch to 7.2 and open PHPMyAdmin in the URL, it works fine.

But when I try to switch to PHP 5.6 and refresh PHPMyAdmin page in URL, it goes blank. I tried with some of the solutions (as attached) but not working.

# Copyright (c) 2016, 2021, Oracle and/or its affiliates.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License, version 2.0,
# as published by the Free Software Foundation.
#
# This program is also distributed with certain software (including
# but not limited to OpenSSL) that is licensed under separate terms,
# as designated in a particular file or component or in included license
# documentation.  The authors of MySQL hereby grant you an additional
# permission to link the program and your derivative works with the
# separately licensed software that they have included with MySQL.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License, version 2.0, for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301 USA

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
collation-server = utf8_unicode_ci
character-set-server = utf8
default-authentication-plugin=mysql_native_password

my.cnf changes

mysql> 
mysql> use mysql;
Database changed
mysql> 
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root@123';

mysql changes

Then I restarted MySql and Apache2 both. Can you please help me in this regard?

Thanks in advance.

367

0 + 0

php

phpmyadmin

php7

magento

matigo

1/12/23, 8:05 AM

Asking ASAP is a tall order for volunteers. That said, are there any error logs you can look at? They will clearly state why phpMyAdmin isn’t happy with 5.6

Vishal Verma

1/12/23, 8:38 AM

yes @matigo, I see there as below cat error.log PHP Warning: Unsupported declare 'strict_types' in /usr/share/php/PhpMyAdmin/MoTranslator/Loader.php on line 23 PHP Parse error: syntax error, unexpected '?' in /usr/share/php/PhpMyAdmin/MoTranslator/Loader.php on line 116

matigo

1/12/23, 10:00 AM

Hmm … `strict_types` was added in PHP 7.0.0, which would be why phpMyAdmin is reporting an error when the PHP version is changed to 5.6

Vishal Verma

1/13/23, 5:59 AM

Yes, I believe so .. strict_types and "??" operator creating prob coz those are not supported in PHP 5.6 so may be need to install phpmyadmin first for php 5.6 and then to try for PHP 7+

matigo

1/13/23, 6:27 AM

You could do that. However, depending on what you need from a MySQL client, you may want to consider using a tool such as [Beekeeper](https://www.beekeeperstudio.io). It can be found in the Software Store and is a rock-solid SQL editor. This will eliminate the need to work with phpMyAdmin altogether

Vishal Verma

1/13/23, 7:37 AM

Thanks for your suggestion @matigo. Will definitely try that

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Phpmyadmin to work for php 5.6 and 7.2 both on Ubuntu 20.04

TH: phpmyadmin เพื่อทำงานกับ php 5.6 และ 7.2 ทั้งบน Ubuntu 20.04

RO: Phpmyadmin să funcționeze pentru php 5.6 și 7.2 ambele pe Ubuntu 20.04

RU: Phpmyadmin для работы с php 5.6 и 7.2 на Ubuntu 20.04

VI: Phpmyadmin hoạt động cho cả php 5.6 và 7.2 trên Ubuntu 20.04

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.