[BUG] CentOS is hard work (error in your SQL)

[noelmcloughlin]

Your setup

Formula commit hash / release tag

Versions reports (master & minion)

Pillar / config used

pillar.example

---

Bug details

Describe the bug

https://bugs.launchpad.net/devstack/+bug/1791892/comments/27

- +?[38;5;242mlib/databases/mysql:configure_database_mysql:113 ?(B?[m sudo mysql -uroot -pdevstack -h127.0.0.1 -e 'CREATE USER IF NOT EXISTS '\''root'\''@'\''%'\'' identified by '\''devstack'\'';'
                  ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IF NOT EXISTS 'root'@'%' identified by 'devstack'' at line 1

Steps to reproduce the bug

Install devstack-formula on centOS.

Expected behaviour

Attempts to fix the bug

Additional context

[noelmcloughlin]

set DATABASE_PASSWORD but still see error on CentOS7.

                  +?[38;5;242mlib/databases/mysql:configure_database_mysql:113 ?(B?[m sudo mysql -uroot -pdevstack -h127.0.0.1 -e 'CREATE USER IF NOT EXISTS '\''root'\''@'\''%'\'' identified by '\''devstack'\'';'
                  ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IF NOT EXISTS 'root'@'%' identified by 'devstack'' at line 1