26. 이제 MySQL을 재실행해 Keystone 데이터베이스를 삭제하고 재생성합니다. 그리고 localhost와 원격에서 접속할 수 있는 접속 권한을 설정하고 빠져나옵니다.
root@controller:/etc/mysql/mariadb.conf.d# cd root@controller:~# mysql -u root -popenstack Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 35 Server version: 10.0.24-MariaDB-7 Ubuntu 16.04
Copyright © 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
MariaDB [(none)]> drop database keystone; Query OK, 1 row affected (0.00 sec)
MariaDB [(none)]> CREATE DATABASE keystone; Query OK, 1 row affected (0.00 sec)
MariaDB [(none)]> GRANT ALL PRIVILEGES ON keystone.* TO ‘keystone’@‘localhost’ IDENTIFIED BY ‘keystonedbpass’; Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> GRANT ALL PRIVILEGES ON keystone.* TO ‘keystone’@‘%’ IDENTIFIED BY ‘keystonedbpass’; Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> exit; Bye