In web development, troubleshooting often involves executing quick queries through the terminal to diagnose issues with our websites or web applications. In this blog post, I’ll guide you through some fundamental MySQL/MariaDB terminal queries that can be invaluable for your debugging efforts. If you haven’t already, I recommend checking out my previous post where I […]
Mysql / Mariadb Basic Terminal Queries Read More »
If you’re new to web development and find yourself navigating database queries through the terminal, this guide will walk you through on how to beautify mysql/mariadb query results for a more readable output. When dealing with numerous fields in your queries, the default terminal display might not present the results in a readable format. In
Beautify mysql/mariadb query results when using terminal Read More »
Logging in to your mysql/mariadb instance in your terminal Where “root” is the user name and -p will prompt you for a password. Enter the password and you will see the terminal like this below. Once you are in the mysql/mariadb you can view the list of databases in your installation. Do take note that
Mysql/Mariadb using terminal Read More »
