MySQL

56 Guides Available

Using Vitess on Akamai Cloud: MySQL for Kubernetes

What is Vitess?Vitess is a database clustering system for horizontal scaling of MySQL (and Percona Server for MySQL) through generalized sharding.

Developer’s Guide to the Delete Query in SQL

The DELETE statement allows you to remove a row or rows from a database table using Structured Query Language (SQL).

Install and Configure MySQL on Ubuntu 22.04

How to Install and Configure MySQL on Ubuntu 22.04Most business applications require access to data, which in turn makes it important to know how to install and manage a Database Management System (DBMS).

How to Install MySQL on CentOS 8

How to Install MySQL on CentOS Stream 8Most business applications require access to data, which in turn makes it important to know how to install and manage a Database Management System (DBMS).

SQL Transactions: An Introduction

What are SQL Transactions?A SQL transaction is a grouping of one or more SQL statements that interact with a database.

Connect to a MySQL Database Using the mysql Command

This guide shows you how to connect to a MySQL database using mysql, the MySQL command-line client.

Installing MySQL: A Definitive Guide

MySQL is one of the most popular SQL-based relational databases. The Community Edition is available at no charge and is widely used across the industry.

Securely Store MySQL Credentials with mysql_config_editor

MySQL includes the mysql_config_editor utility, which is used to store your MySQL credentials inside of an encrypted file in your home directory: ~/.

Introduction to SQL Functions

SQL Server, MySQL server, and other commercial database systems offer a host of built-in functions that include mathematical, date, string, and conversion functions.

What Is MySQL: An Overview

What is the MySQL Database?MySQL is an relational database management system (RDBMS) that implements SQL.

Installing and Configuring MySQL on Ubuntu 20.04

Ubuntu users have a choice between two reliable Relational Database Management Systems (RDBMS), MySQL and MariaDB.

List Tables in MySQL and MariaDB

This guide provides the commands you can use to list tables in MySQL and MariaDB. It also includes instructions on how to list tables using MySQL Workbench.

Configure Source-Replica Replication in MySQL

The MySQL is a relational database management system that is one of the most popular open-source projects.

Securing MySQL Server

MySQLMySQL is an open-source relational database management system. This guide will show you how to secure and audit a MySQL server.

Working with MySQL Subqueries"

A subquery is an SQL (Structured Query Language) query that is nested within another SQL query.

Using Views in a MySQL Database

A view in MySQL is a named query that can be triggered to display data stored in other tables.

Working with Triggers in a MySQL Database

A trigger is a pre-defined SQL command that is automatically executed when specific actions occur in the database.

Creating and Using MySQL Stored Procedures

Stored procedures are user-defined SQL statements that are stored in a MySQL database and executed on-demand to perform a specific database operation.

Connect Metabase with MySQL for Data Exploration

What is MetabaseMetabase provides an interface to query data on your browser. In addition to supporting SQL querying, Metabase offers functionality to analyze data without SQL, create dashboards, and track metrics.

Backing Up MySQL Databases Using mysqldump

MySQL (and MariaDB) include the mysqldump utility to simplify the process to create a backup of a database or system of databases.

Create Physical Backups of your MariaDB or MySQL Databases

While the mysqldump tool is the preferred backup method for a MariaDB or MySQL database or database system it only works when the database server is accessible and running.

Install and Configure MySQL Workbench on Ubuntu 16.04

MySQL Workbench is a feature-rich graphical tool used to model data, build SQL queries, manage MySQL servers, and more.

Install MySQL Workbench for Database Administration

This guide will show you how to get started using MySQL Workbench, a graphical tool for working with MySQL databases.

Installing MySQL on CentOS 7

MySQL is a popular database management system used for web and server applications. However, MySQL is no longer in CentOS’s repositories and MariaDB has become the default database system offered.

How to Install MySQL on Debian 8

MySQL is a popular database management system used for web and server applications. This guide will introduce how to install, configure and manage MySQL on a Linode running Debian 8 (Jessie).

How to Optimize MySQL Performance Using MySQLTuner

Running MySQL at optimal settings for specific resources helps handle larger server loads and prevents server slowdown.

Configure Master-Master MySQL Database Replication

What is MySQL Master-Master Replication?MySQL Master-Master replication adds speed and redundancy for active websites. With replication, two separate MySQL servers act as a cluster.

How to Install and Configure phpMyAdmin on CentOS 6

phpMyAdmin is a web application that provides a GUI to aid in MySQL database administration.

Using MySQL Relational Databases on Fedora 20

MySQL is a popular database management system, used as the data storage provider for thousands of web and server applications.

How to Install MySQL on CentOS 6

MySQL is a popular database management system used for web and server applications. This guide will introduce how to install, configure and manage MySQL on a Linode running CentOS 6.

How to Install MySQL on Debian 7

MySQL is a popular database management system used for web and server applications. This guide will introduce how to install, configure and manage MySQL on a Linode running Debian 7 (Wheezy).

How to Install and Configure phpMyAdmin on Debian 8

phpMyAdmin is a web application that provides a GUI to aid in MySQL database administration. It supports multiple MySQL servers and is a robust and easy alternative to using the MySQL command line client.

How to Install MySQL with phpMyAdmin on Debian 7

phpMyAdmin is a web application that provides a GUI to aid in MySQL database administration.

How to Install MySQL with phpMyAdmin on Ubuntu 12.04

How to Install MySQL with phpMyAdmin on Ubuntu 14.04

phpMyAdmin is a web application that provides a GUI to aid in MySQL database administration.

Deploy MySQL Relational Databases on Ubuntu 12.04

MySQL is a popular database management system used for web and server applications. This guide will introduce how to install, configure and manage MySQL on a Linode running Ubuntu 12.

Install MySQL on Ubuntu 14.04

MySQL is a popular database management system used for web and server applications. This guide will introduce how to install, configure and manage MySQL on a Linode running Ubuntu 14.

Using MySQL Relational Databases on Arch Linux

MySQL is a popular database management system, used as the data storage provider for thousands of web and server applications.

Use MySQL Relational Databases on Debian 6 (Squeeze)

MySQL is a popular database management system, used as the data storage provider for thousands of web and server applications.

Using MySQL Relational Databases on Gentoo

MySQL is a relational database management system (RDBMS) that is used as a backend for countless web and server applications.

Manage MySQL with phpMyAdmin on Ubuntu 10.10 (Maverick)

phpMyAdmin is an open source web application written in PHP that provides a GUI to aid in MySQL database administration.

Use MySQL Relational Databases on Fedora 14

MySQL is a popular database management system, used as the data storage provider for thousands of web and server applications.

Use MySQL Relational Databases on Ubuntu 10.10 (Maverick)

MySQL is a popular database management system, used as the data storage provider for thousands of web and server applications.

Use MySQL Relational Databases on Fedora 13

MySQL is a popular database management system, used as the data storage provider for thousands of web and server applications.

Use MySQL Relational Databases on Ubuntu 10.04

MySQL is a popular database management system, used as the data storage provider for thousands of web and server applications.

Back Up Your MySQL Databases

MySQL is an open source relational database management system (DBMS) which is frequently deployed in a wide assortment of contexts.

Manage MySQL with phpMyAdmin on Ubuntu 9.10 (Karmic)

phpMyAdmin is an open source web application written in PHP that provides a GUI to aid in MySQL database administration.

Manage MySQL with phpMyAdmin on Debian 5 (Lenny)

phpMyAdmin is an open source web application written in PHP that provides a GUI to aid in MySQL database administration.

Create an SSH Tunnel for MySQL Remote Access

This guide will show you how to make a secure connection to your remote MySQL or MariaDB server from your local computer, using an SSH tunnel.

Use MySQL Relational Databases on Ubuntu 9.10 (Karmic)

MySQL is a popular database management system, used as the data storage provider for thousands of web and server applications.

Standalone MySQL Server

In some kinds of deployments, particularly where rich dynamic applications rely on a large database, separating the database server from the application server can permit your application to scale and accommodate a much larger user base.