I have a AIO setup, I have seen this issue yesterday and here is how I got this working.
1) Login into mysql container and login into mysql prompt as root user
2) Run the command "select host from mysql.user where User = 'root';
This will return 3 values - localhost,127.0.0.1 & hostname of your machine
3) When I look into /etc/hosts of my host I did not had the mapping b/w my hostname and ip address of my host
4) Add mapping of host & ip into /etc/hosts
5) Clean up all the containers using the script kolla/tools/cleanup-containers
6) Restart the kolla deploy
I have a AIO setup, I have seen this issue yesterday and here is how I got this working. cleanup- containers
1) Login into mysql container and login into mysql prompt as root user
2) Run the command "select host from mysql.user where User = 'root';
This will return 3 values - localhost,127.0.0.1 & hostname of your machine
3) When I look into /etc/hosts of my host I did not had the mapping b/w my hostname and ip address of my host
4) Add mapping of host & ip into /etc/hosts
5) Clean up all the containers using the script kolla/tools/
6) Restart the kolla deploy
Hope this helps.