MySQL

57 Guides Available

SQL Server Security Best Practices

SQL Server security is perhaps one of the most overlooked facets of database server maintenance. Without taking the necessary precautions, an instance of SQL Server can be ripe for abuse and failure.

Database Sharding: Concepts, Examples, and Strategies

Many software applications use a relational database management system (RDBMS) to store data. As the database grows, it becomes more time-and-storage intensive to store the data.

SQL Security and User Management

User management and permissions are essential to SQL database security. Typically, SQL database security schemes consist of one or more users, their authentication, and permissions.

How to Use SQL Indexes

In relational database systems, a database index is an extremely powerful tool for data retrieval. In this guide, you learn about unique indexes, primary keys, and composite primary keys.

SQL Grouping and Totaling

One of the most powerful aspects of SQL is the ability to perform data aggregation. Two of the most powerful SQL data aggregation tools are grouping and totaling.

Choosing the proper data type for a table column is an important decision. It reduces the need for data type conversions, enhances the performance of database queries, and minimizes storage requirements.

SQL Joins

Traditionally, you pull data from two or more tables using a WHERE clause in a query.

SQL Commands: Getting Started

In today’s world of increased digitization, big data, and cloud computing, data management is amongst the most important skills a software engineer can have.

List of Databases - Most Popular

Databases power nearly every digital platform on the planet: From websites, to blogs, to social media, to streaming services.

An Overview of MySQL

Many programs need to save or store data for later use and read data that is recorded.

How to Install and configure MySQL on Ubuntu 20.04

Ubuntu users have a choice between two reliable Relational Database Management Systems (RDBMS), MySQLand 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.

Connect to a MySQL or MariaDB Database

This guide shows you how to connect to a remote MySQL or MariaDB database using the command line.

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.

MySQL Replication: Configure a Source-Replica Setup in MySQL

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

How to Secure 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.

How to Work with MySQL Subqueries

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

How to Use 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 Tutorial

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 - A Tutorial

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 Metabase Metabase provides an interface to query data on your browser.

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.

Use mysqldump to Back Up MySQL or MariaDB

MySQLand MariaDBinclude the mysqldumputility to simplify the process to create a backup of a database or system of databases.

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.

Install MySQL CentOS 7: A How To

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.

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?

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.

How to Install MySQL on Debian 7

MySQL is a popular database management system used for web and server applications.

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

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.

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 LTS (Lucid)

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.