MySQL database 5.7 with template mysql-persistent fails with pod log error code ERROR 1133 (42000)

Solution In Progress - Updated -

Issue

  • Deploying a MySQL database 5.7 with template mysql-persistent doesn't work. The database pod fails with the below error message:
2018-08-20T12:30:52.521784Z 0 [Note] /opt/rh/rh-mysql57/root/usr/libexec/mysqld: ready for connections.
Version: '5.7.21'  socket: '/tmp/mysql.sock'  port: 0  MySQL Community Server (GPL)
---> 12:30:52     MySQL started successfully
/usr/bin/run-mysqld: line 24: [: missing `]'
=> sourcing 40-datadir-action.sh ...
---> 12:30:52     Running datadir action: upgrade-warn
---> 12:30:52     MySQL server version check passed, both server and data directory are version 5.7.
=> sourcing 50-passwd-change.sh ...
---> 12:30:52     Setting passwords ...
ERROR 1133 (42000) at line 1: Can't find any matching row in the user table
  • Fail to connect to mysql db with the above error. Same deployment works on non VMWare environments or non EFS storage on AWS.

Environment

  • MySQL 5.7 from Software Collections

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.