The MySQL version available on a server is determined by the server's Ubuntu release as shown in the table below.
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.
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.
The open files limit is the maximum number of file descriptors the operating system will allow processes such as MySQL to have.
To change a database user's password, follow the steps below. First, open your app in ServerPilot and click Databases.
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.
If your app was written for older versions of MySQL and is not compatible with strict SQL mode in MySQL 5.
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.
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.
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.
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:
This is an advanced tutorial. Careful! We cannot provide any assistance for this process nor can we help with any problems caused by it.
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.
It is possible to replace MySQL with MariaDB; however, you should not do so unless you are an experienced system administrator.
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.
After you've created a database in ServerPilot and installed phpMyAdmin on your app, you can import a database to your 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.
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.
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.
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.
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.
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.
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.