더북(TheBook)

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

신간 소식 구독하기
뉴스레터에 가입하시고 이메일로 신간 소식을 받아 보세요.