How to fix WARNING ERROR SQL Connection on Failed attempt left

if u have a problem that shown like in below

3006 WARNING oslo_db.sqlalchemy.engines [-] SQL Connection on failed. 10 attempts left.

in openstack, first make sure u did

cp /etc/mysql/my.cnf /etc/mysql/conf.d/mysqld_openstack.cnf

then

nano /etc/mysql/conf.d/mysqld_openstack.cnf

now search the tag [mysqld], if u see the bind address = 127.0.0.1 change it to your ip address

Posted by Muhammad Alan Nur