Ask Your Question

mysqlworkbench settings for openstack nova database port

asked 2017-08-30 09:20:13 -0600

nubber gravatar image

What would be the port I should be using if I were to connect to openstack DB's (nova, neutron,nova_api etc) via mysqlbench? I understand I can use "mysql -u root -p" but would like to know the settings using mysqlwork bench.

image description

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted

answered 2017-08-30 15:20:35 -0600

You could connect using:

  • IP address of your MySQL server as hostname
  • default port (3306) if you never changed it
  • your username and password

Please remember that if connecting from a remote host you must be sure you have a user allowed to connect from remote hosts (e.g. MariaDB [(none)]> GRANT ALL PRIVILEGES ON nova.* TO 'nova'@'%' IDENTIFIED BY 'NOVA_DBPASS';) and not only from localhost.

edit flag offensive delete link more


Thank you.; username:nova and password what ever is used for NOVA_DBPASS

nubber gravatar imagenubber ( 2017-08-30 17:13:03 -0600 )edit

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower


Asked: 2017-08-30 09:20:13 -0600

Seen: 264 times

Last updated: Aug 30 '17