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.
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.
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.
A LAMP stack is a set of open source software tools used for web application development. For a web application to work, it has to include an operating system, a web server, a database and, a programming language. Learn how to install and set up LAMP in Ubuntu.
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.
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.
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.
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.
Deploying a functional database in a containerized environment can be a demanding task. This article will show you how to deploy a MySQL database instance on Kubernetes using persistent volumes, the feature that enables stateful apps to overcome the problem of the inherent transience of the K8s pods.
MySQL string functions allow you to manipulate character string data using the SELECT statement. Learn to use MySQL string functions with this comprehensive tutorial.