Question

3

phpMyAdmin is not working in ubuntu 20.04 with php5.6

rated 0 times [ 3] [ 0] / answers: 1 / hits: 12104 / 3 Years ago, sat, june 5, 2021, 5:39:15

Issue - HTTP ERROR 500 for phpMyAdmin.

Apache error log

[Wed Aug 19 02:52:11.063688 2020] [:error] [pid 94653] [client ::1:56202] PHP Warning:  Unsupported declare 'strict_types' in /usr/share/php/PhpMyAdmin/MoTranslator/Loader.php on line 23

[Wed Aug 19 02:52:11.063864 2020] [:error] [pid 94653] [client ::1:56202] PHP Parse error:  syntax error, unexpected '?' in /usr/share/php/PhpMyAdmin/MoTranslator/Loader.php on line 116

phpMyAdmin is completely working fine when switched to php7.4. This issue happens only on php5.6

Setup - Ubuntu 20.04, php5.6, Apache/2.4.41, phpMyAdmin-4.9.5deb2, mysql-8.0.21
php -m (output)

[PHP Modules]

calendar

Core

ctype

curl

date

dom

ereg

exif

fileinfo

filter

ftp

gd

gettext

hash

iconv

imagick

json

libxml

mbstring

mcrypt

mhash

mysql

mysqli

mysqlnd

openssl

pcntl

pcre

PDO

pdo_mysql

Phar

posix

readline

Reflection

session

shmop

SimpleXML

sockets

SPL

standard

sysvmsg

sysvsem

sysvshm

tokenizer

wddx

xml

xmlreader

xmlwriter

xsl

Zend OPcache

zlib



[Zend Modules]

Zend OPcache

I have removed the phpmyadmin from the distro and installed in through zip. And i am getting the following error.

mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]

mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client

I found the issue is that is with authentication method and changed the "caching_sha2_password" to "mysql_native_password" but still i am getting the above error.

mysql> SELECT user,authentication_string,plugin,host FROM mysql.user;

+------------------+------------------------------------------------------------------------+-----------------------+-----------+

| user             | authentication_string                                                  | plugin                | host      |

+------------------+------------------------------------------------------------------------+-----------------------+-----------+

| debian-sys-maint | $A$005$@0IC@&1C

                                    O:Xf94qofd9PGZM4cSAB0xP0ZsNz7GUaX8UuPiAYIj5M0 | caching_sha2_password | localhost |

| mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password | localhost |

| mysql.session    | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password | localhost |

| mysql.sys        | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password | localhost |

| phpmyadmin       | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19                              | mysql_native_password | localhost |

| root             | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19                              | mysql_native_password | localhost |

| surendhar        | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19                              | mysql_native_password | localhost |

+------------------+------------------------------------------------------------------------+-----------------------+-----------+

7 rows in set (0.00 sec)

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

anatta

Add To Favorites

Follow

Total Points: 326

Total Questions: 128

Total Answers: 96

Location: Jordan

Member since Sun, Jun 26, 2022

2 Years ago

anatta questions

1 Wlan0 will not connect to WiFi?

Sun, Jul 17, 22, 07:13, 2 Years ago

1 Hostnames cannot be resolved after upgrading to 22.04

Sun, Jun 6, 21, 12:17, 3 Years ago

1 Using Steam's Proton to run Roblox

Sat, Jun 12, 21, 20:43, 3 Years ago

1 Add "My App" to Context Menu in Ubuntu

Thu, Jan 13, 22, 20:49, 2 Years ago

1 Troubles with libpng12.so.0 - no version information available?

Tue, Jan 25, 22, 06:51, 2 Years ago

View All

answered 3 Years ago lawain · Accepted Answer

The issue - ubuntu 20.04 uses mysql v8 with uses caching_sha2_password. Everything works fine php7.4. But when you use php5.6 you get two errors

Server sent charset unknown to the client

The server requested authentication method unknown to the client

To fix this issue we need to add below code to the /etc/mysql/my.cnf

[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

You also need to update the user authentication method by the following code in mysql

alter user 'username'@'localhost' identified with mysql_native_password by 'password';