OpenStack components like Nova uses MariaDB to store data. This article expains how to find the login info for MariaDB.
The connection to MariaDB is specified in the configuration file for related OpenStack components. Check the .conf file as below:
user@tesABC:~# cat /etc/keystone/keystone.conf | grep mysql connection = mysql:// keystone:c0ntrail123 @127.0.0.1/keystone # by the server configuration, set this to no value. Example: mysql_sql_mode= #mysql_sql_mode = TRADITIONAL user@testABC:~# cat /etc/nova/nova.conf | grep mysql connection = mysql:// nova:c0ntrail123 @127.0.0.1/nova connection = mysql://nova:[email protected]/nova_api
The username and password in the configuration file can help us to log into MariaDB as shown below:
user@testABC:~# mysql -u keystone -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 127222 Server version: 5.5.37 MySQL Community Server (GPL), wsrep_25.10.r3990 Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | keystone | | test | +--------------------+ 3 rows in set (0.00 sec) mysql> quit Bye user@testABC:~# mysql -u nova -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 127223 Server version: 5.5.37 MySQL Community Server (GPL), wsrep_25.10.r3990 Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | nova | | nova_api | | test | +--------------------+ 4 rows in set (0.00 sec) mysql> quit Bye