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. Sharding allows you to break up your database into partitions, which lets the sharded database store more data and offer higher performance.

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). This guide explains the DELETE statement, ways to use it, and what can make a DELETE statement fail.

Install and Configure MySQL on Ubuntu 22.04

How to Install and Configure MySQL on Ubuntu 22.04

Most business applications require access to data, which in turn makes it important to know how to install and manage a Database Management System (DBMS). There are different types of DBMS, but the most popular is the Relational DBMS (RDBMS) which is based on Structured Query Language (SQL). One of the most popular RDBMS is MySQL. This guide explains how to download, and install MySQL Ubuntu 22.04, and set up important configurations.

How to Install MySQL on CentOS 8

How to Install MySQL on CentOS Stream 8

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. A transaction in its entirety can commit to a database as a single logical unit or rollback (become undone) as a single logical unit. In SQL, transactions are essential for maintaining database integrity. They are used to preserve integrity when multiple related operations are executed concurrently, or when multiple users interact with a database concurrently.

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. This opens up a simple SQL shell environment, allowing you to perform SQL queries and commands on your database. If you require more advanced capabilities, consider using the MySQL Shell.

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. This guide walks you through installing and updating MySQL Community on Windows, macOS, and Linux (either through the native repositories or MySQL’s own repositories).

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: ~/.mylogin.cnf. The file is obfuscated and cannot be viewed in plaintext unless running the print command. Any stored passwords are never made visible. This arrangement adds a layer of security and convenience when connecting to your database using command-line tools like mysql or mysqldump.

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. These functions can be used for both processing and manipulating data within the server environments. These inherent functions provide valuable enhancements/extensions to the SQL language and are useful programmatic utilities that are available to a SQL developer.

What Is MySQL: An Overview

What is the MySQL Database?

MySQL is an relational database management system (RDBMS) that implements SQL. It was originally designed for use with small-to-medium-sized databases, but it can now handle even very large amounts of stored data. MySQL is written in C/C++ and is mostly compliant with the SQL standard. However, it adds many extensions and emphasizes speed and reliability over perfect compliance. A more detailed discussion about MySQL and SQL compliance can be found in the MySQL documentation on Compliance Standards.

Installing and Configuring MySQL on Ubuntu 20.04

Ubuntu users have a choice between two reliable Relational Database Management Systems (RDBMS), MySQL and MariaDB. MySQL has a long-standing edge in popularity, but there has been increased interest in MariaDB due to its performance advantages and added features. This guide compares the two database systems and provides instructions on how to install and use MySQL on Ubuntu 20.04.

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. Although known for its stability, MySQL is even more reliable if source-replica replication is configured. In replication, one MySQL server is typically designated the source. A source sends any database changes and data updates to one or more replica database servers. MySQL’s data replication procedure is flexible, and the replica servers do not need to be permanently connected to the source. This guide explains how to configure source-replica data replication in MySQL.

Securing MySQL Server

MySQL

MySQL is an open-source relational database management system. This guide will show you how to secure and audit a MySQL server. The name is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”, the abbreviation for Structured Query Language.

Working with MySQL Subqueries"

A subquery is an SQL (Structured Query Language) query that is nested within another SQL query. The command that the subquery is nested in is referred to as the parent query. Subqueries are used to pre-process data that is used in the parent query. Subqueries can be applied in SELECT, INSERT, UPDATE, and DELETE operations.

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. In other words, views are user-defined virtual tables. Views can be used to:

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. It can be fired either before or after an INSERT, UPDATE, or DELETE event.

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. These predefined subroutines help in moving the business logic to the database, which offers a few benefits:

Connect Metabase with MySQL for Data Exploration

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. Using mysqldump creates a logical backup and generates the SQL statements needed to reproduce the original database structure and data.

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. If the database cannot be started or the host system is inaccessible, the database can still be copied directly.

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. This guide will show you how to install Workbench using the Ubuntu package manager.

Install MySQL Workbench for Database Administration

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. MariaDB is considered a drop-in replacement for MySQL and would be sufficient if you just need a database system in general. See our MariaDB in CentOS 7 guide for installation instructions.

How to Install MySQL on Debian 8

How to Optimize MySQL Performance Using MySQLTuner

Running MySQL at optimal settings for specific resources helps handle larger server loads and prevents server slowdown. Generally, after tuning Apache to handle larger loads, it is beneficial to tune MySQL to additional connections.

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. Database clustering is particularly useful for high availability website configurations. Use two separate Linodes to configure database replication, each with private IPv4 addresses.

How to Install and Configure phpMyAdmin on CentOS 6

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. This guide will help beginners get started with MySQL on a Fedora 14 Linode. For purposes of this tutorial, it is assumed that you’ve followed the steps outlined in our Setting Up and Securing a Compute Instance, that your system is up to date, and that you’ve logged into your Linode as root via SSH.

How to Install MySQL on CentOS 6

How to Install MySQL on Debian 7

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

How to Install MySQL with phpMyAdmin on Ubuntu 12.04

How to Install MySQL with phpMyAdmin on Ubuntu 14.04

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.04 LTS (Precise Pangolin).

Install MySQL on Ubuntu 14.04

Using MySQL Relational Databases on Arch Linux

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. This guide will help beginners get started with MySQL on a Debian 6 (Squeeze) Linode. For purposes of this tutorial, it is assumed that you’ve followed the steps outlined in our Setting Up and Securing a Compute Instance, that your system is up to date, and that you’ve logged into your Linode as root via SSH.

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. Originally released in 1995, it remains a popular choice for developers as a database server.

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. It supports multiple MySQL servers and is a robust and easy alternative to using the MySQL command line client.

Use MySQL Relational Databases on Fedora 14

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. This guide will help beginners get started with MySQL on an Ubuntu 10.10 (Maverick) Linode. It is assumed that you’ve followed the steps outlined in our Setting Up and Securing a Compute Instance, that your system is up to date, and that you’ve logged into your Linode as root via SSH.

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. This guide will help beginners get started with MySQL on a Fedora 13 Linode. For purposes of this tutorial, it is assumed that you’ve followed the steps outlined in our Setting Up and Securing a Compute Instance, that your system is up to date, and that you’ve logged into your Linode as root via SSH.

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. This guide will help beginners get started with MySQL on an Ubuntu 10.04 LTS (Lucid) Linode. For purposes of this tutorial, we’ll assume you’ve followed the steps outlined in our Setting Up and Securing a Compute Instance, that your system is up to date, and that you’ve logged into your Linode as root via SSH. If you’re performing these steps as a standard user with sudo privileges, remember to prepend “sudo” to the commands shown below.

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. Most frequently it is deployed as part of the LAMP Stack. The database system is also easy to use and highly portable and is, in the context of many applications, extremely efficient. As MySQL is often a centralized data store for large amounts of mission critical data, making regular backups of your MySQL database is one of the most important disaster recovery tasks a system administrator can perform. This guide addresses a number of distinct methods for creating back ups of your database as well as restoring databases from backups.

Manage MySQL with phpMyAdmin on Ubuntu 9.10 (Karmic)

Manage MySQL with phpMyAdmin on Debian 5 (Lenny)

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. This is useful if you want to use administration tools on your local computer to do work on your server.

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. This guide will help beginners get started with MySQL on an Ubuntu Karmic Linode. For purposes of this tutorial, we’ll assume you’ve followed the steps outlined in our Setting Up and Securing a Compute Instance, that your system is up to date, and that you’ve logged into your Linode as root via SSH. If you’re performing these steps as a standard user with sudo privileges, remember to prepend “sudo” to the commands shown below.

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. Designating a separate server to be used solely by MySQL will allow the application’s web server to serve content more efficiently, while the database server will be able to respond more quickly.

Use MySQL Relational Databases on CentOS 5

MySQL is a popular database management system, used as the data storage provider for thousands of web and server applications. This guide will help beginners get started with MySQL on a CentOS 5 Linode. For purposes of this tutorial, we’ll assume you’ve followed the steps outlined in our Setting Up and Securing a Compute Instance, that your system is up to date, and that you’ve logged into your Linode as root via SSH.

Use MySQL Relational Databases on Fedora 12

MySQL is a popular database management system, used as the data storage provider for thousands of web and server applications. This guide will help beginners get started with MySQL on a Fedora 12 Linode. For purposes of this tutorial, it is assumed that you’ve followed the steps outlined in our Setting Up and Securing a Compute Instance, that your system is up to date, and that you’ve logged into your Linode as root via SSH.

Use MySQL Relational Databases on Ubuntu 8.04 (Hardy)

MySQL is a popular database management system, used as the data storage provider for thousands of web and server applications. This guide will help beginners get started with MySQL on an Ubuntu Hardy Linode. For purposes of this tutorial, we’ll assume you’ve followed the steps outlined in our Setting Up and Securing a Compute Instance, that your system is up to date, and that you’ve logged into your Linode as root via SSH. If you’re performing these steps as a standard user with sudo privileges, remember to prepend “sudo” to the commands shown below.

Use MySQL Relational Databases on Ubuntu 9.04 (Jaunty)

MySQL is a popular database management system, used as the data storage provider for thousands of web and server applications. This guide will help beginners get started with MySQL on an Ubuntu Jaunty Linode. For purposes of this tutorial, we’ll assume you’ve followed the steps outlined in our Setting Up and Securing a Compute Instance, that your system is up to date, and that you’ve logged into your Linode as root via SSH. If you’re performing these steps as a standard user with sudo privileges, remember to prepend “sudo” to the commands shown below.

Use MySQL Relational Databases on Debian 5 (Lenny)

MySQL is a popular database management system, used as the data storage provider for thousands of web and server applications. This guide will help beginners get started with MySQL on a Debian Lenny Linode. For purposes of this tutorial, we’ll assume you’ve followed the steps outlined in our Setting Up and Securing a Compute Instance, that your system is up to date, and that you’ve logged into your Linode as root via SSH.

Search Results

No Results

Filters

Backing Up MySQL Databases Using mysqldump

Create Physical Backups of your MariaDB or MySQL Databases

Install and Configure MySQL Workbench on Ubuntu 16.04

Install MySQL Workbench for Database Administration

Installing MySQL on CentOS 7

How to Install MySQL on Debian 8

How to Optimize MySQL Performance Using MySQLTuner

Configure Master-Master MySQL Database Replication

What is MySQL Master-Master Replication?

How to Install and Configure phpMyAdmin on CentOS 6

Using MySQL Relational Databases on Fedora 20

How to Install MySQL on CentOS 6

How to Install MySQL on Debian 7

How to Install and Configure phpMyAdmin on Debian 8

How to Install MySQL with phpMyAdmin on Debian 7

How to Install MySQL with phpMyAdmin on Ubuntu 12.04

How to Install MySQL with phpMyAdmin on Ubuntu 14.04

Deploy MySQL Relational Databases on Ubuntu 12.04

Install MySQL on Ubuntu 14.04

Using MySQL Relational Databases on Arch Linux

Use MySQL Relational Databases on Debian 6 (Squeeze)

Using MySQL Relational Databases on Gentoo

Manage MySQL with phpMyAdmin on Ubuntu 10.10 (Maverick)

Use MySQL Relational Databases on Fedora 14

Use MySQL Relational Databases on Ubuntu 10.10 (Maverick)

Use MySQL Relational Databases on Fedora 13

Use MySQL Relational Databases on Ubuntu 10.04

Back Up Your MySQL Databases

Manage MySQL with phpMyAdmin on Ubuntu 9.10 (Karmic)

Manage MySQL with phpMyAdmin on Debian 5 (Lenny)

Create an SSH Tunnel for MySQL Remote Access

Use MySQL Relational Databases on Ubuntu 9.10 (Karmic)

Standalone MySQL Server

Use MySQL Relational Databases on CentOS 5

Use MySQL Relational Databases on Fedora 12

Use MySQL Relational Databases on Ubuntu 8.04 (Hardy)

Use MySQL Relational Databases on Ubuntu 9.04 (Jaunty)

Use MySQL Relational Databases on Debian 5 (Lenny)

404

MySQL

MySQL Categories