MySQL

PostgreSQL Vs MySQL: A Detailed Comparison

March 30, 2023

Explore the differences between the two most widely used database management systems. PostgreSQL and MySQL are both excellent database solutions, and well suited for most workloads. However, small differences can result in less than optimal performance. Learn all about them by reading this article.

Read more

How to Start, Stop, and Restart MySQL Server

March 23, 2023

With MySQL, users can store and manage data in a customized, structured format. This tutorial explains how to start, stop, or restart the MySQL server.

Read more

How to Uninstall MySQL in Linux, Windows, and macOS

March 3, 2023

Uninstalling MySQL can sometimes be the solution for dealing with bugs, or when you need to shift back to an older version. This tutorial shows how to uninstall MySQL on Windows, Linux, and macOS.

Read more

How To Show a List of All Databases in MySQL

October 13, 2022

With Structured Query Language (SQL), you can easily access and manage content in all your databases. This guide will show you how to list all MySQL Databases.

Read more

Database Relationship Types & How They Are Established

July 11, 2022

Database relationships are an important concept in database modeling. Learn about the different relationship types and how they are created in this article.

Read more

Install and Get Started with MySQL Workbench on Ubuntu

February 24, 2022

Workbench is a visual tool for managing MySQL databases . Its graphical interface allows administrators and database architects to model data, build and run SQL queries, and maintain a database. Get a better understanding on how Workbench works, how to install the software and configure it for your needs.

Read more

How to Use MySQL SHOW TRIGGERS

February 1, 2022

The SHOW TRIGGERS statement in MySQL helps provide a detailed overview of created triggers in a database. Learn how to use the statement effectively in this guide.

Read more

mysql_secure_installation Script

January 6, 2022

The mysql_secure_installation script allows you to significantly improve MySQL server security. Follow this guide to learn more about the script and the options it accepts.

Read more

MySQL Show User Privileges

October 1, 2021

The best practice in MySQL is to have separate users with minimal permissions needed to work. Learn how to check which permissions each user currently has in this simple guide.

Read more

How to Check MySQL Database and Table Size

September 29, 2021

Databases and tables that reside in them grow in size. Follow this tutorial to see three different methods to check the size for a single table, database, all tables and all databases.

Read more
1 2 3 6