All Solutions
Complete list of Apps.
Kubernetes
Apps for DigitalOcean Kubernetes.
Blogs and Forums
Software for content and community.
Databases
SQL and NoSQL data stores.
Developer Tools
PaaS, containerization, CI/CD, and more.
Frameworks
Pre-configured application stacks.
Functions
Ship code faster with serverless functions.
Monitoring
Monitoring, logging, and more.
Agencies and Web Dev Shops
Apps for agencies and website development shops
Apps for Startups
Apps for your growing startup
Higher Education
1-Click Apps for students and educational institutions
Kubernetes administration and operations
1-Click Apps for managing Kubernetes environments
Security and VPN
Harden and secure your cloud environment
VERSION 5.7.23
OS Ubuntu 18.04
Description
The world's most popular open source database
Software Included
| Package | Version | License |
|---|---|---|
| MySQL server | 5.7.23 | GPL 2 with modifications |
| phpMyAdmin | 4.6.6 | GPL 2 |
| Apache | 2.4.29 | Apache 2 |
| PHP | 7.2 | PHP v3.01 |
| Certbot | 0.23.0 | Apache 2 |
Getting started after deploying MySQL
In addition to package installation, the One-Click also:
Enables the UFW firewall to allow only SSH (port
22, rate limited), HTTP (port80), and HTTPS (port443), and MySQL (3306) access.Sets the MySQL root password and runs
mysql_secure_installation.Sets the phpMyAdmin admin password.
Sets up the
debian-sys-maintuser in MySQL so the system’s init scripts for MySQL will work without requiring the MySQLrootuser password.After you create a MySQL One-Click Droplet:You can access phpMyAdmin immediately by visiting the Droplet’s IP address in your browser followed by
/phpmyadmin.You can log into the Droplet as
rootusing 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
/root/.digitalocean_password.You can get information about the PHP installation by logging into the Droplet and running
php -i.In addition, we recommend taking steps to further secure the phpMyAdmin installation, like enabling SSL for the connection from phpMyAdmin to the database server.The default landing page, shown when you visit the Droplet’s IP address, is located at
/var/www/html.The phpMyAdmin configuration file is located at
/etc/phpmyadmin/. To secure your connection, you will need a registered domain configured for your Droplet.
API Creation
In addition to creating a Droplet from the MySQL 1-Click App via the control panel, you can also use the DigitalOcean API.
As an example, to create a 4GB MySQL Droplet in the SFO2 region, you can use the following curl command. You’ll need to either save your API access token to an environment variable or substitute it into the command below.
curl -X POST -H 'Content-Type: application/json' \
-H 'Authorization: Bearer '$TOKEN'' -d \
'{"name":"choose_a_name","region":"sfo2","size":"s-2vcpu-4gb","image":"mysql-18-04"}' \
"https://api.digitalocean.com/v2/droplets"
More DigitalOcean Links
Technical overviews, how-tos, release notes, and support material
DevOps and development guidelines
Run your resources programmatically
Connect, share and learn