...
for db in support onap_sdk log migration operationshistory10 pooling policyadmin policyclamp operationshistory mytestschema testschema
do
mysql -uroot -p"${MYSQL_ROOT_PASSWORD}" --execute "CREATE DATABASE IF NOT EXISTS ${db};"
mysql -uroot -p"${MYSQL_ROOT_PASSWORD}" --execute "GRANT ALL PRIVILEGES ON \`${db}\`.* TO '${MYSQL_USER}'@'%' ;"
done
mysql -uroot -p"${MYSQL_ROOT_PASSWORD}" --execute "FLUSH PRIVILEGES;"
login to mariadb
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 254
Server version: 10.5.8-MariaDB-log Source distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+---------------------+
| Database |
+---------------------+
| information_schema |
| log |
| migration |
| onap_sdk |
| operationshistory |
| operationshistory10 |
| policyadmin |
| policyclamp |
| pooling |
| support |
| test |
| testschema |
+---------------------+
12 rows in set (0.006 sec)
MariaDB [(none)]> use testschema;
Database changed
Test Upgrade/downgrade when pdpstatistics is not present
...