Skip to content

Instantly share code, notes, and snippets.

@francistm
Last active October 28, 2018 03:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save francistm/1a61985722f5668f7694191844534797 to your computer and use it in GitHub Desktop.
Save francistm/1a61985722f5668f7694191844534797 to your computer and use it in GitHub Desktop.
MySQL 5.7 zip Windows Install

Install MySQL 5.7.x on Windows

  • Unzip zip files to <mysql_home>
  • Download my.ini to <mysql_home> and replace the <mysql_home> with absolute path, (\ should be replaced with /)
  • Run cmd with administrator privilege
    cd <path>\bin
    mysqld --defaults-file=<mysql_home>/my.ini --initialize-insecure
    mysqld --install-manual MySQL-5.7 --defaults-file=<mysql_home>/my.ini
    net start MySQL-5.7
    
  • Login and change root passowrd (default is no password)
[mysqld]
basedir = "<mysql_home>"
datadir = "<mysql_home>/data/mysql"
port = 3306
server_id = 1
log_error = "mysql_error.log"
pid_file = "mysql.pid"
socket = "<mysql_home>/socket/mysql.sock"
# Optional - Default Configuration
max_allowed_packet = 8M
key_buffer_size=16M
# Where do all the plugins live
plugin_dir = "<mysql_home>/lib/plugin"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment