)]}'
{"doc/source/user/manage-db-and-users.rst":[{"author":{"_account_id":25113,"name":"Fan Zhang","email":"zh.f@outlook.com","username":"fanzhang"},"change_message_id":"a0073e0822735bcd38032d1a7b7e089b8eec36bc","unresolved":false,"context_lines":[{"line_number":67,"context_line":""},{"line_number":68,"context_line":"   .. code-block:: console"},{"line_number":69,"context_line":""},{"line_number":70,"context_line":"      $ openstack database instance create db-instance d2 --datastore mysql \\"},{"line_number":71,"context_line":"      --datastore_version 5.7 --size 2 --volume_type lvmdriver-1 \\"},{"line_number":72,"context_line":"      --users test:test --databases testdb"},{"line_number":73,"context_line":""}],"source_content_type":"text/x-rst","patch_set":1,"id":"9fdfeff1_bcbd1fd9","line":70,"range":{"start_line":70,"start_character":55,"end_line":70,"end_character":57},"updated":"2019-01-30 07:21:17.000000000","message":"Better to specify here we can use flavor id or name?\n\nOr give a usage reference first like :\nopenstack database instance create db-instance \u003cflavor\u003e --datastore \u003cdatastore_name\u003e --datastore_version \u003cds_version_name\u003e ....","commit_id":"6f34037fb181e76503f212f3e947e91895c92014"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"16e097d36ccb5f3694091488486355274c333ab0","unresolved":false,"context_lines":[{"line_number":67,"context_line":""},{"line_number":68,"context_line":"   .. code-block:: console"},{"line_number":69,"context_line":""},{"line_number":70,"context_line":"      $ openstack database instance create db-instance d2 --datastore mysql \\"},{"line_number":71,"context_line":"      --datastore_version 5.7 --size 2 --volume_type lvmdriver-1 \\"},{"line_number":72,"context_line":"      --users test:test --databases testdb"},{"line_number":73,"context_line":""}],"source_content_type":"text/x-rst","patch_set":1,"id":"9fdfeff1_617a8bba","line":70,"range":{"start_line":70,"start_character":55,"end_line":70,"end_character":57},"in_reply_to":"9fdfeff1_964265aa","updated":"2019-01-31 22:14:31.000000000","message":"Done","commit_id":"6f34037fb181e76503f212f3e947e91895c92014"},{"author":{"_account_id":22694,"name":"jian.song","email":"jiansong19941206@gmail.com","username":"jiansong"},"change_message_id":"d054eda5b1af3eea51369c589a810c5e6e199f16","unresolved":false,"context_lines":[{"line_number":67,"context_line":""},{"line_number":68,"context_line":"   .. code-block:: console"},{"line_number":69,"context_line":""},{"line_number":70,"context_line":"      $ openstack database instance create db-instance d2 --datastore mysql \\"},{"line_number":71,"context_line":"      --datastore_version 5.7 --size 2 --volume_type lvmdriver-1 \\"},{"line_number":72,"context_line":"      --users test:test --databases testdb"},{"line_number":73,"context_line":""}],"source_content_type":"text/x-rst","patch_set":1,"id":"9fdfeff1_964265aa","line":70,"range":{"start_line":70,"start_character":55,"end_line":70,"end_character":57},"in_reply_to":"9fdfeff1_bcbd1fd9","updated":"2019-01-31 07:04:21.000000000","message":"Agree with fanzhang, the current document can not distinguish which parameters, which are command","commit_id":"6f34037fb181e76503f212f3e947e91895c92014"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"16e097d36ccb5f3694091488486355274c333ab0","unresolved":false,"context_lines":[{"line_number":67,"context_line":""},{"line_number":68,"context_line":"   .. code-block:: console"},{"line_number":69,"context_line":""},{"line_number":70,"context_line":"      $ openstack database instance create db-instance d2 --datastore mysql \\"},{"line_number":71,"context_line":"      --datastore_version 5.7 --size 2 --volume_type lvmdriver-1 \\"},{"line_number":72,"context_line":"      --users test:test --databases testdb"},{"line_number":73,"context_line":""}],"source_content_type":"text/x-rst","patch_set":1,"id":"9fdfeff1_a174f3cf","line":70,"range":{"start_line":70,"start_character":55,"end_line":70,"end_character":57},"in_reply_to":"9fdfeff1_bcbd1fd9","updated":"2019-01-31 22:14:31.000000000","message":"Done","commit_id":"6f34037fb181e76503f212f3e947e91895c92014"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":4,"context_line":""},{"line_number":5,"context_line":"Assume that you installed Trove service and upload images with datastore"},{"line_number":6,"context_line":"of your choice."},{"line_number":7,"context_line":"This section shows how to manage users and database in a MySQL 5.7 instance."},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"Create a Trove instance with database and user"},{"line_number":10,"context_line":"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_0c811d4b","line":7,"range":{"start_line":7,"start_character":43,"end_line":7,"end_character":51},"updated":"2019-02-20 16:26:27.000000000","message":"databases","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":4,"context_line":""},{"line_number":5,"context_line":"Assume that you installed Trove service and upload images with datastore"},{"line_number":6,"context_line":"of your choice."},{"line_number":7,"context_line":"This section shows how to manage users and database in a MySQL 5.7 instance."},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"Create a Trove instance with database and user"},{"line_number":10,"context_line":"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_7262d2da","line":7,"range":{"start_line":7,"start_character":43,"end_line":7,"end_character":51},"in_reply_to":"9fdfeff1_0c811d4b","updated":"2019-02-22 18:26:34.000000000","message":"Done","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":11,"context_line":""},{"line_number":12,"context_line":"#. **Determine available flavors and datastores**"},{"line_number":13,"context_line":""},{"line_number":14,"context_line":"   When you create a Trove instance, you must specify a nova flavor."},{"line_number":15,"context_line":"   The flavor indicates computing and storage resources for the instance,"},{"line_number":16,"context_line":"   such as number of CPU cores, RAM memory and storage size."},{"line_number":17,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_ac95718a","line":14,"range":{"start_line":14,"start_character":56,"end_line":14,"end_character":60},"updated":"2019-02-20 16:26:27.000000000","message":"Nova","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":11,"context_line":""},{"line_number":12,"context_line":"#. **Determine available flavors and datastores**"},{"line_number":13,"context_line":""},{"line_number":14,"context_line":"   When you create a Trove instance, you must specify a nova flavor."},{"line_number":15,"context_line":"   The flavor indicates computing and storage resources for the instance,"},{"line_number":16,"context_line":"   such as number of CPU cores, RAM memory and storage size."},{"line_number":17,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_529d4eb9","line":14,"range":{"start_line":14,"start_character":56,"end_line":14,"end_character":60},"in_reply_to":"9fdfeff1_ac95718a","updated":"2019-02-22 18:26:34.000000000","message":"Done","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":13,"context_line":""},{"line_number":14,"context_line":"   When you create a Trove instance, you must specify a nova flavor."},{"line_number":15,"context_line":"   The flavor indicates computing and storage resources for the instance,"},{"line_number":16,"context_line":"   such as number of CPU cores, RAM memory and storage size."},{"line_number":17,"context_line":""},{"line_number":18,"context_line":"   Start by listing available flavors."},{"line_number":19,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_ecf05900","line":16,"range":{"start_line":16,"start_character":34,"end_line":16,"end_character":42},"updated":"2019-02-20 16:26:27.000000000","message":"\"memory\" is duplicated since RAM \u003d Random-Access Memory","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":13,"context_line":""},{"line_number":14,"context_line":"   When you create a Trove instance, you must specify a nova flavor."},{"line_number":15,"context_line":"   The flavor indicates computing and storage resources for the instance,"},{"line_number":16,"context_line":"   such as number of CPU cores, RAM memory and storage size."},{"line_number":17,"context_line":""},{"line_number":18,"context_line":"   Start by listing available flavors."},{"line_number":19,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_acda5176","line":16,"range":{"start_line":16,"start_character":47,"end_line":16,"end_character":54},"updated":"2019-02-20 16:26:27.000000000","message":"storage -\u003e disk","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":13,"context_line":""},{"line_number":14,"context_line":"   When you create a Trove instance, you must specify a nova flavor."},{"line_number":15,"context_line":"   The flavor indicates computing and storage resources for the instance,"},{"line_number":16,"context_line":"   such as number of CPU cores, RAM memory and storage size."},{"line_number":17,"context_line":""},{"line_number":18,"context_line":"   Start by listing available flavors."},{"line_number":19,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_b2ad9aeb","line":16,"range":{"start_line":16,"start_character":47,"end_line":16,"end_character":54},"in_reply_to":"9fdfeff1_acda5176","updated":"2019-02-22 18:26:34.000000000","message":"Done","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":13,"context_line":""},{"line_number":14,"context_line":"   When you create a Trove instance, you must specify a nova flavor."},{"line_number":15,"context_line":"   The flavor indicates computing and storage resources for the instance,"},{"line_number":16,"context_line":"   such as number of CPU cores, RAM memory and storage size."},{"line_number":17,"context_line":""},{"line_number":18,"context_line":"   Start by listing available flavors."},{"line_number":19,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_d2a85eda","line":16,"range":{"start_line":16,"start_character":34,"end_line":16,"end_character":42},"in_reply_to":"9fdfeff1_ecf05900","updated":"2019-02-22 18:26:34.000000000","message":"Done","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":48,"context_line":"    | ID                                   | Name             |"},{"line_number":49,"context_line":"    +--------------------------------------+------------------+"},{"line_number":50,"context_line":"    | 90881f3c-b326-4334-9560-8778ae5307a1 | mysql            |"},{"line_number":51,"context_line":"    | d96805c2-6b10-49f9-be5f-66ffa33b4816 | Test_Datastore_1 |"},{"line_number":52,"context_line":"    +--------------------------------------+------------------+"},{"line_number":53,"context_line":""},{"line_number":54,"context_line":"     $ openstack datastore version list mysql"}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_6c5229e1","line":51,"updated":"2019-02-20 16:26:27.000000000","message":"Instead of unknown \"test\" datastore you could populate some real datastores, e.g. redis, cassandra, mariadb etc..","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"001a242cb4c544d5e481c981c974b3968d6919b7","unresolved":false,"context_lines":[{"line_number":48,"context_line":"    | ID                                   | Name             |"},{"line_number":49,"context_line":"    +--------------------------------------+------------------+"},{"line_number":50,"context_line":"    | 90881f3c-b326-4334-9560-8778ae5307a1 | mysql            |"},{"line_number":51,"context_line":"    | d96805c2-6b10-49f9-be5f-66ffa33b4816 | Test_Datastore_1 |"},{"line_number":52,"context_line":"    +--------------------------------------+------------------+"},{"line_number":53,"context_line":""},{"line_number":54,"context_line":"     $ openstack datastore version list mysql"}],"source_content_type":"text/x-rst","patch_set":3,"id":"5fc1f717_19b9f8e7","line":51,"in_reply_to":"9fdfeff1_52622eaf","updated":"2019-03-13 13:26:05.000000000","message":"This is not documentation of Devstack Trove, but rather general operational guide. Anyway I respect your intent and think we can leave it as is.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":48,"context_line":"    | ID                                   | Name             |"},{"line_number":49,"context_line":"    +--------------------------------------+------------------+"},{"line_number":50,"context_line":"    | 90881f3c-b326-4334-9560-8778ae5307a1 | mysql            |"},{"line_number":51,"context_line":"    | d96805c2-6b10-49f9-be5f-66ffa33b4816 | Test_Datastore_1 |"},{"line_number":52,"context_line":"    +--------------------------------------+------------------+"},{"line_number":53,"context_line":""},{"line_number":54,"context_line":"     $ openstack datastore version list mysql"}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_52622eaf","line":51,"in_reply_to":"9fdfeff1_6c5229e1","updated":"2019-02-22 18:26:34.000000000","message":"This is an actual state after devstack installation so I would leave it as it is to make it more familiar for new users.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":62,"context_line":""},{"line_number":63,"context_line":"#. **Create new Trove instance**"},{"line_number":64,"context_line":""},{"line_number":65,"context_line":"   Now, you can create a new Trove instance with MySQL 5.7 with initial"},{"line_number":66,"context_line":"   user and database. We will use *db-instance* as a name of the created"},{"line_number":67,"context_line":"   Trove instance throughout this page."},{"line_number":68,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_ac71f179","line":65,"range":{"start_line":65,"start_character":25,"end_line":65,"end_character":58},"updated":"2019-02-20 16:26:27.000000000","message":"ordering: \"new MySQL 5.7 instance in Trove\"","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"001a242cb4c544d5e481c981c974b3968d6919b7","unresolved":false,"context_lines":[{"line_number":62,"context_line":""},{"line_number":63,"context_line":"#. **Create new Trove instance**"},{"line_number":64,"context_line":""},{"line_number":65,"context_line":"   Now, you can create a new Trove instance with MySQL 5.7 with initial"},{"line_number":66,"context_line":"   user and database. We will use *db-instance* as a name of the created"},{"line_number":67,"context_line":"   Trove instance throughout this page."},{"line_number":68,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"5fc1f717_d97cd020","line":65,"range":{"start_line":65,"start_character":25,"end_line":65,"end_character":58},"in_reply_to":"9fdfeff1_4f34c4de","updated":"2019-03-13 13:26:05.000000000","message":"Both versions are correct. Just suggested modified variation without duplicated \"with\" phrase.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":62,"context_line":""},{"line_number":63,"context_line":"#. **Create new Trove instance**"},{"line_number":64,"context_line":""},{"line_number":65,"context_line":"   Now, you can create a new Trove instance with MySQL 5.7 with initial"},{"line_number":66,"context_line":"   user and database. We will use *db-instance* as a name of the created"},{"line_number":67,"context_line":"   Trove instance throughout this page."},{"line_number":68,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_4f34c4de","line":65,"range":{"start_line":65,"start_character":25,"end_line":65,"end_character":58},"in_reply_to":"9fdfeff1_ac71f179","updated":"2019-02-22 18:26:34.000000000","message":"I\u0027m not a native speaker but Trove instance refers to a VM managed by Trove, while MySQL instance refers to a process of mysqld. My intention here was to say how to create a VM managed by Trove with installed mysql.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":66,"context_line":"   user and database. We will use *db-instance* as a name of the created"},{"line_number":67,"context_line":"   Trove instance throughout this page."},{"line_number":68,"context_line":""},{"line_number":69,"context_line":"   **Note**: in most cases you can pass either name as a reference to openstack"},{"line_number":70,"context_line":"   resources (e.g. flavor, datastore, volume_type) instead of id if the name"},{"line_number":71,"context_line":"   uniquely identifies the resource."},{"line_number":72,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_8c68ad87","line":69,"range":{"start_line":69,"start_character":13,"end_line":69,"end_character":15},"updated":"2019-02-20 16:26:27.000000000","message":"In","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":66,"context_line":"   user and database. We will use *db-instance* as a name of the created"},{"line_number":67,"context_line":"   Trove instance throughout this page."},{"line_number":68,"context_line":""},{"line_number":69,"context_line":"   **Note**: in most cases you can pass either name as a reference to openstack"},{"line_number":70,"context_line":"   resources (e.g. flavor, datastore, volume_type) instead of id if the name"},{"line_number":71,"context_line":"   uniquely identifies the resource."},{"line_number":72,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_acf6d1d7","line":69,"range":{"start_line":69,"start_character":70,"end_line":69,"end_character":79},"updated":"2019-02-20 16:26:27.000000000","message":"OpenStack","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":66,"context_line":"   user and database. We will use *db-instance* as a name of the created"},{"line_number":67,"context_line":"   Trove instance throughout this page."},{"line_number":68,"context_line":""},{"line_number":69,"context_line":"   **Note**: in most cases you can pass either name as a reference to openstack"},{"line_number":70,"context_line":"   resources (e.g. flavor, datastore, volume_type) instead of id if the name"},{"line_number":71,"context_line":"   uniquely identifies the resource."},{"line_number":72,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_125ca6eb","line":69,"range":{"start_line":69,"start_character":13,"end_line":69,"end_character":15},"in_reply_to":"9fdfeff1_8c68ad87","updated":"2019-02-22 18:26:34.000000000","message":"OpenStack Done, but \u0027in\u0027 doesn\u0027t start the sentence.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":72,"context_line":""},{"line_number":73,"context_line":"   .. code-block:: console"},{"line_number":74,"context_line":""},{"line_number":75,"context_line":"      # Trove instance create command+"},{"line_number":76,"context_line":"      # openstack database instance create \u003cinstance_name\u003e \u003cflavor_id_or_name\u003e [options]"},{"line_number":77,"context_line":""},{"line_number":78,"context_line":"      $ openstack database instance create db-instance d2 --datastore mysql \\"},{"line_number":79,"context_line":"      --datastore_version 5.7 --size 2 --volume_type lvmdriver-1 \\"}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_6ceea9ee","line":76,"range":{"start_line":75,"start_character":0,"end_line":76,"end_character":88},"updated":"2019-02-20 16:26:27.000000000","message":"Let\u0027s move the snippet into a separate code block.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":72,"context_line":""},{"line_number":73,"context_line":"   .. code-block:: console"},{"line_number":74,"context_line":""},{"line_number":75,"context_line":"      # Trove instance create command+"},{"line_number":76,"context_line":"      # openstack database instance create \u003cinstance_name\u003e \u003cflavor_id_or_name\u003e [options]"},{"line_number":77,"context_line":""},{"line_number":78,"context_line":"      $ openstack database instance create db-instance d2 --datastore mysql \\"},{"line_number":79,"context_line":"      --datastore_version 5.7 --size 2 --volume_type lvmdriver-1 \\"}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_f27c8273","line":76,"range":{"start_line":75,"start_character":0,"end_line":76,"end_character":88},"in_reply_to":"9fdfeff1_6ceea9ee","updated":"2019-02-22 18:26:34.000000000","message":"Done","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":76,"context_line":"      # openstack database instance create \u003cinstance_name\u003e \u003cflavor_id_or_name\u003e [options]"},{"line_number":77,"context_line":""},{"line_number":78,"context_line":"      $ openstack database instance create db-instance d2 --datastore mysql \\"},{"line_number":79,"context_line":"      --datastore_version 5.7 --size 2 --volume_type lvmdriver-1 \\"},{"line_number":80,"context_line":"      --users test:test --databases testdb"},{"line_number":81,"context_line":""},{"line_number":82,"context_line":"    +-------------------------+--------------------------------------+"}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_cc1c7515","line":79,"range":{"start_line":79,"start_character":39,"end_line":79,"end_character":64},"updated":"2019-02-20 16:26:27.000000000","message":"I am missing an explanation about what \"volume type\" is.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":76,"context_line":"      # openstack database instance create \u003cinstance_name\u003e \u003cflavor_id_or_name\u003e [options]"},{"line_number":77,"context_line":""},{"line_number":78,"context_line":"      $ openstack database instance create db-instance d2 --datastore mysql \\"},{"line_number":79,"context_line":"      --datastore_version 5.7 --size 2 --volume_type lvmdriver-1 \\"},{"line_number":80,"context_line":"      --users test:test --databases testdb"},{"line_number":81,"context_line":""},{"line_number":82,"context_line":"    +-------------------------+--------------------------------------+"}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_cc39a2f2","line":79,"range":{"start_line":79,"start_character":39,"end_line":79,"end_character":64},"in_reply_to":"9fdfeff1_cc1c7515","updated":"2019-02-22 18:26:34.000000000","message":"I didn\u0027t explain any parameter and volume_type is not exception :) description of all parameters can be found with command line help. The proposed manual and command should work on newly installed devstack.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":75,"context_line":"      # Trove instance create command+"},{"line_number":76,"context_line":"      # openstack database instance create \u003cinstance_name\u003e \u003cflavor_id_or_name\u003e [options]"},{"line_number":77,"context_line":""},{"line_number":78,"context_line":"      $ openstack database instance create db-instance d2 --datastore mysql \\"},{"line_number":79,"context_line":"      --datastore_version 5.7 --size 2 --volume_type lvmdriver-1 \\"},{"line_number":80,"context_line":"      --users test:test --databases testdb"},{"line_number":81,"context_line":""},{"line_number":82,"context_line":"    +-------------------------+--------------------------------------+"},{"line_number":83,"context_line":"    | Field                   | Value                                |"}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_ecda9949","line":80,"range":{"start_line":78,"start_character":8,"end_line":80,"end_character":42},"updated":"2019-02-20 16:26:27.000000000","message":"Let\u0027s split the command into multiple lines for better readability. Each --argument in a separate line.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":75,"context_line":"      # Trove instance create command+"},{"line_number":76,"context_line":"      # openstack database instance create \u003cinstance_name\u003e \u003cflavor_id_or_name\u003e [options]"},{"line_number":77,"context_line":""},{"line_number":78,"context_line":"      $ openstack database instance create db-instance d2 --datastore mysql \\"},{"line_number":79,"context_line":"      --datastore_version 5.7 --size 2 --volume_type lvmdriver-1 \\"},{"line_number":80,"context_line":"      --users test:test --databases testdb"},{"line_number":81,"context_line":""},{"line_number":82,"context_line":"    +-------------------------+--------------------------------------+"},{"line_number":83,"context_line":"    | Field                   | Value                                |"}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_928bb666","line":80,"range":{"start_line":78,"start_character":8,"end_line":80,"end_character":42},"in_reply_to":"9fdfeff1_ecda9949","updated":"2019-02-22 18:26:34.000000000","message":"Done","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":128,"context_line":""},{"line_number":129,"context_line":"   .. code-block:: console"},{"line_number":130,"context_line":""},{"line_number":131,"context_line":"     $ openstack server show db-instance"},{"line_number":132,"context_line":""},{"line_number":133,"context_line":"    +-------------------------------------+----------------------------------------------------------+"},{"line_number":134,"context_line":"    | Field                               | Value                                                    |"}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_cc223502","line":131,"range":{"start_line":131,"start_character":7,"end_line":131,"end_character":40},"updated":"2019-02-20 16:26:27.000000000","message":"\"trove show\" command displays instance IP as well.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":128,"context_line":""},{"line_number":129,"context_line":"   .. code-block:: console"},{"line_number":130,"context_line":""},{"line_number":131,"context_line":"     $ openstack server show db-instance"},{"line_number":132,"context_line":""},{"line_number":133,"context_line":"    +-------------------------------------+----------------------------------------------------------+"},{"line_number":134,"context_line":"    | Field                               | Value                                                    |"}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_8c0cfa42","line":131,"range":{"start_line":131,"start_character":7,"end_line":131,"end_character":40},"in_reply_to":"9fdfeff1_cc223502","updated":"2019-02-22 18:26:34.000000000","message":"You may be right but we should promote openstack command line by default.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":166,"context_line":""},{"line_number":167,"context_line":""},{"line_number":168,"context_line":"    $ mysql -h 172.24.4.199 -u test -p testdb"},{"line_number":169,"context_line":"    Enter password:"},{"line_number":170,"context_line":""},{"line_number":171,"context_line":"    Welcome to the MySQL monitor.  Commands end with ; or \\g."},{"line_number":172,"context_line":"    Your MySQL connection id is 12"},{"line_number":173,"context_line":"    Server version: 5.7.25-0ubuntu0.16.04.2 (Ubuntu)"},{"line_number":174,"context_line":""},{"line_number":175,"context_line":"    Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved."},{"line_number":176,"context_line":""},{"line_number":177,"context_line":"    Oracle is a registered trademark of Oracle Corporation and/or its"},{"line_number":178,"context_line":"    affiliates. Other names may be trademarks of their respective"},{"line_number":179,"context_line":"    owners."},{"line_number":180,"context_line":""},{"line_number":181,"context_line":"    Type \u0027help;\u0027 or \u0027\\h\u0027 for help. Type \u0027\\c\u0027 to clear the current input statement."},{"line_number":182,"context_line":""},{"line_number":183,"context_line":""},{"line_number":184,"context_line":"    mysql\u003e show databases;"}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_ac6a5118","line":181,"range":{"start_line":169,"start_character":0,"end_line":181,"end_character":82},"updated":"2019-02-20 16:26:27.000000000","message":"This output is irrelevant. It should be removed.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":166,"context_line":""},{"line_number":167,"context_line":""},{"line_number":168,"context_line":"    $ mysql -h 172.24.4.199 -u test -p testdb"},{"line_number":169,"context_line":"    Enter password:"},{"line_number":170,"context_line":""},{"line_number":171,"context_line":"    Welcome to the MySQL monitor.  Commands end with ; or \\g."},{"line_number":172,"context_line":"    Your MySQL connection id is 12"},{"line_number":173,"context_line":"    Server version: 5.7.25-0ubuntu0.16.04.2 (Ubuntu)"},{"line_number":174,"context_line":""},{"line_number":175,"context_line":"    Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved."},{"line_number":176,"context_line":""},{"line_number":177,"context_line":"    Oracle is a registered trademark of Oracle Corporation and/or its"},{"line_number":178,"context_line":"    affiliates. Other names may be trademarks of their respective"},{"line_number":179,"context_line":"    owners."},{"line_number":180,"context_line":""},{"line_number":181,"context_line":"    Type \u0027help;\u0027 or \u0027\\h\u0027 for help. Type \u0027\\c\u0027 to clear the current input statement."},{"line_number":182,"context_line":""},{"line_number":183,"context_line":""},{"line_number":184,"context_line":"    mysql\u003e show databases;"}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_ac077e1d","line":181,"range":{"start_line":169,"start_character":0,"end_line":181,"end_character":82},"in_reply_to":"9fdfeff1_ac6a5118","updated":"2019-02-22 18:26:34.000000000","message":"Done","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":192,"context_line":""},{"line_number":193,"context_line":"    2 rows in set (0.01 sec)"},{"line_number":194,"context_line":""},{"line_number":195,"context_line":"    mysql\u003e ^DBye"},{"line_number":196,"context_line":""},{"line_number":197,"context_line":""},{"line_number":198,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_ec59398e","line":195,"updated":"2019-02-20 16:26:27.000000000","message":"This output is irrelevant. It should be removed.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":192,"context_line":""},{"line_number":193,"context_line":"    2 rows in set (0.01 sec)"},{"line_number":194,"context_line":""},{"line_number":195,"context_line":"    mysql\u003e ^DBye"},{"line_number":196,"context_line":""},{"line_number":197,"context_line":""},{"line_number":198,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_4c061223","line":195,"in_reply_to":"9fdfeff1_ec59398e","updated":"2019-02-22 18:26:34.000000000","message":"Done","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":199,"context_line":"Add new database and user to an existing Trove instance"},{"line_number":200,"context_line":"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"},{"line_number":201,"context_line":""},{"line_number":202,"context_line":"Trove provides a unified API to manage users and databases on"},{"line_number":203,"context_line":"datastores including relational (e.g. MySQL, PostgreSQL) and non-relational"},{"line_number":204,"context_line":"(e.g. Redis, Cassandra). Once a Trove instance with a datastore of choice is"},{"line_number":205,"context_line":"active you can use Trove API to create new databases and/or users."}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_4cf3a574","line":202,"range":{"start_line":202,"start_character":17,"end_line":202,"end_character":24},"updated":"2019-02-20 16:26:27.000000000","message":"I used the phrase \"unified\" to describe this feature and found people to be confused about it. \"datastore agnostic\" seems to be more self-explanatory.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":199,"context_line":"Add new database and user to an existing Trove instance"},{"line_number":200,"context_line":"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"},{"line_number":201,"context_line":""},{"line_number":202,"context_line":"Trove provides a unified API to manage users and databases on"},{"line_number":203,"context_line":"datastores including relational (e.g. MySQL, PostgreSQL) and non-relational"},{"line_number":204,"context_line":"(e.g. Redis, Cassandra). Once a Trove instance with a datastore of choice is"},{"line_number":205,"context_line":"active you can use Trove API to create new databases and/or users."}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_f2f1e202","line":202,"range":{"start_line":202,"start_character":17,"end_line":202,"end_character":24},"in_reply_to":"9fdfeff1_4cf3a574","updated":"2019-02-22 18:26:34.000000000","message":"I\u0027ve removed the phrase.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":227,"context_line":""},{"line_number":228,"context_line":""},{"line_number":229,"context_line":"  $ mysql -h 172.24.4.199 -u newuser -p testdb"},{"line_number":230,"context_line":"    Enter password:"},{"line_number":231,"context_line":""},{"line_number":232,"context_line":"    Welcome to the MySQL monitor.  Commands end with ; or \\g."},{"line_number":233,"context_line":"    Your MySQL connection id is 18"},{"line_number":234,"context_line":"    Server version: 5.7.25-0ubuntu0.16.04.2 (Ubuntu)"},{"line_number":235,"context_line":""},{"line_number":236,"context_line":"    Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved."},{"line_number":237,"context_line":""},{"line_number":238,"context_line":"    Oracle is a registered trademark of Oracle Corporation and/or its"},{"line_number":239,"context_line":"    affiliates. Other names may be trademarks of their respective"},{"line_number":240,"context_line":"    owners."},{"line_number":241,"context_line":""},{"line_number":242,"context_line":"    Type \u0027help;\u0027 or \u0027\\h\u0027 for help. Type \u0027\\c\u0027 to clear the current input statement."},{"line_number":243,"context_line":""},{"line_number":244,"context_line":"    mysql\u003e show databases;"},{"line_number":245,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_ec9cd90f","line":242,"range":{"start_line":230,"start_character":0,"end_line":242,"end_character":82},"updated":"2019-02-20 16:26:27.000000000","message":"This output is irrelevant. It should be removed.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":227,"context_line":""},{"line_number":228,"context_line":""},{"line_number":229,"context_line":"  $ mysql -h 172.24.4.199 -u newuser -p testdb"},{"line_number":230,"context_line":"    Enter password:"},{"line_number":231,"context_line":""},{"line_number":232,"context_line":"    Welcome to the MySQL monitor.  Commands end with ; or \\g."},{"line_number":233,"context_line":"    Your MySQL connection id is 18"},{"line_number":234,"context_line":"    Server version: 5.7.25-0ubuntu0.16.04.2 (Ubuntu)"},{"line_number":235,"context_line":""},{"line_number":236,"context_line":"    Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved."},{"line_number":237,"context_line":""},{"line_number":238,"context_line":"    Oracle is a registered trademark of Oracle Corporation and/or its"},{"line_number":239,"context_line":"    affiliates. Other names may be trademarks of their respective"},{"line_number":240,"context_line":"    owners."},{"line_number":241,"context_line":""},{"line_number":242,"context_line":"    Type \u0027help;\u0027 or \u0027\\h\u0027 for help. Type \u0027\\c\u0027 to clear the current input statement."},{"line_number":243,"context_line":""},{"line_number":244,"context_line":"    mysql\u003e show databases;"},{"line_number":245,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_52d46e47","line":242,"range":{"start_line":230,"start_character":0,"end_line":242,"end_character":82},"in_reply_to":"9fdfeff1_ec9cd90f","updated":"2019-02-22 18:26:34.000000000","message":"Done","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":252,"context_line":""},{"line_number":253,"context_line":"    2 rows in set (0.00 sec)"},{"line_number":254,"context_line":""},{"line_number":255,"context_line":"    mysql\u003e ^DBye"},{"line_number":256,"context_line":""},{"line_number":257,"context_line":""},{"line_number":258,"context_line":"  $ openstack database db create db-instance newdb"}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_0ca27d4c","line":255,"updated":"2019-02-20 16:26:27.000000000","message":"This output is irrelevant. It should be removed.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":252,"context_line":""},{"line_number":253,"context_line":"    2 rows in set (0.00 sec)"},{"line_number":254,"context_line":""},{"line_number":255,"context_line":"    mysql\u003e ^DBye"},{"line_number":256,"context_line":""},{"line_number":257,"context_line":""},{"line_number":258,"context_line":"  $ openstack database db create db-instance newdb"}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_f2ca429f","line":255,"in_reply_to":"9fdfeff1_0ca27d4c","updated":"2019-02-22 18:26:34.000000000","message":"Done","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":270,"context_line":""},{"line_number":271,"context_line":"  $ mysql -h 172.24.4.199 -u newuser -p newdb"},{"line_number":272,"context_line":""},{"line_number":273,"context_line":"    Enter password:"},{"line_number":274,"context_line":"    ERROR 1044 (42000): Access denied for user \u0027newuser\u0027@\u0027%\u0027 to database \u0027newdb\u0027"},{"line_number":275,"context_line":""},{"line_number":276,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_2cbc216b","line":273,"updated":"2019-02-20 16:26:27.000000000","message":"This output is irrelevant. It should be removed.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":270,"context_line":""},{"line_number":271,"context_line":"  $ mysql -h 172.24.4.199 -u newuser -p newdb"},{"line_number":272,"context_line":""},{"line_number":273,"context_line":"    Enter password:"},{"line_number":274,"context_line":"    ERROR 1044 (42000): Access denied for user \u0027newuser\u0027@\u0027%\u0027 to database \u0027newdb\u0027"},{"line_number":275,"context_line":""},{"line_number":276,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_12cee6b3","line":273,"in_reply_to":"9fdfeff1_2cbc216b","updated":"2019-02-22 18:26:34.000000000","message":"Done","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":277,"context_line":"Manage access to databases"},{"line_number":278,"context_line":"~~~~~~~~~~~~~~~~~~~~~~~~~~"},{"line_number":279,"context_line":""},{"line_number":280,"context_line":"With Trove API you can grant and revoke access databases for existing users."},{"line_number":281,"context_line":""},{"line_number":282,"context_line":".. code-block:: console"},{"line_number":283,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_0cbb5d72","line":280,"range":{"start_line":280,"start_character":40,"end_line":280,"end_character":56},"updated":"2019-02-20 16:26:27.000000000","message":"ordering: database access","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":277,"context_line":"Manage access to databases"},{"line_number":278,"context_line":"~~~~~~~~~~~~~~~~~~~~~~~~~~"},{"line_number":279,"context_line":""},{"line_number":280,"context_line":"With Trove API you can grant and revoke access databases for existing users."},{"line_number":281,"context_line":""},{"line_number":282,"context_line":".. code-block:: console"},{"line_number":283,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_d2bffef9","line":280,"range":{"start_line":280,"start_character":40,"end_line":280,"end_character":56},"in_reply_to":"9fdfeff1_0cbb5d72","updated":"2019-02-22 18:26:34.000000000","message":"Done","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":294,"context_line":"    +--------+"},{"line_number":295,"context_line":""},{"line_number":296,"context_line":"  $ mysql -h 172.24.4.199 -u newuser -p newdb"},{"line_number":297,"context_line":"    Enter password:"},{"line_number":298,"context_line":""},{"line_number":299,"context_line":"    Welcome to the MySQL monitor.  Commands end with ; or \\g."},{"line_number":300,"context_line":"    Your MySQL connection id is 24"},{"line_number":301,"context_line":"    Server version: 5.7.25-0ubuntu0.16.04.2 (Ubuntu)"},{"line_number":302,"context_line":""},{"line_number":303,"context_line":"    Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved."},{"line_number":304,"context_line":""},{"line_number":305,"context_line":"    Oracle is a registered trademark of Oracle Corporation and/or its"},{"line_number":306,"context_line":"    affiliates. Other names may be trademarks of their respective"},{"line_number":307,"context_line":"    owners."},{"line_number":308,"context_line":""},{"line_number":309,"context_line":"    Type \u0027help;\u0027 or \u0027\\h\u0027 for help. Type \u0027\\c\u0027 to clear the current input statement."},{"line_number":310,"context_line":""},{"line_number":311,"context_line":"    mysql\u003e ^DBye"},{"line_number":312,"context_line":""},{"line_number":313,"context_line":""},{"line_number":314,"context_line":"  $ openstack database user show access db-instance test"}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_6ca9c922","line":311,"range":{"start_line":297,"start_character":0,"end_line":311,"end_character":16},"updated":"2019-02-20 16:26:27.000000000","message":"This output is irrelevant. It should be removed.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":294,"context_line":"    +--------+"},{"line_number":295,"context_line":""},{"line_number":296,"context_line":"  $ mysql -h 172.24.4.199 -u newuser -p newdb"},{"line_number":297,"context_line":"    Enter password:"},{"line_number":298,"context_line":""},{"line_number":299,"context_line":"    Welcome to the MySQL monitor.  Commands end with ; or \\g."},{"line_number":300,"context_line":"    Your MySQL connection id is 24"},{"line_number":301,"context_line":"    Server version: 5.7.25-0ubuntu0.16.04.2 (Ubuntu)"},{"line_number":302,"context_line":""},{"line_number":303,"context_line":"    Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved."},{"line_number":304,"context_line":""},{"line_number":305,"context_line":"    Oracle is a registered trademark of Oracle Corporation and/or its"},{"line_number":306,"context_line":"    affiliates. Other names may be trademarks of their respective"},{"line_number":307,"context_line":"    owners."},{"line_number":308,"context_line":""},{"line_number":309,"context_line":"    Type \u0027help;\u0027 or \u0027\\h\u0027 for help. Type \u0027\\c\u0027 to clear the current input statement."},{"line_number":310,"context_line":""},{"line_number":311,"context_line":"    mysql\u003e ^DBye"},{"line_number":312,"context_line":""},{"line_number":313,"context_line":""},{"line_number":314,"context_line":"  $ openstack database user show access db-instance test"}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_2f014005","line":311,"range":{"start_line":297,"start_character":0,"end_line":311,"end_character":16},"in_reply_to":"9fdfeff1_6ca9c922","updated":"2019-02-22 18:26:34.000000000","message":"Done","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":320,"context_line":"    +--------+"},{"line_number":321,"context_line":""},{"line_number":322,"context_line":"  $ mysql -h 172.24.4.199 -u test -p newdb"},{"line_number":323,"context_line":"    Enter password:"},{"line_number":324,"context_line":""},{"line_number":325,"context_line":"    ERROR 1044 (42000): Access denied for user \u0027test\u0027@\u0027%\u0027 to database \u0027newdb\u0027"},{"line_number":326,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_0c703ddc","line":323,"updated":"2019-02-20 16:26:27.000000000","message":"This output is irrelevant. It should be removed.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":320,"context_line":"    +--------+"},{"line_number":321,"context_line":""},{"line_number":322,"context_line":"  $ mysql -h 172.24.4.199 -u test -p newdb"},{"line_number":323,"context_line":"    Enter password:"},{"line_number":324,"context_line":""},{"line_number":325,"context_line":"    ERROR 1044 (42000): Access denied for user \u0027test\u0027@\u0027%\u0027 to database \u0027newdb\u0027"},{"line_number":326,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_8f114c56","line":323,"in_reply_to":"9fdfeff1_0c703ddc","updated":"2019-02-22 18:26:34.000000000","message":"Done","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":329,"context_line":""},{"line_number":330,"context_line":""},{"line_number":331,"context_line":"  $ mysql -h 172.24.4.199 -u newuser -p newdb"},{"line_number":332,"context_line":"    Enter password:"},{"line_number":333,"context_line":""},{"line_number":334,"context_line":"    ERROR 1044 (42000): Access denied for user \u0027newuser\u0027@\u0027%\u0027 to database \u0027newdb\u0027"},{"line_number":335,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_ac7491d1","line":332,"updated":"2019-02-20 16:26:27.000000000","message":"This output is irrelevant. It should be removed.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":329,"context_line":""},{"line_number":330,"context_line":""},{"line_number":331,"context_line":"  $ mysql -h 172.24.4.199 -u newuser -p newdb"},{"line_number":332,"context_line":"    Enter password:"},{"line_number":333,"context_line":""},{"line_number":334,"context_line":"    ERROR 1044 (42000): Access denied for user \u0027newuser\u0027@\u0027%\u0027 to database \u0027newdb\u0027"},{"line_number":335,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_6f16684c","line":332,"in_reply_to":"9fdfeff1_ac7491d1","updated":"2019-02-22 18:26:34.000000000","message":"As there is no other output I would rather leave it as is.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":337,"context_line":"Delete databases"},{"line_number":338,"context_line":"~~~~~~~~~~~~~~~~"},{"line_number":339,"context_line":""},{"line_number":340,"context_line":"To complete the API, Trove provides API for deleting databases."},{"line_number":341,"context_line":""},{"line_number":342,"context_line":".. code-block:: console"},{"line_number":343,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_8c7bcdbc","line":340,"range":{"start_line":340,"start_character":0,"end_line":340,"end_character":19},"updated":"2019-02-20 16:26:27.000000000","message":"Lastly?","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":337,"context_line":"Delete databases"},{"line_number":338,"context_line":"~~~~~~~~~~~~~~~~"},{"line_number":339,"context_line":""},{"line_number":340,"context_line":"To complete the API, Trove provides API for deleting databases."},{"line_number":341,"context_line":""},{"line_number":342,"context_line":".. code-block:: console"},{"line_number":343,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_0f279cb8","line":340,"range":{"start_line":340,"start_character":0,"end_line":340,"end_character":19},"in_reply_to":"9fdfeff1_8c7bcdbc","updated":"2019-02-22 18:26:34.000000000","message":"Done","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"dfc3d9ae405bbcb3161e189a4482b7ff96a342bd","unresolved":false,"context_lines":[{"line_number":363,"context_line":"    +--------+"},{"line_number":364,"context_line":""},{"line_number":365,"context_line":"  $ mysql -h 172.24.4.199 -u test -p testdb"},{"line_number":366,"context_line":"    Enter password:"},{"line_number":367,"context_line":""},{"line_number":368,"context_line":"    ERROR 1049 (42000): Unknown database \u0027testdb\u0027"}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_2c4ae182","line":366,"updated":"2019-02-20 16:26:27.000000000","message":"This output is irrelevant. It should be removed.","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"9cc6ba7d0cce185a7f0bfca763ee424811a73810","unresolved":false,"context_lines":[{"line_number":363,"context_line":"    +--------+"},{"line_number":364,"context_line":""},{"line_number":365,"context_line":"  $ mysql -h 172.24.4.199 -u test -p testdb"},{"line_number":366,"context_line":"    Enter password:"},{"line_number":367,"context_line":""},{"line_number":368,"context_line":"    ERROR 1049 (42000): Unknown database \u0027testdb\u0027"}],"source_content_type":"text/x-rst","patch_set":3,"id":"9fdfeff1_cf20b49e","line":366,"in_reply_to":"9fdfeff1_2c4ae182","updated":"2019-02-22 18:26:34.000000000","message":"Done","commit_id":"97d72e203bbeebbe218799f13d6830e6fe9008d1"},{"author":{"_account_id":28671,"name":"Marcin Piwowarczyk","email":"m.piwowarczy@samsung.com","username":"m.piwowarczy"},"change_message_id":"4c57ea49704c68483e4002ede5ca5a8f1e8466eb","unresolved":false,"context_lines":[{"line_number":2,"context_line":"Manage databases and users on Trove instances"},{"line_number":3,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":4,"context_line":""},{"line_number":5,"context_line":"Assume that you installed Trove service and upload images with datastore"},{"line_number":6,"context_line":"of your choice."},{"line_number":7,"context_line":"This section shows how to manage users and databases in a MySQL 5.7 instance."},{"line_number":8,"context_line":""}],"source_content_type":"text/x-rst","patch_set":4,"id":"9fdfeff1_6f6bbb1e","line":5,"range":{"start_line":5,"start_character":44,"end_line":5,"end_character":50},"updated":"2019-02-24 08:33:33.000000000","message":"uploaded","commit_id":"097a92fb63bc283f9f6be7a157f9a2d68cb6d46e"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"3a8dc531eb982abe36700556b5a23690d521657d","unresolved":false,"context_lines":[{"line_number":2,"context_line":"Manage databases and users on Trove instances"},{"line_number":3,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":4,"context_line":""},{"line_number":5,"context_line":"Assume that you installed Trove service and upload images with datastore"},{"line_number":6,"context_line":"of your choice."},{"line_number":7,"context_line":"This section shows how to manage users and databases in a MySQL 5.7 instance."},{"line_number":8,"context_line":""}],"source_content_type":"text/x-rst","patch_set":4,"id":"9fdfeff1_6141660a","line":5,"range":{"start_line":5,"start_character":44,"end_line":5,"end_character":50},"in_reply_to":"9fdfeff1_6f6bbb1e","updated":"2019-02-26 15:09:41.000000000","message":"Done","commit_id":"097a92fb63bc283f9f6be7a157f9a2d68cb6d46e"},{"author":{"_account_id":28671,"name":"Marcin Piwowarczyk","email":"m.piwowarczy@samsung.com","username":"m.piwowarczy"},"change_message_id":"4c57ea49704c68483e4002ede5ca5a8f1e8466eb","unresolved":false,"context_lines":[{"line_number":4,"context_line":""},{"line_number":5,"context_line":"Assume that you installed Trove service and upload images with datastore"},{"line_number":6,"context_line":"of your choice."},{"line_number":7,"context_line":"This section shows how to manage users and databases in a MySQL 5.7 instance."},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"Create a Trove instance with database and user"},{"line_number":10,"context_line":"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"}],"source_content_type":"text/x-rst","patch_set":4,"id":"9fdfeff1_efdb2b1e","line":7,"range":{"start_line":7,"start_character":58,"end_line":7,"end_character":67},"updated":"2019-02-24 08:33:33.000000000","message":"The \"Create and access a database\" section shows examples based on MySQL 5.5. Consider sticking to one of them.","commit_id":"097a92fb63bc283f9f6be7a157f9a2d68cb6d46e"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"3a8dc531eb982abe36700556b5a23690d521657d","unresolved":false,"context_lines":[{"line_number":4,"context_line":""},{"line_number":5,"context_line":"Assume that you installed Trove service and upload images with datastore"},{"line_number":6,"context_line":"of your choice."},{"line_number":7,"context_line":"This section shows how to manage users and databases in a MySQL 5.7 instance."},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"Create a Trove instance with database and user"},{"line_number":10,"context_line":"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"}],"source_content_type":"text/x-rst","patch_set":4,"id":"9fdfeff1_61b646fc","line":7,"range":{"start_line":7,"start_character":58,"end_line":7,"end_character":67},"in_reply_to":"9fdfeff1_efdb2b1e","updated":"2019-02-26 15:09:41.000000000","message":"Unfortunately, \"create and access a database\" section was created in the past. mysql 5.7 is available right after devstack installation. I don\u0027t want to say here about previous version. We should update the other section in another change.","commit_id":"097a92fb63bc283f9f6be7a157f9a2d68cb6d46e"},{"author":{"_account_id":28671,"name":"Marcin Piwowarczyk","email":"m.piwowarczy@samsung.com","username":"m.piwowarczy"},"change_message_id":"4c57ea49704c68483e4002ede5ca5a8f1e8466eb","unresolved":false,"context_lines":[{"line_number":13,"context_line":""},{"line_number":14,"context_line":"   When you create a Trove instance, you must specify a Nova flavor."},{"line_number":15,"context_line":"   The flavor indicates computing and storage resources for the instance,"},{"line_number":16,"context_line":"   such as number of CPU cores, RAM and disk size."},{"line_number":17,"context_line":""},{"line_number":18,"context_line":"   Start by listing available flavors."},{"line_number":19,"context_line":""}],"source_content_type":"text/x-rst","patch_set":4,"id":"9fdfeff1_cf366752","line":16,"range":{"start_line":16,"start_character":11,"end_line":16,"end_character":30},"updated":"2019-02-24 08:33:33.000000000","message":"\"number of virtual CPUs\" is more valid :)","commit_id":"097a92fb63bc283f9f6be7a157f9a2d68cb6d46e"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"3a8dc531eb982abe36700556b5a23690d521657d","unresolved":false,"context_lines":[{"line_number":13,"context_line":""},{"line_number":14,"context_line":"   When you create a Trove instance, you must specify a Nova flavor."},{"line_number":15,"context_line":"   The flavor indicates computing and storage resources for the instance,"},{"line_number":16,"context_line":"   such as number of CPU cores, RAM and disk size."},{"line_number":17,"context_line":""},{"line_number":18,"context_line":"   Start by listing available flavors."},{"line_number":19,"context_line":""}],"source_content_type":"text/x-rst","patch_set":4,"id":"9fdfeff1_c1c4d262","line":16,"range":{"start_line":16,"start_character":11,"end_line":16,"end_character":30},"in_reply_to":"9fdfeff1_cf366752","updated":"2019-02-26 15:09:41.000000000","message":"Done","commit_id":"097a92fb63bc283f9f6be7a157f9a2d68cb6d46e"},{"author":{"_account_id":28671,"name":"Marcin Piwowarczyk","email":"m.piwowarczy@samsung.com","username":"m.piwowarczy"},"change_message_id":"4c57ea49704c68483e4002ede5ca5a8f1e8466eb","unresolved":false,"context_lines":[{"line_number":40,"context_line":""},{"line_number":41,"context_line":"   Next, check available datastores and datastore versions:"},{"line_number":42,"context_line":""},{"line_number":43,"context_line":"   .. code-block:: console"},{"line_number":44,"context_line":""},{"line_number":45,"context_line":"      $ openstack datastore list"},{"line_number":46,"context_line":""},{"line_number":47,"context_line":"    +--------------------------------------+------------------+"},{"line_number":48,"context_line":"    | ID                                   | Name             |"},{"line_number":49,"context_line":"    +--------------------------------------+------------------+"},{"line_number":50,"context_line":"    | 90881f3c-b326-4334-9560-8778ae5307a1 | mysql            |"},{"line_number":51,"context_line":"    | d96805c2-6b10-49f9-be5f-66ffa33b4816 | Test_Datastore_1 |"},{"line_number":52,"context_line":"    +--------------------------------------+------------------+"},{"line_number":53,"context_line":""},{"line_number":54,"context_line":"     $ openstack datastore version list mysql"},{"line_number":55,"context_line":""},{"line_number":56,"context_line":"    +--------------------------------------+------------------+"},{"line_number":57,"context_line":"    | ID                                   | Name             |"},{"line_number":58,"context_line":"    +--------------------------------------+------------------+"},{"line_number":59,"context_line":"    | 108ca8f9-97cb-4c20-a8ff-bd67d67e184d | 5.7              |"},{"line_number":60,"context_line":"    | 85a82467-e475-46aa-a84e-df4acdf24af4 | inactive_version |"},{"line_number":61,"context_line":"    +--------------------------------------+------------------+"},{"line_number":62,"context_line":""},{"line_number":63,"context_line":"#. **Create new Trove instance**"},{"line_number":64,"context_line":""}],"source_content_type":"text/x-rst","patch_set":4,"id":"9fdfeff1_af33e361","line":61,"range":{"start_line":43,"start_character":0,"end_line":61,"end_character":63},"updated":"2019-02-24 08:33:33.000000000","message":"There is a little mess with indents in code clocks.\nPlease be consistent with format existing from other rst files.","commit_id":"097a92fb63bc283f9f6be7a157f9a2d68cb6d46e"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"3a8dc531eb982abe36700556b5a23690d521657d","unresolved":false,"context_lines":[{"line_number":40,"context_line":""},{"line_number":41,"context_line":"   Next, check available datastores and datastore versions:"},{"line_number":42,"context_line":""},{"line_number":43,"context_line":"   .. code-block:: console"},{"line_number":44,"context_line":""},{"line_number":45,"context_line":"      $ openstack datastore list"},{"line_number":46,"context_line":""},{"line_number":47,"context_line":"    +--------------------------------------+------------------+"},{"line_number":48,"context_line":"    | ID                                   | Name             |"},{"line_number":49,"context_line":"    +--------------------------------------+------------------+"},{"line_number":50,"context_line":"    | 90881f3c-b326-4334-9560-8778ae5307a1 | mysql            |"},{"line_number":51,"context_line":"    | d96805c2-6b10-49f9-be5f-66ffa33b4816 | Test_Datastore_1 |"},{"line_number":52,"context_line":"    +--------------------------------------+------------------+"},{"line_number":53,"context_line":""},{"line_number":54,"context_line":"     $ openstack datastore version list mysql"},{"line_number":55,"context_line":""},{"line_number":56,"context_line":"    +--------------------------------------+------------------+"},{"line_number":57,"context_line":"    | ID                                   | Name             |"},{"line_number":58,"context_line":"    +--------------------------------------+------------------+"},{"line_number":59,"context_line":"    | 108ca8f9-97cb-4c20-a8ff-bd67d67e184d | 5.7              |"},{"line_number":60,"context_line":"    | 85a82467-e475-46aa-a84e-df4acdf24af4 | inactive_version |"},{"line_number":61,"context_line":"    +--------------------------------------+------------------+"},{"line_number":62,"context_line":""},{"line_number":63,"context_line":"#. **Create new Trove instance**"},{"line_number":64,"context_line":""}],"source_content_type":"text/x-rst","patch_set":4,"id":"9fdfeff1_21911e53","line":61,"range":{"start_line":43,"start_character":0,"end_line":61,"end_character":63},"in_reply_to":"9fdfeff1_af33e361","updated":"2019-02-26 15:09:41.000000000","message":"Done","commit_id":"097a92fb63bc283f9f6be7a157f9a2d68cb6d46e"},{"author":{"_account_id":28671,"name":"Marcin Piwowarczyk","email":"m.piwowarczy@samsung.com","username":"m.piwowarczy"},"change_message_id":"4c57ea49704c68483e4002ede5ca5a8f1e8466eb","unresolved":false,"context_lines":[{"line_number":72,"context_line":""},{"line_number":73,"context_line":"   .. code-block:: console"},{"line_number":74,"context_line":""},{"line_number":75,"context_line":"      # Trove instance create command+"},{"line_number":76,"context_line":"      $ openstack database instance create \u003cinstance_name\u003e \u003cflavor_id_or_name\u003e [options]"},{"line_number":77,"context_line":""},{"line_number":78,"context_line":"   .. code-block:: console"}],"source_content_type":"text/x-rst","patch_set":4,"id":"9fdfeff1_8f385f3b","line":75,"range":{"start_line":75,"start_character":6,"end_line":75,"end_character":38},"updated":"2019-02-24 08:33:33.000000000","message":"This is irrelevant.","commit_id":"097a92fb63bc283f9f6be7a157f9a2d68cb6d46e"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"3a8dc531eb982abe36700556b5a23690d521657d","unresolved":false,"context_lines":[{"line_number":72,"context_line":""},{"line_number":73,"context_line":"   .. code-block:: console"},{"line_number":74,"context_line":""},{"line_number":75,"context_line":"      # Trove instance create command+"},{"line_number":76,"context_line":"      $ openstack database instance create \u003cinstance_name\u003e \u003cflavor_id_or_name\u003e [options]"},{"line_number":77,"context_line":""},{"line_number":78,"context_line":"   .. code-block:: console"}],"source_content_type":"text/x-rst","patch_set":4,"id":"9fdfeff1_219fde50","line":75,"range":{"start_line":75,"start_character":6,"end_line":75,"end_character":38},"in_reply_to":"9fdfeff1_8f385f3b","updated":"2019-02-26 15:09:41.000000000","message":"Done","commit_id":"097a92fb63bc283f9f6be7a157f9a2d68cb6d46e"},{"author":{"_account_id":28671,"name":"Marcin Piwowarczyk","email":"m.piwowarczy@samsung.com","username":"m.piwowarczy"},"change_message_id":"4c57ea49704c68483e4002ede5ca5a8f1e8466eb","unresolved":false,"context_lines":[{"line_number":73,"context_line":"   .. code-block:: console"},{"line_number":74,"context_line":""},{"line_number":75,"context_line":"      # Trove instance create command+"},{"line_number":76,"context_line":"      $ openstack database instance create \u003cinstance_name\u003e \u003cflavor_id_or_name\u003e [options]"},{"line_number":77,"context_line":""},{"line_number":78,"context_line":"   .. code-block:: console"},{"line_number":79,"context_line":""}],"source_content_type":"text/x-rst","patch_set":4,"id":"9fdfeff1_4f4277ad","line":76,"range":{"start_line":76,"start_character":43,"end_line":76,"end_character":78},"updated":"2019-02-24 08:33:33.000000000","message":"Let\u0027s be consistent with names from python-troveclient:\n- name instead of instance_name\n- flavor instead of flavor_id_or_name\n\nhttps://docs.openstack.org/python-troveclient/latest/cli/trove.html#trove-create","commit_id":"097a92fb63bc283f9f6be7a157f9a2d68cb6d46e"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"3a8dc531eb982abe36700556b5a23690d521657d","unresolved":false,"context_lines":[{"line_number":73,"context_line":"   .. code-block:: console"},{"line_number":74,"context_line":""},{"line_number":75,"context_line":"      # Trove instance create command+"},{"line_number":76,"context_line":"      $ openstack database instance create \u003cinstance_name\u003e \u003cflavor_id_or_name\u003e [options]"},{"line_number":77,"context_line":""},{"line_number":78,"context_line":"   .. code-block:: console"},{"line_number":79,"context_line":""}],"source_content_type":"text/x-rst","patch_set":4,"id":"9fdfeff1_41e222d6","line":76,"range":{"start_line":76,"start_character":43,"end_line":76,"end_character":78},"in_reply_to":"9fdfeff1_4f4277ad","updated":"2019-02-26 15:09:41.000000000","message":"Done for the name part. For flavor I would keep it since it accepts both things. python-troveclient has more information thus it can have shorter argument names to not repeat information. We don\u0027t have it here.","commit_id":"097a92fb63bc283f9f6be7a157f9a2d68cb6d46e"},{"author":{"_account_id":28671,"name":"Marcin Piwowarczyk","email":"m.piwowarczy@samsung.com","username":"m.piwowarczy"},"change_message_id":"4c57ea49704c68483e4002ede5ca5a8f1e8466eb","unresolved":false,"context_lines":[{"line_number":129,"context_line":""},{"line_number":130,"context_line":"#. **Connect to the newly created database**"},{"line_number":131,"context_line":""},{"line_number":132,"context_line":"   To connect to a database you need to extract IP address and use standard"},{"line_number":133,"context_line":"   mysql client."},{"line_number":134,"context_line":""},{"line_number":135,"context_line":"   .. code-block:: console"}],"source_content_type":"text/x-rst","patch_set":4,"id":"9fdfeff1_ef124bb4","line":132,"range":{"start_line":132,"start_character":67,"end_line":132,"end_character":75},"updated":"2019-02-24 08:33:33.000000000","message":"native?","commit_id":"097a92fb63bc283f9f6be7a157f9a2d68cb6d46e"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"3a8dc531eb982abe36700556b5a23690d521657d","unresolved":false,"context_lines":[{"line_number":129,"context_line":""},{"line_number":130,"context_line":"#. **Connect to the newly created database**"},{"line_number":131,"context_line":""},{"line_number":132,"context_line":"   To connect to a database you need to extract IP address and use standard"},{"line_number":133,"context_line":"   mysql client."},{"line_number":134,"context_line":""},{"line_number":135,"context_line":"   .. code-block:: console"}],"source_content_type":"text/x-rst","patch_set":4,"id":"9fdfeff1_61e726e5","line":132,"range":{"start_line":132,"start_character":67,"end_line":132,"end_character":75},"in_reply_to":"9fdfeff1_ef124bb4","updated":"2019-02-26 15:09:41.000000000","message":"Done","commit_id":"097a92fb63bc283f9f6be7a157f9a2d68cb6d46e"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"001a242cb4c544d5e481c981c974b3968d6919b7","unresolved":false,"context_lines":[{"line_number":6,"context_line":"of your choice."},{"line_number":7,"context_line":"This section shows how to manage users and databases in a MySQL 5.7 instance."},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"Create a Trove instance with database and user"},{"line_number":10,"context_line":"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"},{"line_number":11,"context_line":""},{"line_number":12,"context_line":"#. **Determine available flavors and datastores**"}],"source_content_type":"text/x-rst","patch_set":5,"id":"5fc1f717_3964f449","line":9,"updated":"2019-03-13 13:26:05.000000000","message":"I found existing documentation on creating and accessing Trove instances [1]. In my opinion we should assume that basics regarding selecting datastore and flavor are already known to the user. This page should focus only on explaining how to manage databases and users on already spawned instances, similarly to how [2] explains managing configuration groups:\n\n\u003e This example assumes you have created a MySQL database and shows you how to use a configuration group to configure it.\n\nI know that you probably spent much time on preparing the first part, however, the content should not be duplicated.\n\n[1] https://docs.openstack.org/trove/latest/user/create-db.html\n[2] https://docs.openstack.org/trove/latest/user/manage-db-config.html","commit_id":"13d6e7b0bb0b7b728d39dba928e6afdc6e3daa8e"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"6cb59ae366804ee877c80b704363fad4efc6cdb4","unresolved":false,"context_lines":[{"line_number":6,"context_line":"of your choice."},{"line_number":7,"context_line":"This section shows how to manage users and databases in a MySQL 5.7 instance."},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"Create a Trove instance with database and user"},{"line_number":10,"context_line":"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"},{"line_number":11,"context_line":""},{"line_number":12,"context_line":"#. **Determine available flavors and datastores**"}],"source_content_type":"text/x-rst","patch_set":5,"id":"5fc1f717_b0664029","line":9,"in_reply_to":"5fc1f717_3964f449","updated":"2019-03-19 20:25:04.000000000","message":"Done","commit_id":"13d6e7b0bb0b7b728d39dba928e6afdc6e3daa8e"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"001a242cb4c544d5e481c981c974b3968d6919b7","unresolved":false,"context_lines":[{"line_number":197,"context_line":""},{"line_number":198,"context_line":".. code-block:: console"},{"line_number":199,"context_line":""},{"line_number":200,"context_line":"  $ openstack database user list db-instance"},{"line_number":201,"context_line":""},{"line_number":202,"context_line":"    +------+------+-----------+"},{"line_number":203,"context_line":"    | Name | Host | Databases |"}],"source_content_type":"text/x-rst","patch_set":5,"id":"5fc1f717_f99c2c0f","line":200,"updated":"2019-03-13 13:26:05.000000000","message":"What would you say to place individual command executions into separate code blocks and introduce short one-line comments for each? That way they would be better organized and easier to read.\n\nBesides, let\u0027s follow the style of other documentation pages [1] which present subsequent guide steps in a numbered list.\n\n[1] https://docs.openstack.org/trove/latest/user/manage-db-config.html","commit_id":"13d6e7b0bb0b7b728d39dba928e6afdc6e3daa8e"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"6cb59ae366804ee877c80b704363fad4efc6cdb4","unresolved":false,"context_lines":[{"line_number":197,"context_line":""},{"line_number":198,"context_line":".. code-block:: console"},{"line_number":199,"context_line":""},{"line_number":200,"context_line":"  $ openstack database user list db-instance"},{"line_number":201,"context_line":""},{"line_number":202,"context_line":"    +------+------+-----------+"},{"line_number":203,"context_line":"    | Name | Host | Databases |"}],"source_content_type":"text/x-rst","patch_set":5,"id":"5fc1f717_70177853","line":200,"in_reply_to":"5fc1f717_f99c2c0f","updated":"2019-03-19 20:25:04.000000000","message":"I would rather not add description of trove CLI here  following your advice about not having duplicated content. Trove python client already have a great description of each command. \nRegarding numbered lists, we don\u0027t have enough content to include additional layer of structure.","commit_id":"13d6e7b0bb0b7b728d39dba928e6afdc6e3daa8e"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"001a242cb4c544d5e481c981c974b3968d6919b7","unresolved":false,"context_lines":[{"line_number":205,"context_line":"    | test | %    | testdb    |"},{"line_number":206,"context_line":"    +------+------+-----------+"},{"line_number":207,"context_line":""},{"line_number":208,"context_line":"  $ openstack database user create db-instance newuser newuser --databases testdb"},{"line_number":209,"context_line":""},{"line_number":210,"context_line":"  $ openstack database user list db-instance"},{"line_number":211,"context_line":""}],"source_content_type":"text/x-rst","patch_set":5,"id":"5fc1f717_997ba8bc","line":208,"range":{"start_line":208,"start_character":55,"end_line":208,"end_character":62},"updated":"2019-03-13 13:26:05.000000000","message":"It is a little bit misleading. \"userpass\" would be a better value.","commit_id":"13d6e7b0bb0b7b728d39dba928e6afdc6e3daa8e"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"6cb59ae366804ee877c80b704363fad4efc6cdb4","unresolved":false,"context_lines":[{"line_number":205,"context_line":"    | test | %    | testdb    |"},{"line_number":206,"context_line":"    +------+------+-----------+"},{"line_number":207,"context_line":""},{"line_number":208,"context_line":"  $ openstack database user create db-instance newuser newuser --databases testdb"},{"line_number":209,"context_line":""},{"line_number":210,"context_line":"  $ openstack database user list db-instance"},{"line_number":211,"context_line":""}],"source_content_type":"text/x-rst","patch_set":5,"id":"5fc1f717_100cf440","line":208,"range":{"start_line":208,"start_character":55,"end_line":208,"end_character":62},"in_reply_to":"5fc1f717_997ba8bc","updated":"2019-03-19 20:25:04.000000000","message":"Done","commit_id":"13d6e7b0bb0b7b728d39dba928e6afdc6e3daa8e"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"001a242cb4c544d5e481c981c974b3968d6919b7","unresolved":false,"context_lines":[{"line_number":218,"context_line":""},{"line_number":219,"context_line":""},{"line_number":220,"context_line":"  $ mysql -h 172.24.4.199 -u newuser -p testdb"},{"line_number":221,"context_line":"    Enter password:"},{"line_number":222,"context_line":""},{"line_number":223,"context_line":"    mysql\u003e show databases;"},{"line_number":224,"context_line":""}],"source_content_type":"text/x-rst","patch_set":5,"id":"5fc1f717_79a91c22","line":221,"range":{"start_line":221,"start_character":0,"end_line":221,"end_character":19},"updated":"2019-03-13 13:26:05.000000000","message":"I still cannot see how this is helpful or necessary? In [1] there is no password prompt presented.\n\n[1] https://docs.openstack.org/trove/latest/user/create-db.html","commit_id":"13d6e7b0bb0b7b728d39dba928e6afdc6e3daa8e"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"6cb59ae366804ee877c80b704363fad4efc6cdb4","unresolved":false,"context_lines":[{"line_number":218,"context_line":""},{"line_number":219,"context_line":""},{"line_number":220,"context_line":"  $ mysql -h 172.24.4.199 -u newuser -p testdb"},{"line_number":221,"context_line":"    Enter password:"},{"line_number":222,"context_line":""},{"line_number":223,"context_line":"    mysql\u003e show databases;"},{"line_number":224,"context_line":""}],"source_content_type":"text/x-rst","patch_set":5,"id":"5fc1f717_0434b5dd","line":221,"range":{"start_line":221,"start_character":0,"end_line":221,"end_character":19},"in_reply_to":"5fc1f717_79a91c22","updated":"2019-03-19 20:25:04.000000000","message":"IMHO it is important to show the user actual output he/she will see.\n\nThe referenced document doesn\u0027t do anything with the client, while we are running some mysql commands.","commit_id":"13d6e7b0bb0b7b728d39dba928e6afdc6e3daa8e"},{"author":{"_account_id":28695,"name":"Bartosz Zurkowski","email":"b.zurkowski@samsung.com","username":"b.zurkowski"},"change_message_id":"001a242cb4c544d5e481c981c974b3968d6919b7","unresolved":false,"context_lines":[{"line_number":282,"context_line":"    | testdb |"},{"line_number":283,"context_line":"    +--------+"},{"line_number":284,"context_line":""},{"line_number":285,"context_line":"  $ mysql -h 172.24.4.199 -u test -p newdb"},{"line_number":286,"context_line":"    Enter password:"},{"line_number":287,"context_line":""},{"line_number":288,"context_line":"    ERROR 1044 (42000): Access denied for user \u0027test\u0027@\u0027%\u0027 to database \u0027newdb\u0027"}],"source_content_type":"text/x-rst","patch_set":5,"id":"5fc1f717_7957dc27","line":285,"range":{"start_line":285,"start_character":13,"end_line":285,"end_character":25},"updated":"2019-03-13 13:26:05.000000000","message":"If we decide to remove the \"create and access DB\" part from this guide we should replace the fixed IP with a placeholder, e.g. IP_ADDRESS same as in [1].\n\n[1] https://docs.openstack.org/trove/latest/user/create-db.html","commit_id":"13d6e7b0bb0b7b728d39dba928e6afdc6e3daa8e"},{"author":{"_account_id":29393,"name":"Dariusz Król","email":"dkrol3@gmail.com","username":"d.krol"},"change_message_id":"6cb59ae366804ee877c80b704363fad4efc6cdb4","unresolved":false,"context_lines":[{"line_number":282,"context_line":"    | testdb |"},{"line_number":283,"context_line":"    +--------+"},{"line_number":284,"context_line":""},{"line_number":285,"context_line":"  $ mysql -h 172.24.4.199 -u test -p newdb"},{"line_number":286,"context_line":"    Enter password:"},{"line_number":287,"context_line":""},{"line_number":288,"context_line":"    ERROR 1044 (42000): Access denied for user \u0027test\u0027@\u0027%\u0027 to database \u0027newdb\u0027"}],"source_content_type":"text/x-rst","patch_set":5,"id":"5fc1f717_c499cdd0","line":285,"range":{"start_line":285,"start_character":13,"end_line":285,"end_character":25},"in_reply_to":"5fc1f717_7957dc27","updated":"2019-03-19 20:25:04.000000000","message":"Done","commit_id":"13d6e7b0bb0b7b728d39dba928e6afdc6e3daa8e"}]}