API v2 Changelog

< Back to Changelog

MySQL User Authentication Plug-in Management

Date: March 4, 2020

Tagged In: API v2

Author Andrew Starr-Bochicchio

The DigitalOcean managed databases API now supports configuring the user authentication plug-in for both new and existing MySQL users. This is useful when needing to connect to a MySQL 8.0 cluster using an application or older MySQL client that does not support the default caching_sha2_password authentication plug-in.

For example, to create a new MySQL user using the mysql_native_password authentication plug-in, send a POST request to /v2/databases/$DATABASE_ID/users with a JSON body like:

{
  "name": "php-app-01",
  "mysql_settings": {
    "auth_plugin": "mysql_native_password"
  }
}

For more details, see the full reference documentation for the managed databases API.