← ServerPilot Docs

MySQL

Available MySQL Versions

The MySQL version available on a server is determined by the server's Ubuntu release as shown in the table below.

How to Increase the MySQL InnoDB Buffer Pool Size

The InnoDB buffer pool is MySQL's in-memory cache of the contents of tables and indexes. For optimal performance, the InnoDB buffer pool should be large to hold the full contents of all databases.

How to Increase the MySQL Open Table Cache Size

MySQL's open table cache allows opened tables to be reused by subsequent queries. For every table used by a query, MySQL needs to load the table's metadata and open file descriptors.

How to Increase the Open Files Limit for MySQL

The open files limit is the maximum number of file descriptors the operating system will allow processes such as MySQL to have.

How to Change the Database Password

To change a database user's password, follow the steps below. First, open your app in ServerPilot and click Databases.

How to Create a Database

Many PHP apps require a MySQL database. You can create MySQL databases for apps in ServerPilot. First, open your app in ServerPilot and go to the Databases tab.

How to Disable Strict SQL Mode in MySQL 5.7

If your app was written for older versions of MySQL and is not compatible with strict SQL mode in MySQL 5.

How to Export a Database Using the Command Line

If you're not familiar with using SSH, it's easier to export a database using Adminer. However, if your database is very large (for example, more than 1GB), it can be easier to export a database using MySQL from the command line.

How to Upgrade MySQL 5.5 to 5.6 on Ubuntu 14.04

Don't upgrade unless you need to! Database upgrades are risky. If something goes wrong during the update, all of your data may be lost.

How to Import a Database Using the Command Line

If you're not familiar with using SSH, it's easier to import a database using Adminer. However, if your database is very large (for example, more than 1GB), it can be easier to import a database using MySQL from the command line.

How to Reset the MySQL Root User's Password

ServerPilot configures MySQL to manage databases on your server. Typically, when logged into SSH as the root user, you would only need to type the following at the command line (SSH) prompt to access MySQL:

Connect to MySQL Remotely

This is an advanced tutorial. Careful! We cannot provide any assistance for this process nor can we help with any problems caused by it.

How to Access MySQL with the MySQL Root User

Introduction Normally, you access each MySQL database using a separate database user. In some cases—such as accessing many different databases from the command line—it is easier to have a single MySQL account that can access any database.

Using MariaDB

It is possible to replace MySQL with MariaDB; however, you should not do so unless you are an experienced system administrator.

How to Export a Database Using phpMyAdmin

There are two ways to export a database with phpMyAdmin depending on the version installed on your app. Exporting from a Newer Version of phpMyAdmin The latest version offers the simplest means.

How to Import a Database Using phpMyAdmin

After you've created a database in ServerPilot and installed phpMyAdmin on your app, you can import a database to your app.

How to Install Adminer on Its Own App

One copy of Adminer installed on a single app on your server will allow you to access all of your apps' databases; however, if you don't want Adminer installed on one of your existing apps, you can install it on its own with the same result.

How to Install phpMyAdmin

In this tutorial, we'll show you how to install phpMyAdmin. This tutorial assumes you have already connected your server to ServerPilot and that you have created at least one app on the server.

How to Install phpMyAdmin on Its Own App

One copy of phpMyAdmin installed on a single app on your server will allow you to access all of your apps' databases; however, if you don't want phpMyAdmin installed on one of your existing apps, you can install it on its own with the same result.

How to Manage Your Database with Adminer

Adminer is an alternative to phpMyAdmin that runs as a single PHP file to manage your apps' databases. Just as with phpMyAdmin, one installation of Adminer can manage MySQL for all of the apps on your server.

An Overview of Files and Data to Back Up

Introduction If you are configuring backups of a server, you need to know what data to back up. This information is useful whether you are making on-server backups or configuring automated backups to other servers or cloud storage services.

How to Read the MySQL Slow Query Log

This is an advanced tutorial. Introduction For applications you are building where you've designed your own database schema, it is common to need to debug performance issues when databases grow very large.

How to Use MySQL from the Command Line

Introduction MySQL is a database server that your apps such as WordPress use to store data. In some cases, you may want to interact with MySQL while SSH'd into your server.

Launch your first site in 5 minutes