This is my first time installing openstack manually and after follwing all step of guides, when i try to create a domain, i get this error:

An unexpected error prevented the server from fulfilling your request. (HTTP 500) (Request-ID: req-eea2a822-5805-4f8d-a3be-adc29755d070)

After going through the log file, i saw this

2018-07-08 23:54:01.276 2763 ERROR keystone.common.wsgi     sql_connection=sql_connection, **engine_kwargs)
2018-07-08 23:54:01.276 2763 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/debtcollector/renames.py", line 43, in decorator
2018-07-08 23:54:01.276 2763 ERROR keystone.common.wsgi     return wrapped(*args, **kwargs)
2018-07-08 23:54:01.276 2763 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 184, in create_engine
2018-07-08 23:54:01.276 2763 ERROR keystone.common.wsgi     test_conn = _test_connection(engine, max_retries, retry_interval)
2018-07-08 23:54:01.276 2763 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 370, in _test_connection
2018-07-08 23:54:01.276 2763 ERROR keystone.common.wsgi     six.reraise(type(de_ref), de_ref)
2018-07-08 23:54:01.276 2763 ERROR keystone.common.wsgi   File "<string>", line 2, in reraise
2018-07-08 23:54:01.276 2763 ERROR keystone.common.wsgi DBConnectionError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'localhost' ([Errno 111] Connection refused)") (Background on this error at: http://sqlalche.me/e/e3q8)
2018-07-08 23:54:01.276 2763 ERROR keystone.common.wsgi

The firewalld and Network Manager is off, i can ping my controller and when i ran netstat, the port was on listenning, what should i do?