Comment 2 for bug 1951005

https://bugs.launchpad.net/snap-openstack/+bug/2030317

Having the same issues trying to install openstack.

unit-keystone-mysql-router-0: 18:36:08 ERROR juju.worker.uniter.operation hook "mysql-router-pebble-ready" (via hook dispatching script: dispatch) failed: exit status 1
unit-keystone-mysql-router-0: 18:36:08 ERROR juju.worker.uniter pebble poll failed for container "mysql-router": failed to send pebble-ready event: hook failed
unit-nova-cell-mysql-router-0: 18:36:09 ERROR unit.nova-cell-mysql-router/0.juju-log Failed to run logged_commands=["shell.connect('relation-65:***@mysql-primary.openstack.svc.cluster.local:3306')", 'session.run_sql("CREATE DATABASE IF NOT EXISTS `nova_cell0`")', 'session.run_sql("CREATE USER `relation-65-35` IDENTIFIED BY \'qpMysaXicFPARCTgsZh6J150\' ATTRIBUTE \'{\\"created_by_user\\": \\"relation-65\\"}\'")', 'session.run_sql("GRANT ALL PRIVILEGES ON `nova_cell0`.* TO `relation-65-35`")']
stderr:
Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory
Traceback (most recent call last):
  File "<string>", line 3, in <module>
mysqlsh.DBError: MySQL Error (1396): ClassicSession.run_sql: Operation CREATE USER failed for 'relation-65-35'@'%'

Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-nova-cell-mysql-router-0/charm/src/rock.py", line 119, in _run_command
    output, _ = process.wait_output()
  File "/var/lib/juju/agents/unit-nova-cell-mysql-router-0/charm/venv/ops/pebble.py", line 1359, in wait_output
    raise ExecError[AnyStr](self._command, exit_code, out_value, err_value)
ops.pebble.ExecError: non-zero exit code 1 executing ['mysqlsh', '--no-wizard', '--python', '--file', '/tmp/script.py'], stdout='', stderr='Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory\nTraceback (most recent call last):\n File "<string>", line 3, in <module>\nmysqlsh.DBError: MySQL Error (1396): ClassicSession.run_sql: Operation CREATE USER failed for \'relation-65-35\'@\'%\'\n'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-nova-cell-mysql-router-0/charm/src/mysql_shell.py", line 58, in _run_commands
    output = self._container.run_mysql_shell(
  File "/var/lib/juju/agents/unit-nova-cell-mysql-router-0/charm/src/container.py", line 130, in run_mysql_shell
    return self._run_command(args, timeout=timeout)
  File "/var/lib/juju/agents/unit-nova-cell-mysql-router-0/charm/src/rock.py", line 121, in _run_command
    raise container.CalledProcessError(
container.CalledProcessError: Command '['mysqlsh', '--no-wizard', '--python', '--file', '/tmp/script.py']' returned non-zero exit status 1.