Description

This function lists all available versions of MySQL® and MariaDB.

Examples 




https://hostname.example.com:2087/cpsess##########/json-api/installable_mysql_versions?api.version=1




https://hostname.example.com:2087/cpsess##########/xml-api/installable_mysql_versions?api.version=1




whmapi1 installable_mysql_versions



{
  "data": {
    "versions": [
      {
        "version": "5.0",
        "server": "mysql"
      },
      {
        "version": "5.1",
        "server": "mysql"
      },
      {
        "version": "5.5",
        "server": "mysql"
      },
      {
        "version": "5.6",
        "server": "mysql"
      },
      {
        "version": "10.0",
        "server": "mariadb"
      }
    ]
  },
  "metadata": {
    "version": 1,
    "reason": "OK",
    "result": 1,
    "command": "installable_mysql_versions"
  }
}




<result>
    <data>
        <versions>
            <version>5.0</version>
            <server>mysql</server>
        </versions>
        <versions>
            <version>5.1</version>
            <server>mysql</server>
        </versions>
        <versions>
            <version>5.5</version>
            <server>mysql</server>
        </versions>
        <versions>
            <version>5.6</version>
            <server>mysql</server>
        </versions>
        <versions>
            <version>10.0</version>
            <server>mariadb</server>
        </versions>
    </data>
    <metadata>
        <version>1</version>
        <reason>OK</reason>
        <result>1</result>
        <command>installable_mysql_versions</command>
    </metadata>
</result>



Parameters

This function does not accept parameters.

Returns

ReturnTypeDescriptionPossible valuesExample
versionsarray of hashes

An array of hashes that contain information about the database version information.

This array of hashes includes data from the version and server returns. 

version

string

The version number.

The function returns this value in the versions hash.

A valid string, in major.minor format.10.0

server

string

The server's database engine.

The function returns this value in the versions hash.

  • mysql
  • mariadb
mariadb