mysqli::real_connect(): (HY000/2006): MySQL server has gone away

[azizramdan]

Description:

I use mariadb but when login to phpmyadmin get error

• Packets out of order. Expected 0 received 1. Packet size=69
• mysqli::real_connect(): Error while reading greeting packet. PID=41
• mysqli::real_connect(): (HY000/2006): MySQL server has gone away

Expected Behavior:

Logged in to phpmyadmin

Context information:

Output of git rev-parse HEAD

6a92eb0d589c66ef1ccd8945de1d07a6e35861e1

Output of docker version

Docker version 19.03.6, build 369ce74a3c

Output of docker-compose version

docker-compose version 1.25.4, build 8d51620a

System info: Mac, Windows or Linux. Include which disto/version

MX Linux 19.1 x86_64
Kernel: 4.19.0-6-amd64
MARIADB_VERSION=latest (10.4.12-MariaDB-1:10.4.12+maria~bionic)

Steps to reproduce the issue:

1. change .env PMA_DB_ENGINE=mariadb
2. docker-compose up -d nginx mariadb phpmyadmin workspace

Stacktrace & Additional info:

$ docker-compose up mariadb
Starting laradock_mariadb_1 ... done
Attaching to laradock_mariadb_1
mariadb_1              | 2020-02-23 09:15:48+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.4.12+maria~bionic started.
mariadb_1              | 2020-02-23 09:15:48+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
mariadb_1              | 2020-02-23 09:15:48+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.4.12+maria~bionic started.
mariadb_1              | 2020-02-23  9:15:49 0 [Note] mysqld (mysqld 10.4.12-MariaDB-1:10.4.12+maria~bionic) starting as process 1 ...
mariadb_1              | 2020-02-23  9:15:49 0 [Note] InnoDB: Using Linux native AIO
mariadb_1              | 2020-02-23  9:15:49 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
mariadb_1              | 2020-02-23  9:15:49 0 [Note] InnoDB: Uses event mutexes
mariadb_1              | 2020-02-23  9:15:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
mariadb_1              | 2020-02-23  9:15:49 0 [Note] InnoDB: Number of pools: 1
mariadb_1              | 2020-02-23  9:15:49 0 [Note] InnoDB: Using SSE2 crc32 instructions
mariadb_1              | 2020-02-23  9:15:49 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
mariadb_1              | 2020-02-23  9:15:49 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
mariadb_1              | 2020-02-23  9:15:49 0 [Note] InnoDB: Completed initialization of buffer pool
mariadb_1              | 2020-02-23  9:15:49 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
mariadb_1              | 2020-02-23  9:15:49 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
mariadb_1              | 2020-02-23  9:15:49 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mariadb_1              | 2020-02-23  9:15:49 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
mariadb_1              | 2020-02-23  9:15:49 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
mariadb_1              | 2020-02-23  9:15:49 0 [Note] InnoDB: Waiting for purge to start
mariadb_1              | 2020-02-23  9:15:49 0 [Note] InnoDB: 10.4.12 started; log sequence number 62494; transaction id 21
mariadb_1              | 2020-02-23  9:15:49 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mariadb_1              | 2020-02-23  9:15:49 0 [Note] Plugin 'FEEDBACK' is disabled.
mariadb_1              | 2020-02-23  9:15:49 0 [Note] Server socket created on IP: '::'.
mariadb_1              | 2020-02-23  9:15:49 0 [Warning] 'user' entry 'root@015fbb62d38b' ignored in --skip-name-resolve mode.
mariadb_1              | 2020-02-23  9:15:49 0 [Warning] 'user' entry '@015fbb62d38b' ignored in --skip-name-resolve mode.
mariadb_1              | 2020-02-23  9:15:49 0 [Warning] 'proxies_priv' entry '@% root@015fbb62d38b' ignored in --skip-name-resolve mode.
mariadb_1              | 2020-02-23  9:15:49 0 [Note] InnoDB: Buffer pool(s) load completed at 200223  9:15:49
mariadb_1              | 2020-02-23  9:15:49 0 [Note] Reading of all Master_info entries succeeded
mariadb_1              | 2020-02-23  9:15:49 0 [Note] Added new Master_info '' to hash table
mariadb_1              | 2020-02-23  9:15:49 0 [Note] mysqld: ready for connections.
mariadb_1              | Version: '10.4.12-MariaDB-1:10.4.12+maria~bionic'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution

[stale]

Hi 👋 this issue has been automatically marked as stale 📌 because it has not had recent activity 😴. It will be closed if no further activity occurs. Thank you for your contributions ❤️.

[stale]

Hi again 👋 we would like to inform you that this issue has been automatically closed 🔒 because it had not recent activity during the stale period. We really really appreciate your contributions, and looking forward for more in the future 🎈.

[CheaChhunleang]

how long that stale period take time.