Articles

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....

Connect to MySQL Remotely

This is an advanced tutorial. It can sometimes be useful to enable remote connections to MySQL....

How to Access MySQL with the MySQL Root User

Introduction Normally, you access each MySQL database using a separate database user. In some...

How to Back Up MySQL Databases with AutoMySQLBackup

Introduction MySQL provides a command line utility, mysqldump, for exporting databases as raw...

How to Change the Database Password

If you forgot your database password, it's easy to reset it in ServerPilot. First, open your app...

How to Create a Database

Many PHP apps require a MySQL database to function, and these databases can be created quickly in...

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...

How to Export a Database Using phpMyAdmin

There are two ways to export a database with phpMyAdmin depending on the version installed on...

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,...

How to Install Adminer on Its Own App

Adminer is an alternative to phpMyAdmin that runs as a single PHP file to manage your apps'...

How to Install phpMyAdmin

In this tutorial, we'll show you how to install phpMyAdmin. This tutorial assumes you have...

How to Install phpMyAdmin as an App (on Its Own)

One copy of phpMyAdmin installed on a single app on your server will allow you to access all of...

How to Manage Your Database with Adminer

Adminer is an alternative to phpMyAdmin that runs as a single PHP file to manage your apps'...

How to Read the MySQL Slow Query Log

This is an advanced tutorial. Introduction For applications you are building where you've...

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...

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...