Issue of server charset causes phpMyAdmin to show a notice of “Undefined offset”

[ianthedev]

Describe the bug

There is a Notice of "Undefined offset" every time I open phpMyadmin.

To Reproduce

Steps to reproduce the behavior:

1. open phpMyadmin

Expected behavior

There should be no Notice.

Screenshots

Link to a Stack Overflow question with a screenshot.

Server configuration

• Operating system: Windows 7
• Web server: EasyPHP Devserver 17
• Database version: 5.7.17
• PHP version: 7.4.0RC4
• phpMyAdmin version: 4.9.1

Client configuration

• Browser: Firefox 70
• Operating system: Windows 7

[williamdes]

@ianthedev And if you browse the "Variables" page, can you send a screenshot filtering on "charset" ?

[williamdes]

introduced by 8b7db3b

[ianthedev]

@ianthedev And if you browse the "Variables" page, can you send a screenshot filtering on "charset" ?

It says "Not enough privilege to view server variables and settings." as shown in the screenshot below:

[williamdes]

@ianthedev can you send SHOW GRANTS; ?
I can not reproduce your issue, how did you do to have information_schema disabled/access denied ?

[ianthedev]

@ianthedev can you send SHOW GRANTS; ?
I can not reproduce your issue, how did you do to have information_schema disabled/access denied ?

Here is the screenshot of SHOW GRANTS;

But I failed to understand your second question.

[williamdes]

Trying to reproduce the issue using #11442 and #11446

[williamdes]

reproduced using MySQL 5.7.8 🎉