78,699

Downloads

32,981

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 6/20/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	32981	Monday, April 10, 2017	approved
MySQL (Community Server) 5.7.17	10635	Monday, December 12, 2016	approved
MySQL (Community Server) 5.7.16	2936	Wednesday, October 12, 2016	approved
MySQL (Community Server) 5.7.15	1428	Tuesday, September 6, 2016	approved
MySQL (Community Server) 5.7.14	8047	Friday, July 29, 2016	approved
MySQL (Community Server) 5.7.13	790	Thursday, June 2, 2016	approved
MySQL (Community Server) 5.7.12	679	Monday, April 11, 2016	approved
MySQL (Community Server) 5.7.11.20160317	774	Thursday, March 17, 2016	approved
MySQL (Community Server) 5.7.11	920	Friday, February 5, 2016	approved
MySQL (Community Server) 5.7.10.20151209	782	Wednesday, December 9, 2015	approved
MySQL (Community Server) 5.7.10	250	Monday, December 7, 2015	approved
MySQL (Community Server) 5.7.9.20151029	597	Thursday, October 29, 2015	approved
MySQL (Community Server) 5.7.9	331	Wednesday, October 21, 2015	approved
MySQL (Community Server) 5.6.27	871	Wednesday, September 30, 2015	approved
MySQL (Community Server) 5.6.26	1345	Friday, July 24, 2015	approved
MySQL (Community Server) 5.6.25.20150611	739	Thursday, June 11, 2015	approved
MySQL (Community Server) 5.6.25	400	Saturday, May 30, 2015	approved
MySQL (Community Server) 5.6.24	861	Tuesday, April 7, 2015	approved
MySQL (Community Server) 5.6.23	1270	Monday, February 2, 2015	approved
MySQL (Community Server) 5.6.21	1932	Wednesday, September 24, 2014	approved
MySQL (Community Server) 5.6.20	721	Friday, August 1, 2014	approved
MySQL (Community Server) 5.6.19	366	Friday, July 18, 2014	approved
MySQL (Community Server) 5.6.15	1300	Tuesday, December 3, 2013	approved
MySQL (Community Server) 5.6.14	555	Friday, September 20, 2013	approved
MySQL (Community Server) 5.6.13	457	Wednesday, July 31, 2013	approved
MySQL (Community Server) 5.6.12.20130618	428	Tuesday, June 18, 2013	approved
MySQL (Community Server) 5.6.12.20130608	346	Saturday, June 8, 2013	approved
MySQL (Community Server) 5.6.12	381	Tuesday, June 4, 2013	approved
MySQL (Community Server) 5.6.11	353	Friday, May 24, 2013	approved
MySQL (Community Server) 5.5.30	804	Monday, February 4, 2013	approved
MySQL (Community Server) 5.5.29	344	Friday, December 21, 2012	approved
MySQL (Community Server) 5.5.28	398	Saturday, September 29, 2012	approved
MySQL (Community Server) 5.5.27	327	Monday, August 6, 2012	approved
MySQL (Community Server) 5.5.25.20120706	245	Friday, July 6, 2012	approved
MySQL (Community Server) 5.5.25	374	Sunday, June 3, 2012	approved
MySQL (Community Server) 5.5.24	372	Sunday, May 27, 2012	approved
MySQL (Community Server) 5.5.22	329	Wednesday, April 11, 2012	approved
MySQL (Community Server) 5.5.21	332	Saturday, February 25, 2012	approved
MySQL (Community Server) 5.5.20	300	Sunday, January 22, 2012	approved
MySQL (Community Server) 5.5.19	336	Saturday, December 17, 2011	approved
MySQL (Community Server) 5.5.18	310	Tuesday, November 29, 2011	approved
MySQL (Community Server) 5.5.14.1	371	Tuesday, August 23, 2011	approved
MySQL (Community Server) 5.5.13	382	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.