MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It uses a relational database and SQL (Structured Query Language) to manage its data.
MySQL can be used to store, secure, and retrieve data for many kinds of applications, including data warehousing, e-commerce, and logging applications. It is most often associated with web-based applications and online publishing.
DigitalOcean’s MySQL and phpMyAdmin One-Click Application image quickly deploys a Ubuntu server with MySQL already installed, as well as phpMyAdmin to help manage the database server and Certbot, a tool to automate HTTPS setup and management.
Droplets created using this One-Click have the following software components:
|MySQL server||Latest from APT|
|phpMyAdmin||Latest from APT|
|Apache||Latest from APT|
|PHP||Latest from APT|
|Certbot||Latest from APT|
In addition to the package installation, the One-Click also:
Enables the UFW firewall to allow only SSH (port
22, rate limited), HTTP (port
80), and HTTPS (port
443), and MySQL (
Sets the MySQL root password and runs
Sets the phpMyAdmin admin password.
Sets up the
debian-sys-maint user in MySQL so the system’s init scripts for MySQL will work without requiring the MySQL
root user password.
After you create a phpMyAdmin One-Click Droplet:
You can access phpMyAdmin immediately by visiting the Droplet’s IP address in your browser.
You can log into the Droplet as
root using either the password emailed to you or with an SSH key, if you added one during creation.
The MySQL root password and phpMyAdmin admin password are in
You can get information about the PHP installation by logging into the Droplet and running
In addition, we recommend taking steps to further secure the phpMyAdmin installation, like enabling SSL for the connection from phpMyAdmin to the database server.
Once the MySQL and phpMyAdmin Droplet is running, you can start working on projects. Here are a few examples of next steps you can take:
You can implement some additional security measures to protect the database.
If you want to change where MySQL stores its data, like moving it to a different storage device, you can relocate the data directory.
For more advanced setups, learn how to manage MySQL infrastructure with SaltStack, a configuration management system.
You can view the phpMyAdmin documentation for more information on usage and customization.