74,702

Downloads

30,038

Downloads of v 5.7.18

4/10/2017

Last update

MySQL (Community Server)

5.7.18

Private CDN cached downloads available for licensed customers. Never experience 404 breakages again! Learn more...

This package was approved as a trusted package on 5/15/2018.

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.

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

C:\> choco install mysql

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

C:\> choco upgrade mysql

Files

Hide

tools\chocolateyInstall.ps1 Show

# MySql Package
$toolsDir = "$(Split-Path -parent $MyInvocation.MyCommand.Definition)"
$packageName = 'mysql'
$packageType = 'msi'
$silentArgs = '/passive'
$url = 'https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.18-win32.zip'
$url64 = 'https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.18-winx64.zip'

$binRoot = Get-BinRoot
$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)"


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

$tempDir = "$env:TEMP\chocolatey\$($packageName)"
if (![System.IO.Directory]::Exists($tempDir)) {[System.IO.Directory]::CreateDirectory($tempDir) | Out-Null}

$file = Join-Path $tempDir "$($packageName).zip"
Get-ChocolateyWebFile "$packageName" "$file" "$url" "$url64"

Get-ChocolateyUnzip "$file" "$installDir"

# find the unpack directory
$installedContentsDir = get-childitem $installDir -include 'mysql*' | Sort-Object -Property LastWriteTime -Desc | select -First 1
# shut down service if running
try {
  write-host "Shutting down MySQL if it is running"
  Start-ChocolateyProcessAsAdmin "cmd /c NET STOP MySQL"
  Start-ChocolateyProcessAsAdmin "cmd /c sc delete MySQL"
} 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=C:\\ProgramData\\MySQL\\data
"@ | 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='C:\ProgramData\MySQL\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"
# turn on the service
Start-ChocolateyProcessAsAdmin "cmd /c NET START MySQL"

Virus Scan Results

mysql.5.7.18.nupkg (f1b8ac37d712) - ## / 59 - Log in or click on link to see number of positives
mysql-5.7.18-winx64.zip (6a3b2d070200) - ## / 58 - Log in or click on link to see number of positives
mysql-5.7.18-win32.zip (a4313a358274) - ## / 57 - Log in or click on link to see number of positives

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.

Dependencies

- 7zip.commandline

Package Maintainer(s)

ferventcoder

Software Author(s)

Oracle

Version History

Version	Downloads	Last updated	Status
MySQL (Community Server) 5.7.18	30038	Monday, April 10, 2017	approved
MySQL (Community Server) 5.7.17	10586	Monday, December 12, 2016	approved
MySQL (Community Server) 5.7.16	2905	Wednesday, October 12, 2016	approved
MySQL (Community Server) 5.7.15	1408	Tuesday, September 6, 2016	approved
MySQL (Community Server) 5.7.14	8024	Friday, July 29, 2016	approved
MySQL (Community Server) 5.7.13	759	Thursday, June 2, 2016	approved
MySQL (Community Server) 5.7.12	663	Monday, April 11, 2016	approved
MySQL (Community Server) 5.7.11.20160317	754	Thursday, March 17, 2016	approved
MySQL (Community Server) 5.7.11	897	Friday, February 5, 2016	approved
MySQL (Community Server) 5.7.10.20151209	761	Wednesday, December 9, 2015	approved
MySQL (Community Server) 5.7.10	230	Monday, December 7, 2015	approved
MySQL (Community Server) 5.7.9.20151029	583	Thursday, October 29, 2015	approved
MySQL (Community Server) 5.7.9	309	Wednesday, October 21, 2015	approved
MySQL (Community Server) 5.6.27	833	Wednesday, September 30, 2015	approved
MySQL (Community Server) 5.6.26	1313	Friday, July 24, 2015	approved
MySQL (Community Server) 5.6.25.20150611	716	Thursday, June 11, 2015	approved
MySQL (Community Server) 5.6.25	361	Saturday, May 30, 2015	approved
MySQL (Community Server) 5.6.24	841	Tuesday, April 7, 2015	approved
MySQL (Community Server) 5.6.23	1244	Monday, February 2, 2015	approved
MySQL (Community Server) 5.6.21	1912	Wednesday, September 24, 2014	approved
MySQL (Community Server) 5.6.20	699	Friday, August 1, 2014	approved
MySQL (Community Server) 5.6.19	346	Friday, July 18, 2014	approved
MySQL (Community Server) 5.6.15	1273	Tuesday, December 3, 2013	approved
MySQL (Community Server) 5.6.14	528	Friday, September 20, 2013	approved
MySQL (Community Server) 5.6.13	436	Wednesday, July 31, 2013	approved
MySQL (Community Server) 5.6.12.20130618	410	Tuesday, June 18, 2013	approved
MySQL (Community Server) 5.6.12.20130608	327	Saturday, June 8, 2013	approved
MySQL (Community Server) 5.6.12	359	Tuesday, June 4, 2013	approved
MySQL (Community Server) 5.6.11	331	Friday, May 24, 2013	approved
MySQL (Community Server) 5.5.30	768	Monday, February 4, 2013	approved
MySQL (Community Server) 5.5.29	328	Friday, December 21, 2012	approved
MySQL (Community Server) 5.5.28	370	Saturday, September 29, 2012	approved
MySQL (Community Server) 5.5.27	311	Monday, August 6, 2012	approved
MySQL (Community Server) 5.5.25.20120706	215	Friday, July 6, 2012	approved
MySQL (Community Server) 5.5.25	352	Sunday, June 3, 2012	approved
MySQL (Community Server) 5.5.24	336	Sunday, May 27, 2012	approved
MySQL (Community Server) 5.5.22	314	Wednesday, April 11, 2012	approved
MySQL (Community Server) 5.5.21	301	Saturday, February 25, 2012	approved
MySQL (Community Server) 5.5.20	274	Sunday, January 22, 2012	approved
MySQL (Community Server) 5.5.19	311	Saturday, December 17, 2011	approved
MySQL (Community Server) 5.5.18	287	Tuesday, November 29, 2011	approved
MySQL (Community Server) 5.5.14.1	332	Tuesday, August 23, 2011	approved
MySQL (Community Server) 5.5.13	357	Tuesday, August 23, 2011	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.