Database
Accessing the Database
In this section, we are going to do some exercises to use MySQL client to access the databases we created from previous sections. The database name is tutorial_cli and hopefully you’ve remembered the password.
Installation
You should install the MySQL Client for your platform. MySQL provide a getting started guide if you’re unsure, but for those running on Ubuntu, it can be as simple as:
sudo apt update
sudo apt install mysql-client
Connect to database
Before we can connect to the database, we need to find out the host name of the database instance. Use the command openstack database instance list and openstack database instance show <id>.
$ openstack database instance list
+--------------------------------------+----------------------+-----------+-------------------+--------+--------------------------------------+------+-----------+
| ID | Name | Datastore | Datastore Version | Status | Flavor ID | Size | Region |
+--------------------------------------+----------------------+-----------+-------------------+--------+--------------------------------------+------+-----------+
| 5de589ae-195e-4859-ae6f-8bd014094bd3 | tutorial | MySQL | 8.0-12 | ACTIVE | 325c919d-b523-4960-968c-f2baffafff94 | 10 | Melbourne |
| 7f465a9e-92ec-48d7-81a2-85264e7b5c95 | my-database-instance | MySQL | 8.0-17 | ACTIVE | 325c919d-b523-4960-968c-f2baffafff94 | 1 | Melbourne |
+--------------------------------------+----------------------+-----------+-------------------+--------+--------------------------------------+------+-----------+
$ openstack database instance show 5de589ae-195e-4859-ae6f-8bd014094bd3
+-------------------+--------------------------------------+
| Property | Value |
+-------------------+--------------------------------------+
| configuration | 013aec9f-2d9e-495e-98a1-36d9cdebf1be |
| created | 2020-03-25T05:41:46 |
| datastore | MySQL |
| datastore_version | 8.0-12 |
| flavor | 325c919d-b523-4960-968c-f2baffafff94 |
| hostname | gk5sdnjwfry.db.cloud.edu.au |
| id | 5de589ae-195e-4859-ae6f-8bd014094bd3 |
| name | tutorial |
| region | Melbourne |
| status | ACTIVE |
| updated | 2020-03-26T02:20:00 |
| volume | 10 |
| volume_used | 0.14 |
+-------------------+--------------------------------------+
Login to the database
mysql -u tutorial_cli_user -p -h gk5sdnjwfry.db.cloud.edu.au
After entering the password you are connected to the database instance.
Show databases and use database
Use the below commands to use tutorial_cli database.
mysql>SHOW DATABASES;
mysql>Use tutorial_cli;
mysql>SHOW TABLES;
To find out more about the mysql client, you could try the MySQL official tutorial.