MySQL

Learn how to use, install, configure and perform tasks on database-management platform MySQL in these tutorials.

Back Up Your MySQL Databases

Instructions for backing up MySQL databases using various methods.

Configure Master-Master MySQL Database Replication

Learn how to set up master-master MySQL databases replication in this simple step-by-step tutorial.

Connect Metabase with MySQL for Data Exploration

Metabase is a data exploration tool that makes analytics accessible to everyone even without knowledge of SQL. Connect Metabase to a local MySQL server and deploy through a reverse proxy on NGINX using this guide.

Create Physical Backups of your MariaDB or MySQL Databases

Create a physical MySQL backup databases by copying the relevant filesystem parts. Useful for recovering inaccessible databases.

Create an SSH Tunnel for MySQL Remote Access

Execute commands on a remote MySQL server though PuTTY or mysql-client. This guide will teach you how to gain remote access to your MySQL Database using an SSH tunnel.

Creating and Using MySQL Stored Procedures - A Tutorial

Learn how to use MySQL stored procedures, which are user-defined SQL statements that are stored in a MySQL database. Learn the syntax for declaring procedures, create your first example procedure, and then learn how to execute it.

Deploy MySQL Relational Databases on Ubuntu 12.04 (Precise Pangolin)

Get Started with MySQL for Web and Server Applications on Ubuntu 12.04 LTS (Precise Pangolin).

How to Install MySQL on CentOS 6

Getting started with MySQL on CentOS 6

How to Install MySQL on CentOS 7

Getting started with MySQL on CentOS 7

How to Install MySQL on Debian 7

Getting started with MySQL on Debian 7.

How to Install MySQL on Debian 8

Getting started with MySQL on Debian 8

How to Install MySQL with phpMyAdmin on Debian 7

Use phpMyAdmin to manage MySQL databases and users though a web interface.

How to Install MySQL with phpMyAdmin on Ubuntu 12.04

Use phpMyAdmin to manage MySQL databases and users though a web interface.

How to Install MySQL with phpMyAdmin on Ubuntu 14.04

Use phpMyAdmin to manage MySQL databases and users though a web interface.

How to Install and Configure phpMyAdmin on CentOS 6

Use phpMyAdmin to manage MySQL databases and users though a web interface.

How to Install and Configure phpMyAdmin on Debian 8

Use phpMyAdmin to manage MySQL databases and users though a web interface.

How to Optimize MySQL Performance Using MySQLTuner

This step-by-step guide shows you how to assess your MySQL database performance using MySQLTuner to ensure optimum resource usage.

Install MySQL Workbench for Database Administration

MySQL Workbench is a graphical tool for working with MySQL databases in a client/server model. As you explore and manipulate your data using Workbench, you will discover many more features and shortcuts that can make managing your databases easier.

Install MySQL on Ubuntu 14.04

Install MySQL on Ubuntu 14.04. - a getting-started guide.

Install and Configure MySQL Workbench on Ubuntu 16.04

This guide shows how to install and configure MySQL Workbench and includes a sample MySQL database for testing.

Manage MySQL with phpMyAdmin on Debian 5 (Lenny)

Use phpMyAdmin to manage MySQL databases and users though a web interface.

Manage MySQL with phpMyAdmin on Ubuntu 10.10 (Maverick)

Use phpMyAdmin to manage MySQL databases and users though a web interface.

Manage MySQL with phpMyAdmin on Ubuntu 9.10 (Karmic)

Use phpMyAdmin to manage MySQL databases and users though a web interface.

Use MySQL Relational Databases on CentOS 5

Getting started with MySQL for web and server applications on CentOS 5.

Use MySQL Relational Databases on Debian 5 (Lenny)

Getting started with MySQL for web and server applications on Debian Lenny.

Use MySQL Relational Databases on Debian 6 (Squeeze)

Get started with MySQL for web and server applications on Debian 6 (Squeeze).

Use MySQL Relational Databases on Fedora 12

Getting started with MySQL for web and server applications on Fedora 12.

Use MySQL Relational Databases on Fedora 13

Getting started with MySQL for web and server applications on Fedora 13.

Use MySQL Relational Databases on Fedora 14

Getting started with MySQL for web and server applications on Fedora 14.

Use MySQL Relational Databases on Ubuntu 10.04 LTS (Lucid)

Getting started with MySQL for web and server applications on Ubuntu 10.04 LTS (Lucid).

Use MySQL Relational Databases on Ubuntu 10.10 (Maverick)

Getting started with MySQL for web and server applications on Ubuntu 10.10 Maverick

Use MySQL Relational Databases on Ubuntu 8.04 (Hardy)

Getting started with MySQL for web and server applications on Ubuntu Hardy.

Use MySQL Relational Databases on Ubuntu 9.04 (Jaunty)

Getting started with MySQL for web and server applications on Ubuntu Jaunty.

Use MySQL Relational Databases on Ubuntu 9.10 (Karmic)

Getting started with MySQL for web and server applications on Ubuntu 9.10 (Karmic).

Use mysqldump to Back Up MySQL or MariaDB

Use mysqldump to back up MySQL databases, tables, or entire database management systems.

Using MySQL Relational Databases on Arch Linux

Getting started with MySQL for web and server applications on Arch Linux.

Using MySQL Relational Databases on Fedora 20

Getting started with MySQL for web and server applications on Fedora 20.

Using MySQL Relational Databases on Gentoo

Getting started with MySQL for web and server applications on Gentoo.

Working with Triggers in a MySQL Database - A Tutorial

A trigger is a pre-defined SQL command that is automatically executed when specific actions occur in the database. In this guide, we will walk you through the steps of creating and working with triggers in your MySQL database.