Team City MySql Setup

connect to docker container bash :
  docker exec -it teamcity_mysql_1 bash
  
access mysql shell:
  mysql -p<password> 
  Note: -p<password> is not a typo and it supposed to be like this
  
execute below commands on mysql shell :
  
  create database teamcity_01 collate utf8_bin;
  create user admin identified by 'admin';
  grant all privileges on teamcity_01.* to admin;
  grant process on *.* to admin;
to test if we did everything fine :
  show databases;
  
  it should display below result 
  +--------------------+
  | Database           |
  +--------------------+
  | information_schema |
  | mysql              |
  | performance_schema |
  | sys                |
  | teamcity_01        |
  +--------------------+
  
  Setup MySQL Server 
  ---------------------
  1. go to mysql container bash again 
    docker exec -it teamcity_mysql_1 bash
    
  2. apt-get update
  3. apt-get install wget
  4. wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.46.tar.gz