Articles
Introduction If you are configuring backups of a server, you need to know what data to back up....
Connect to MySQL RemotelyThis is an advanced tutorial. It can sometimes be useful to enable remote connections to MySQL....
How to Access MySQL with the MySQL Root UserIntroduction Normally, you access each MySQL database using a separate database user. In some...
How to Back Up MySQL Databases with AutoMySQLBackupIntroduction MySQL provides a command line utility, mysqldump, for exporting databases as raw...
How to Change the Database PasswordIf you forgot your database password, it's easy to reset it in ServerPilot. First, open your app...
How to Create a DatabaseMany 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.7If your app was written for older versions of MySQL and is not compatible with strict SQL mode in...
How to Export a Database Using phpMyAdminThere are two ways to export a database with phpMyAdmin depending on the version installed on...
How to Export a Database Using the Command LineIf you're not familiar with using SSH, it's easier to export a database using Adminer. However,...
How to Install Adminer on Its Own AppAdminer is an alternative to phpMyAdmin that runs as a single PHP file to manage your apps'...
How to Install phpMyAdminIn 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 AdminerAdminer is an alternative to phpMyAdmin that runs as a single PHP file to manage your apps'...
How to Read the MySQL Slow Query LogThis 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.04Don't upgrade unless you need to! Database upgrades are risky. If something goes wrong during...
How to Use MySQL from the Command LineIntroduction MySQL is a database server that your apps such as WordPress use to store data. In...