Search for a command to run...
As an experienced cybersecurity professional with a full-stack development and software engineering background, I am committed to building secure and reliable software solutions. I am passionate about leveraging my expertise in Python, React.js, Django, and other technologies to design and develop cutting-edge applications that meet the highest security and functionality standards.
It was very good, it helped.
Background API keys, also known as application programming interface keys, are codes or tokens used to authenticate and authorize access to an API (Application Programming Interface). The API provider typically issues API keys to developers who need ...
The Problem Phishing remains one of the top methods for a malicious actor to gain access to a target environment. A vital component of a realistic phishing campaign is a familiar-looking domain address. Using a technique known as "domain squatting," ...
Situation You have an API built with Django Rest Framework You are using SimpleJWT as your authentication backend You have integrated Celery with your Django application and are using it to run background tasks Some of your tasks need to make authen...
Development is hard. One of the challenges newcomers face when learning a programming language is the knowledge gap between them and the people they learn from. This becomes particularly apparent when a beginner is introduced to a high-level program...
Recently, I've been asked by several people about my journey into the field of Information Security. Most of the time, it seems that those that ask are looking for a tip or piece of information that they do not already have--some sort of secret to un...
Your development environment is a Linux distribution made available on Windows through Windows Subsystem For Linux 2 (WSL2). You need to stand up a MySQL (or other) database that is persistent, available to your WSL2-enabled development environment, and accessible to database management systems (DBMS) natively installed on your Windows host.
We can containerize a MySQL (or other) database. I accomplished this using docker-compose, but you can probably easily modify this to run from a standalone Dockerfile if you wish.
version: "3.9"
services:
mysql-dev:
image: mysql
command: --default-authentication-plugin=mysql_native_password
restart: always
environment:
MYSQL_ROOT_PASSWORD: my-secret-pw
ports:
- "3306:3306"
volumes:
- ./data:/var/lib/mysql
This should be saved in the directory that you intend to execute docker-compose from. Then, from the terminal, run:
$ docker-compose up --build -d
mysql-dev using the mysql (latest tag implied) image hosted on the official mysql Docker hub registry.--default-authentication-plugin=mysql_native_password. According to the MySQL 8.0 documentation, mysql_native_password is a plugin that implements authentication based on the password hashing method in use from before the introduction of plugable authentication.MYSQL_ROOT_PASSWORD in the environmental variables of the container. Since this is for development, the password doesn't really matter. Please do not use this password in production!./data, as a volume to the container's default MySQL data directory, /var/lib/mysql. This allows us to persist the data created in the database even if the container is destroyed.docker-compose up --build -d will run the container in "detached" mode--that is, it will be run as a background process and you will still have access to your teminal. You can validate that the container is running by using docker ps. localhost:3306 as our address.ip a show eth0 (your interface may vary--if you receive no results, simply do ip a to show all interfaces).I found it challenging to connect to a Windows MySQL instance from WSL2, which is why I researched the methodology shown above. I personally like the container approach because it can allow me to easily migrate the database in the future and it is portable in the event that I decide to develop from a different workstation.
Note: I used MySQL for this exercise, but perhaps you could achieve similar results with another database. Docker Hub supports images for most databases--find the system you prefer, read the documentation on the image, and apply the steps shown above to (hopefully) create a portable, persistent, development database.