| demskeq8 | 4e1f84c | 2023-07-04 08:39:43 +0000 | [diff] [blame^] | 1 | #!/bin/sh |
| 2 | |
| 3 | ### |
| 4 | # ============LICENSE_START======================================================= |
| 5 | # ONAP : SDN-C |
| 6 | # ================================================================================ |
| 7 | # Copyright (C) 2023 highstreet technologies Intellectual Property. All rights reserved. |
| 8 | # ================================================================================ |
| 9 | # Licensed under the Apache License, Version 2.0 (the "License"); |
| 10 | # you may not use this file except in compliance with the License. |
| 11 | # You may obtain a copy of the License at |
| 12 | # |
| 13 | # http://www.apache.org/licenses/LICENSE-2.0 |
| 14 | # |
| 15 | # Unless required by applicable law or agreed to in writing, software |
| 16 | # distributed under the License is distributed on an "AS IS" BASIS, |
| 17 | # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| 18 | # See the License for the specific language governing permissions and |
| 19 | # limitations under the License. |
| 20 | # ============LICENSE_END========================================================= |
| 21 | ### |
| 22 | |
| 23 | echo "Create '${SDNRDBDATABASE}' and user '${SDNRDBUSERNAME}' within maria-galera database cluster" |
| 24 | root_user=root |
| 25 | mysql -v -v -u $root_user -p${MYSQL_ROOT_PASSWORD} -Bse "\ |
| 26 | CREATE DATABASE IF NOT EXISTS ${SDNRDBDATABASE}; \ |
| 27 | CREATE USER IF NOT EXISTS ${SDNRDBUSERNAME}@'%' IDENTIFIED BY '${SDNRDBPASSWORD}'; \ |
| 28 | GRANT ALL PRIVILEGES ON ${SDNRDBDATABASE}.* TO '${SDNRDBUSERNAME}'@'%'; \ |
| 29 | FLUSH PRIVILEGES; " |
| 30 | |