Ask Your Question
5

What is the MYSQL default credential for Mirantis openstack?

asked 2014-12-18 23:52:26 -0500

Venkatesh subramanian gravatar image

We installed Mirantis Juno openstack on Centos 6.5. After the installation we could not login to mysql database with credential root / password.

edit retag flag offensive close merge delete

3 answers

Sort by ยป oldest newest most voted
2

answered 2015-07-06 19:08:46 -0500

Hi Venkatesh, login as the mysql's root from root system user on any controller without any password:

root@node-1:~# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 53528
Server version: 5.6.16-2~u14.04+mos2-log (Ubuntu), wsrep_25.5.rXXXX

Copyright (c) 2000, 2014, 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>

If you want to login as a user (OpenStack service), search the password in the configuration file, like /etc/keystone/keystone.conf:

root@node-1:~# cat /etc/keystone/keystone.conf | egrep ^connection
connection=mysql://keystone:BEz17Vos@192.168.0.2/keystone?read_timeout=60

root@node-1:~# mysql -u keystone -p
Enter password: [BEz17Vos]
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 53547
Server version: 5.6.16-2~u14.04+mos2-log (Ubuntu), wsrep_25.5.rXXXX

Copyright (c) 2000, 2014, 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.01 sec)

mysql>
edit flag offensive delete link more
1

answered 2015-07-08 09:24:00 -0500

Jet gravatar image

updated 2015-07-08 09:24:52 -0500

You can find the password in

 /etc/mysql/conf.d/password.cnf

on any of the controllers

edit flag offensive delete link more
0

answered 2015-07-05 22:45:57 -0500

fifieldt gravatar image

From https://docs.mirantis.com/openstack/f... it looks like it is set in a YAML config file.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2014-12-18 23:52:26 -0500

Seen: 4,255 times

Last updated: Jul 08 '15