Day 33 – SQL Queries & Real CRUD Using phpMyAdmin
Feb 17 · 4 min read · By the end of Day 33, students will: Understand SQL language basics Learn CRUD operations Use SELECT, INSERT, UPDATE, DELETE Perform real CRUD using phpMyAdmin Be mentally ready to connect MySQL with Node.js 👉 Today is the most important data...
Join discussionMySQL Tutorial: Everything You Need to Know
May 14, 2025 · 20 min read · Session 1 1. SHOW DATABASES The SHOW DATABASES command is used to display all the available databases present in the MySQL server. Syntax: SHOW DATABASES; Explanation: This will list all the databases created in the MySQL server. It helps in identif...
Join discussion🐬 Ultimate Guide to MySQL – Complete SQL Cheat Sheet & Best Practices
Feb 2, 2025 · 4 min read · 🌱 Introduction to MySQL MySQL is an open-source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL) to manage and manipulate data. It is widely used for web applications, analytics, and enterprise solutions. 📌 W...
Join discussion
Setup your self-hosted MySQL on AWS EC2 Ubuntu
Jan 25, 2025 · 4 min read · Introduction AWS has a MySQL compatible database but it's expensive and sometimes the cost doesn't justify the convenience we get from having such a service for personal projects or projects that don't make money. The alternative solution is to have ...
Join discussionhow to connect mysql with spring boot
Sep 11, 2024 · 1 min read · To connect MySQL with Spring Boot, you'll need to follow these steps: Add MySQL dependencies to your project Configure the database connection Create a simple entity and repository Here's a concise guide: Add dependencies to your pom.xml: <dep...
Join discussion
MySQL Database with MySQL Workbench: A Step-by-Step Guide
Feb 28, 2024 · 3 min read · Today, we're diving into the world of databases, specifically MySQL, using the convenient tool MySQL Workbench. Whether you're new to databases or looking to refresh your skills, this guide will walk you through creating your first database. So let's...
Join discussion
Navigating MySQL Authentication Woes: A Comprehensive Guide to Resolve "Client does not support authentication protocol" Error
Dec 1, 2023 · 3 min read · Introduction: If you’re a web developer, you know that errors are part of the game. Sometimes, they can be easy to solve, but other times, they can be frustrating and confusing. One of the most common and annoying errors that developers face is the “...
Join discussion
6 of 10: Installing MariaDB and MySQL Workbench.
Jul 6, 2023 · 6 min read · Homelab | LXD Manager | Docker | Docker Desktop | Deno | MariaDB | Portainer | More Docker | Docker Swarm | CrowdSec TL;DR. Installing the MariaDB manager in a container on a remote system, setting up MySQL Workbench on a local system, connecting the...
Join discussion