Downloads:

116,956

Downloads of v 8.0.18:

2,977

Last Update:

14 Oct 2019

Package Maintainer(s):

Software Author(s):

  • Oracle Corporation and/or its affiliates

Tags:

mysql database admin

MySQL (Community Server)

8.0.18 | Updated: 14 Oct 2019

Downloads:

116,956

Downloads of v 8.0.18:

2,977

Maintainer(s):

Software Author(s):

  • Oracle Corporation and/or its affiliates

Tags:

mysql database admin

MySQL (Community Server) 8.0.18

All Checks are Passing

2 Passing Test

Validation Testing Passed

Verification Testing Passed

Details

To install MySQL (Community Server), run the following command from the command line or from PowerShell:

>

To upgrade MySQL (Community Server), run the following command from the command line or from PowerShell:

>

To uninstall MySQL (Community Server), run the following command from the command line or from PowerShell:

>

NOTE: This applies to both open source and commercial editions of Chocolatey.

1. Ensure you are set for organizational deployment

Please see the organizational deployment guide

  • Open Source or Commercial:
    • Proxy Repository - Create a proxy nuget repository on Nexus, Artifactory Pro, or a proxy Chocolatey repository on ProGet. Point your upstream to https://chocolatey.org/api/v2. Packages cache on first access automatically. Make sure your choco clients are using your proxy repository as a source and NOT the default community repository. See source command for more information.
    • You can also just download the package and push it to a repository Download

3. Enter your internal repository url

(this should look similar to https://chocolatey.org/api/v2)

4. Choose your deployment method:


choco upgrade mysql -y --source="'STEP 3 URL'" [other options]

See options you can pass to upgrade.

See best practices for scripting.

Add this to a PowerShell script or use a Batch script with tools and in places where you are calling directly to Chocolatey. If you are integrating, keep in mind enhanced exit codes.

If you do use a PowerShell script, use the following to ensure bad exit codes are shown as failures:


choco upgrade mysql -y --source="'STEP 3 URL'" 
$exitCode = $LASTEXITCODE

Write-Verbose "Exit code was $exitCode"
$validExitCodes = @(0, 1605, 1614, 1641, 3010)
if ($validExitCodes -contains $exitCode) {
  Exit 0
}

Exit $exitCode


- name: Ensure mysql installed
  win_chocolatey:
    name: mysql
    state: present
    version: 8.0.18
    source: STEP 3 URL

See docs at https://docs.ansible.com/ansible/latest/modules/win_chocolatey_module.html.

Coming early 2020! Central Managment Reporting available now! More information...


chocolatey_package 'mysql' do
  action    :install
  version  '8.0.18'
  source   'STEP 3 URL'
end

See docs at https://docs.chef.io/resource_chocolatey_package.html.


Chocolatey::Ensure-Package
(
    Name: mysql,
    Version: 8.0.18,
    Source: STEP 3 URL
);

Requires Otter Chocolatey Extension. See docs at https://inedo.com/den/otter/chocolatey.


cChocoPackageInstaller mysql
{
   Name     = 'mysql'
   Ensure   = 'Present'
   Version  = '8.0.18'
   Source   = 'STEP 3 URL'
}

Requires cChoco DSC Resource. See docs at https://github.com/chocolatey/cChoco.


package { 'mysql':
  provider => 'chocolatey',
  ensure   => '8.0.18',
  source   => 'STEP 3 URL',
}

Requires Puppet Chocolatey Provider module. See docs at https://forge.puppet.com/puppetlabs/chocolatey.


salt '*' chocolatey.install mysql version="8.0.18" source="STEP 3 URL"

See docs at https://docs.saltstack.com/en/latest/ref/modules/all/salt.modules.chocolatey.html.

5. If applicable - Chocolatey configuration/installation

See infrastructure management matrix for Chocolatey configuration elements and examples.

This package was approved as a trusted package on 14 Oct 2019.

Description

MySQL Community Edition is the freely downloadable version of the world's most popular open source database. It is available under the GPL license and is supported by a huge and active community of open source developers.

Please Note: This is an automatically updated package. If you find it is
out of date by more than a day or two, please contact the maintainer(s) and
let them know the package is no longer updating correctly.

Package Parameters

The package accepts the following optional parameters:

  • /installLocation - filesystem location for mysql binaries
  • /dataLocation - filesystem location for mysql data
  • /port - numberic TCP listening port
  • /serviceName - custom name for the Windows services entry

Example: choco install mysql --params "/port:3307 /serviceName:AltSQL"

tools\chocolateyInstall.ps1 
$ErrorActionPreference = 'Stop';

$url = 'https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.18-winx64.zip'
$checksum = '683b7a901c6571951a3948f02f2d647cc7d10ca1a2dd645914a6064287a4d5f0'
$checksumType = 'sha256'

$pp = Get-PackageParameters

$packageName = 'mysql'
$binRoot = if ($pp.installLocation) { $pp.installLocation } else { Get-ToolsLocation }
$installDir = Join-Path $binRoot "$packageName"
$installDirBin = "$($installDir)\current\bin"
Write-Host "Adding `'$installDirBin`' to the path and the current shell path"
Install-ChocolateyPath "$installDirBin"
$env:Path = "$($env:Path);$($installDirBin)"
$port = if ($pp.Port) { $pp.Port } else { 3306 }
$serviceName = if ($pp.serviceName) { $pp.serviceName } else { "MySQL" }
$dataDir = if ($pp.dataLocation) { Join-Path $pp.dataLocation "$packageName" } else { "C:\ProgramData\MySQL" }

if (![System.IO.Directory]::Exists($installDir)) {[System.IO.Directory]::CreateDirectory($installDir) | Out-Null}

$packageArgs = @{
  packageName    = $env:ChocolateyPackageName
  unzipLocation  = $installDir
  url           = $url
  checksum      = $checksum
  checksumType  = $checksumType
}

Install-ChocolateyZipPackage  @packageArgs

# find the unpack directory
$installedContentsDir = get-childitem $installDir -include 'mysql*' | Sort-Object -Property LastWriteTime -Desc | Select-Object -First 1

# shut down service if running
try {
  write-host "Shutting down MySQL if it is running"
  Start-ChocolateyProcessAsAdmin "cmd /c NET STOP $serviceName"
  Start-ChocolateyProcessAsAdmin "cmd /c sc delete $serviceName"
} catch {
  # no service installed
}

# delete current bin directory contents
if ([System.IO.Directory]::Exists("$installDirBin")) {
  Write-Host "Clearing out the contents of `'$installDirBin`'."
  Start-Sleep 3
  [System.IO.Directory]::Delete($installDirBin,$true)
}

# copy the installed directory into the current dir
Write-host "Copying contents of `'$installedContentsDir`' to `'$($installDir)\current`'."
[System.IO.Directory]::CreateDirectory("$installDirBin") | Out-Null
Copy-Item "$($installedContentsDir)\*" "$($installDir)\current" -Force -Recurse

$iniFileDest = "$($installDir)\current\my.ini"
if (!(Test-Path($iniFileDest))) {
  Write-Host "No existing my.ini. Creating default '$iniFileDest' with default locations for datadir."

@"
[mysqld]
basedir=$($installDir.Replace("\","\\"))\\current
datadir=$($dataDir.Replace("\","\\"))\\data
port=$port
"@ | Out-File $iniFileDest -Force -Encoding ASCII
}

# initialize everything
# https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization-mysqld.html
Write-Host "Initializing MySQL if it hasn't already been initialized."
try {

  $defaultDataDir= Join-Path $dataDir "data"
  if (![System.IO.Directory]::Exists($defaultDataDir)) {[System.IO.Directory]::CreateDirectory($defaultDataDir) | Out-Null}
  Start-ChocolateyProcessAsAdmin "cmd /c '$($installDirBin)\mysqld' --defaults-file='$iniFileDest' --initialize-insecure"
} catch {
  write-host "MySQL has already been initialized"
}

# install the service itself
write-host "Installing the mysql service"
Start-ChocolateyProcessAsAdmin "cmd /c '$($installDirBin)\mysqld' --install $serviceName"
# turn on the service
Start-ChocolateyProcessAsAdmin "cmd /c NET START $serviceName"

In cases where actual malware is found, the packages are subject to removal. Software sometimes has false positives. Moderators do not necessarily validate the safety of the underlying software, only that a package retrieves software from the official distribution point and/or validate embedded software against official distribution point (where distribution rights allow redistribution).

Chocolatey Pro provides runtime protection from possible malware.

Version Downloads Last Updated Status
MySQL (Community Server) 8.0.18 2977 Monday, October 14, 2019 Approved
MySQL (Community Server) 8.0.17 6184 Monday, July 22, 2019 Approved
MySQL (Community Server) 8.0.16.20190513 3804 Monday, May 13, 2019 Approved
MySQL (Community Server) 8.0.16 2142 Thursday, April 25, 2019 Approved
MySQL (Community Server) 8.0.15 3958 Saturday, February 2, 2019 Approved
MySQL (Community Server) 8.0.14 1036 Monday, January 21, 2019 Approved
MySQL (Community Server) 8.0.13 1593 Thursday, December 27, 2018 Approved
MySQL (Community Server) 5.7.18 45289 Monday, April 10, 2017 Approved
MySQL (Community Server) 5.7.17 11286 Monday, December 12, 2016 Approved
MySQL (Community Server) 5.7.16 3052 Wednesday, October 12, 2016 Approved
Discussion for the MySQL (Community Server) Package

Ground Rules:

  • This discussion is only about MySQL (Community Server) and the MySQL (Community Server) package. If you have feedback for Chocolatey, please contact the Google Group.
  • This discussion will carry over multiple versions. If you have a comment about a particular version, please note that in your comments.
  • The maintainers of this Chocolatey Package will be notified about new comments that are posted to this Disqus thread, however, it is NOT a guarantee that you will get a response. If you do not hear back from the maintainers after posting a message below, please follow up by using the link on the left side of this page or follow this link to contact maintainers. If you still hear nothing back, please follow the package triage process.
  • Tell us what you love about the package or MySQL (Community Server), or tell us what needs improvement.
  • Share your experiences with the package, or extra configuration or gotchas that you've found.
  • If you use a url, the comment will be flagged for moderation until you've been whitelisted. Disqus moderated comments are approved on a weekly schedule if not sooner. It could take between 1-5 days for your comment to show up.
comments powered by Disqus