Mysql
MySQL installation, configuration, users and permissions, backups, and troubleshooting.
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.

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.

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.

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.

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 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.

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.

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.

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.

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.

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.

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.

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.

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.

How to Install MySQL on Ubuntu 22.04
This article explains how to install and secure MySQL version 8.0 on an Ubuntu 22.04 machine.

How to Install MariaDB on Ubuntu 20.04
MariaDB is an open-source relational database management system. This guide explains how to install and secure MariaDB on Ubuntu 20.04.

How to Install MySQL on Ubuntu 20.04
This guide explains how to install and secure MySQL on Ubuntu 20.04. MySQL is the most popular open-source relational database management system.



