Mysql

MySQL installation, configuration, users and permissions, backups, and troubleshooting.

Jun 3, 2026 • 10 min read

How to Back Up and Restore MySQL Databases with Mysqldump

Step-by-step guide to backing up and restoring MySQL and MariaDB databases using the mysqldump utility. Covers single and full backups, compressed backups, restoring dumps, and automating backups with cron.

MySQL SHOW TABLES command listing database tables

May 22, 2026 • 6 min read

MySQL SHOW TABLES: List Tables in a Database

Use SHOW TABLES to list tables in a MySQL or MariaDB database. This guide covers filtering with LIKE and WHERE, SHOW TABLE STATUS, and querying information_schema.

May 15, 2026 • 3 min read

How to Delete MySQL User Accounts with DROP USER

Delete MySQL or MariaDB user accounts with the DROP USER statement. Covers single and multiple users, IF EXISTS, and session behavior.

May 12, 2026 • 7 min read

How to Install LEMP Stack on Ubuntu 26.04

Set up a LEMP stack on Ubuntu 26.04 with Nginx, MySQL 8.4, PHP 8.5, PHP-FPM, and a working PHP database test.

May 12, 2026 • 7 min read

How to Install LAMP Stack on Ubuntu 26.04

Install Apache, MySQL 8.4, and PHP 8.5 on Ubuntu 26.04, configure an Apache virtual host, and test PHP database access.

Apr 25, 2026 • 7 min read

How to Install MySQL on Ubuntu 26.04

Installing and securing MySQL 8.4 on Ubuntu 26.04. Covers root authentication, creating users, and enabling remote access.

Apr 16, 2026 • 5 min read

How to Create MySQL User Accounts and Grant Privileges

Create MySQL user accounts, grant or revoke privileges, and manage access on MySQL 8 and MariaDB with the commands in this guide.

MySQL user account management and privilege commands

Apr 14, 2026 • 6 min read

How to Reset the MySQL Root Password

Step-by-step instructions for resetting a forgotten MySQL or MariaDB root password on Linux, with modern syntax for MySQL 8.0 and Ubuntu auth_socket notes.

How To Reset Your MySQL or MariaDB Root Password

Apr 13, 2026 • 5 min read

How to Change MySQL User Password

Change a MySQL or MariaDB user password from the mysql shell using ALTER USER. Includes the modern syntax for MySQL 8.0, notes on FLUSH PRIVILEGES, and troubleshooting common errors.

Apr 12, 2026 • 6 min read

How to Show/List Users in MySQL

Query the mysql.user table to list all MySQL user accounts, check their privileges with SHOW GRANTS, and see who is currently connected to the server.

Mar 13, 2026 • 8 min read

How to Allow Remote Connections to MySQL Database Server

Allow remote connections to MySQL or MariaDB by updating bind-address, granting access to a remote user, opening port 3306 in the firewall, and verifying the connection.

Feb 12, 2026 • 4 min read

How to Check the MySQL Version

Several ways to check which MySQL or MariaDB version is running on your system, including the command line, MySQL shell, and PHP.

Feb 12, 2026 • 4 min read

How to Delete a MySQL Database on Linux via Command Line

The DROP DATABASE command permanently removes a MySQL or MariaDB database and all its tables. This guide covers the syntax, safe deletion with IF EXISTS, and using mysqladmin.

Feb 12, 2026 • 7 min read

How to Manage MySQL Databases and Users from the Command Line

A practical reference for managing MySQL databases and user accounts from the command line, covering CREATE, DROP, GRANT, REVOKE, and password changes.

Manage MySQL or MariaDB databases and users

Feb 12, 2026 • 5 min read

How to Show a List of All Databases in MySQL

Step-by-step guide to listing databases in MySQL and MariaDB using SHOW DATABASES, SHOW SCHEMAS, and the information_schema, with filtering and command-line examples.

Jan 30, 2026 • 7 min read

How to Install MySQL on Ubuntu 24.04

Learn how to install, secure, and configure MySQL 8.0 on Ubuntu 24.04. Includes setting up root authentication, creating users, and enabling remote access.

Jan 18, 2026 • 11 min read

How to Use MySQL JOIN to Query Data from Multiple Tables

Learn how to combine data from multiple MySQL tables using JOIN. This guide covers INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, CROSS JOIN, and SELF JOIN with practical examples.