Connecting to the MySQL Docker Container - dare

(STEP 3) PROJECT 1: LAMP STACK IMPLEMENTATION

WEB STACK IMPLEMENTATION (LAMP STACK) IN AWS

Step 1 — Installing Apache and Updating the Firewall

Step 2 — Installing MySQL

Step 3 — Installing PHP

Step 4 — Creating a Virtual Host for your Website using Apache

Step 5 — Enable PHP on the website

(STEP 4) PROJECT 2: LEMP STACK IMPLEMENTATION

WEB STACK IMPLEMENTATION (LEMP STACK)

Step 1 – Installing the Nginx Web Server

Step 2 — Installing MySQL

Step 3 – Installing PHP

Step 4 — Configuring Nginx to Use PHP Processor

Step 5 – Testing PHP with Nginx

Step 6 – Retrieving data from MySQL database with PHP (continued)

(STEP 5) PROJECT 3: MERN STACK IMPLEMENTATION

Simple To-Do application on MERN Web Stack

Step 1 – Backend Configuration

Install ExpressJS

Models

MongoDB Database

Step 2 – Frontend creation

Frontend Creation (continued)

(STEP 10) PROJECT 4: MEAN STACK IMPLEMENTATION

MEAN Stack Deployment to Ubuntu in AWS

Install Express and set up routes to the server

(STEP 11) Aux Project 1 (Shell Scripting)

Aux Project 1: Shell Scripting

(STEP 12) PROJECT 5: Client/Server Architecture Using A MySQL Relational Database Management System

Client-Server Architecture with MySQL

Implement a Client Server Architecture using MySQL Database Management System (DBMS).

(STEP 14) PROJECT 6: Web Solution With WordPress

Web Solution With WordPress

Launch an EC2 instance that will serve as “Web Server”.

update the `/etc/fstab` file

(STEP 17) PROJECT 7: Devops Tooling Website Solution

Devops Tooling Website Solution

Step 1 – Prepare NFS Server

Step 2 — Configure the database server

(STEP 18) PROJECT 8: Load Balancer Solution With Apache

Load Balancer Solution With Apache

Configure Apache As A Load Balancer

(STEP 19) PROJECT 9: Continous Integration Pipeline For Tooling Website

Tooling Website deployment automation with Continuous Integration. Introduction to Jenkins

Install and Configure Jenkins server

Configure Jenkins to copy files to NFS server via SSH

(STEP 20) PROJECT 10: Load Balancer Solution With Nginx and SSL/TLS

Load Balancer Solution With Nginx and SSL/TLS

Configure Nginx As A Load Balancer

Register a new domain name and configure secured connection using SSL/TLS certificates

(STEP 21) PROJECT 11: Ansible – Automate Project 7 to 10

Ansible Configuration Management – Automate Project 7 to 10

Install and configure Ansible on EC2 Instance

Begin Ansible Development

Create a Common Playbook

Run first Ansible test

(STEP 22) Project 12 Ansible Refactoring, Assignments & Imports

Ansible Refactoring and Static Assignments (Imports and Roles)

Refactor Ansible code by importing other playbooks into site.yml

Configure UAT Webservers with a role ‘Webserver’

Reference Webserver role

(STEP 23) Project 13 Ansible Dynamic Assignments (Include) and Community Roles

Ansible Dynamic Assignments (Include) and Community Roles

Introducing Dynamic Assignment Into Our structure

Update site.yml with dynamic assignments

Load Balancer roles

(STEP 24) Project 14 Experience Continuous Integration With Jenkins | Ansible | Artifactory | Sonarqube | PHP

Experience Continuous Integration with Jenkins | Ansible | Artifactory | SonarQube | PHP

Why are we doing everything we are doing? – 13 DevOps Success Metrics

Simulating a typical CI/CD Pipeline for a PHP Based application

Ansible Roles for CI Environment

Running Ansible Playbook from Jenkins

CI/CD Pipeline for TODO application

SonarQube Installation

Configure SonarQube

Configure SonarQube and Jenkins For Quality Gate

(STEP 26) Project 15 AWS Cloud Solution For 2 Company Websites Using A Reverse Proxy Technology

AWS Cloud Solution For 2 Company Websites Using A Reverse Proxy Technology

Set Up a Virtual Private Network (VPC)

Configure Application Load Balancer (ALB)

(STEP 28) Project 16 Automate Infrastructure With IAC using Terraform Part 1

Automate Infrastructure With IaC using Terraform Part 1

VPC | Subnets | Security Groups

Fixing The Problems By Code Refactoring

Introducing variables.tf & terraform.tfvars

(STEP 29) Project 17 Automate Infrastructure With IAC using Terraform Part 2

Automate Infrastructure With IaC using Terraform. Part 2

AWS routes

Create Security Groups

Create Certificate From Amazon Cerificate Manager

Creating Austoaling Groups

Storage and Database

(STEP 30) PROJECT 18 : Automate Infrastructure With IaC using Terraform-Part 3

Automate Infrastructure With IaC using Terraform. Part 3 – Refactoring

When to use Workspaces or Directory?

Refactor your project using Modules

Complete the Terraform configuration

(STEP 33) PROJECT 19: Automate Infrastructure With IaC using Terraform. Part 4 - Terraform Cloud

Automate Infrastructure With IaC using Terraform. Part 4 – Terraform Cloud

(STEP 34) PROJECT 20: Migration to the Сloud with containerization. Part 1 - Docker & Docker Compose

Migration to the Сloud with containerization. Part 1 – Docker & Docker Compose

Connecting to the MySQL Docker Container

Practice Task

(STEP 35) PROJECT 21: Orchestrating containers across multiple Virtual Servers with Kubernetes. Part 1

Orchestrating containers across multiple Virtual Servers with Kubernetes. Part 1

Kubernetes architecture

Step 0-Install client tools before bootstrapping the cluster.

AWS Cloud resources for Kubernetes Cluster

Security Groups

Step 2 – Create Compute Resources

Step 3 Prepare The Self-Signed Certificate Authority And Generate TLS Certificates

Step 4 – Distributing the Client and Server Certificates

Step 5 Use `kubectl` to Generate Kubernetes Configuration Files for Authentication

Step 6 Prepare the etcd database for encryption at rest.

Bootstrap the Control Plane

Test that Everything is working fine

Configuring the Kubernetes Worker nodes

Quick Overview Of Kubernetes Network Policy And How It Is Implemented

Configure the worker nodes components

Final Steps

(STEP 36): PROJECT 22: Deploying Applications Into Kubernetes Cluster

Deploying Applications Into Kubernetes Cluster

Understanding the concept

Common Kubernetes objects

Accessing the app from the browser

Create a Replica set

Using AWS Load Balancer to access your service in Kubernetes.

Using Deployment Controllers

Persisting Data for Pods

(STEP 37): PROJECT 23: Persisting Data in Kubernetes

Persisting Data in Kubernetes

Managing Volumes Dynamically with PVs and PVCs

ConfigMap

(STEP 38): PROJECT 24: Building Elastic Kubernetes Service (EKS) With Terraform

Building Elastic Kubernetes Service (EKS) With Terraform

Building Elastic Kubernetes Service (EKS) With Terraform – Part 2

Fixing the Error

Deploy applications with Helm

Deploy Jenkins with Helm

Quick task for you

(STEP 39): PROJECT 25: Deploying and Packaging applications into Kubernetes

Configuring Ingress for TLS

Deploying Cert-Manager and managing TLS/SSL for Ingress

Deploying Ingress Controller and managing Ingress Resources

Deploying and Packaging applications into Kubernetes with Helm

(STEP 40): PROJECT 26: RESERVED FOR MASTER CLASS

Setting up private repositories and Preparing CI pipelines with Jenkins

(STEP 41): PROJECT 27: RESERVED FOR MASTER CLASS

PROJECT 27

(STEP 42): PROJECT 28: RESERVED FOR MASTER CLASS

PROJECT 28

(STEP 43): PROJECT 29: RESERVED FOR MASTER CLASS

PROJECT 29

(STEP 48): PROJECT 30: RESERVED FOR MASTER CLASS

PROJECT 30

Projects

Connecting to the MySQL Docker Container

Step 3: Connecting to the MySQL Docker Container

We can either connect directly to the container running the MySQL server or use a second container as a MySQL client. Let us see what the first option looks like.

Approach 1

Connecting directly to the container running the MySQL server:

$ docker exec -it mysql bash

or

$ docker exec -it mysql mysql -uroot -p

Provide the root password when prompted. With that, you’ve connected the MySQL client to the server.

Finally, change the server root password to protect ...
Learn More

Master Class

First Name

Last Name

Email

Phone Number

Country

Master Class

First Name

Last Name

Email

Phone Number

Country