Bash syntax error in run-mysqld while starting MySQL container

[fcarrus]

A weird syntax error pops up while starting a MySQL container:

Version: '5.7.21'  socket: '/tmp/mysql.sock'  port: 0  MySQL Community Server (GPL)
---> 13:17:49     MySQL started successfully
/usr/bin/run-mysqld: line 24: [: missing `]'
=> sourcing 40-datadir-action.sh ...

Line 24 in run-mysqld says:

if [ -z "${MYSQL_ROOT_PASSWORD:-}" || is_allowing_connection_with_empty_password ]; then

while it should be:

if [ -z "${MYSQL_ROOT_PASSWORD:-}" ] || [ is_allowing_connection_with_empty_password ]; then

[praiskup]

Thanks for the report. Agreed, would you mind creating a PR for this issue?

[snehlatamohite]

Hi,

We are getting similar issue when trying to start mysql5.7 container on ppc64le platform.

Docker start command - docker run -d --name mysql_database10 -e MYSQL_USER=user -e MYSQL_PASSWORD=pass -e MYSQL_DATABASE=db -p 3310:3306 registry.access.redhat.com/rhscl/mysql-57-rhel7

container logs -
2018-08-17T10:34:09.618630Z 7 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2018-08-17T10:34:09.618677Z 7 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-08-17T10:34:09.618694Z 7 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-08-17T10:34:09.618741Z 7 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-08-17T10:34:09.618750Z 7 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-08-17T10:34:09.618774Z 7 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2018-08-17T10:34:09.619070Z 7 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-08-17T10:34:09.619088Z 7 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
/usr/bin/run-mysqld: line 24: [: missing `]'
---> 10:34:09 Initialization finished
=> sourcing 40-datadir-action.sh ...
---> 10:34:10 Running datadir action: upgrade-warn
---> 10:34:10 MySQL server version check passed, both server and data directory are version 5.7.
=> sourcing 50-passwd-change.sh ...

We have applied the above mentioned patch but after that container does not get started and exits.

Observations -
curl command gets response however mysql does not work
root@pts00606-vm15:~# curl localhost:3310
5.7.21z\pNPW"▒▒▒6NUb<)-}ok!2mysql_native_password▒Got packets out of order

root@pts00606-vm15:~# mysql -h localhost -p 3310 -u user
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Please help to get the mysql running and also any help on how to access mysql container will be appreciated.

Thanks,
Snehlata Mohite.