Neil
Neil
Treat your password like your toothbrush. Don’t let anybody else use it, and get a new one every six months.

MySql Contains Podman

- Advertisement -

Introduction

MySQL contains is a prominent open-source relational database administration system and one of the popular web server solutions. It stores and structures data in a meaningful and ensures easy accessibility. A container image is maintained by the community.

Podman is a set of platform-as-a-service developments that support CI/CD development. It allows to develop and deploys applications inside virtual environments, called containers. Podman boots up an application with all its libraries and dependencies with a single image.

Installing podman

With podman tutorial steps previously published.

Pull 5.7 from repository

Podman checks multiple container repo so this may take a while. In this tutorial, we will use docker.io/library/mysql:5.7 since this is always available. First of all, let’s explore the containers that are available for Red Hat Enterprise Linux through the Red Hat Container Catalog (access.redhat.com/containers):

# podman pull mysql:5.7

Check mysql contains podman

So, use command podman images

# podman images

MySQL Database Instance in a Container

With all requirements met, we can create a MySQL database instance. The key Environment Variables available when running a MySQL Container are:

  • MYSQL_ROOT_PASSWORD: This variable is mandatory and specifies the password set for the MySQL root superuser account.
  • MYSQL_DATABASE: This is optional and allows you to specify the name of a database created on image startup.
  • MYSQL_USERMYSQL_PASSWORD: Optional and used in conjunction to create a user and to set that password.

Alternative to passing sensitive information via environment variables, _FILE may be appended to the previously listed environment variables, causing the initialization script to load the values for those variables from files present in the container.

Create the container mysql contains podman

Then, follow command as follows.

# podman run -d \
> --name mysql-5.7 \
> -p 3306:3306 \
> -v ~/mysql_data:/var/lib/mysql \
> -e MYSQL_ROOT_PASSWORD='UnixC0p.comStr0ngPass' \
> -e MYSQL_USER=unixcopdb \
> -e MYSQL_PASSWORD='unixcopdbStr0ngPass' \
> -e MYSQL_DATABASE=UnixCopDB \
> mysql:5.7
195813fd41166f2d1da893b567cb4780a075293f7231783efc95ac30a7ac0532

Then, validate the podman process if running.

Test the container if working.

# podman exec -it mysql-5.7 /bin/bash
# mysql -uroot -p'UnixC0p.comStr0ngPass'

List the databases created

So, interactive prompt to list created databases.

- Advertisement -

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest articles

Join us on Facebook

x