EYouth - Open edX Database Configuration

  • MYSQL

    • Download Dbeaver

    • For windows dbeaver and follow instructions
    • For linux dbeaver and follow instructions
    • install and run dbeaver client Image title
    • Select No from this window Image title
    • Select mySQL Image title
    • From your service provider copy your <DB_Endpoint>,<DB_Useranme> & <DB_PortNumber> Image title
    • Server Host: <DB_Endpoint>
    • Port : <DB_PortNumber>
    • Username : <DB_Useranme> & <DB_PortNumber>
    • Password : Value of MYSQL_ROOT_PASSWORD located in config.yml Config File
    • Select Test connection, then select Download and Finish

  • MongoDB

    • Download Robo3T

    • Robo3T and follow instructions
    • install and run Robo3T client
    • Select Connect & new Connection
    • Select Manually configure Image title
    • Server Tab, Server: <DB_Endpoint> Image title
    • ONLY DO THIS STEP IF YOUR DB IP IS PRIVATE
    • SSH Tab, check Use SSH tunnel to connect
    • SSH Adress : <your_server_public_IPv4>
    • SSH Username : <your_client_id>
    • SSH AuthMode : Password Or Private key
    • If SSH AuthMode : path of example.pem file Image title
    • Select Test connection, then select Ok and Connect